Patient Discharge Data File Documentation

STATE OF CALIFORNIA
OFFICE OF STATEWIDE HEALTH PLANNING AND DEVELOPMENT
Patient Discharge Data
File Documentation
January-December 2004
PUBLIC VERSION
COMMA-DELIMITED TEXT FORMAT
CD-ROM
July 2005
i
CONTENTS
Introduction
Masked Variables ………………………………………………………………………………………………………….1
Importing Notes……………………………………………………………………………………………………………..3
Facility Exceptions …………………………………………………………………………………………………………4
Variable Changes Over Time…………………………………………………………………………………………..5
Missing/Invalid Data Values…………………………………………………………………………………………….6
Data Element Field Descriptions
Hospital Identification Number…………………………………………………………………………………………7
Type of Care …………………………………………………………………………………………………………………8
Age in Years …………………………………………………………………………………………………………………9
Age (20 Age Categories) ……………………………………………………………………………………………..10
Age (5 Age Categories) ………………………………………………………………………………………………..11
Sex…………………………………………………………………………………………………………………………….12
Ethnicity ……………………………………………………………………………………………………………………..13
Race…………………………………………………………………………………………………………………………..14
Patient Zip Code ………………………………………………………………………………………………………….15
County of Patient’s Residence……………………………………………………………………………………….16
Length of Stay……………………………………………………………………………………………………………..17
Admission – Quarter ……………………………………………………………………………………………………..18
Admission – Year………………………………………………………………………………………………………….19
Source of Admission…………………………………………………………………………………………………….20
Type of Admission ……………………………………………………………………………………………………….21
Disposition of Patient ……………………………………………………………………………………………………22
Pre-hospital Care and Resuscitation (Do Not Resuscitate) ………………………………………………..23
Expected Source of Payment – Payer Category ……………………………………………………………….24
Expected Source of Payment – Payer Type of Coverage …………………………………………………..25
Expected Source of Payment – Payer Plan Code Number …………………………………………………26
Total Charges ……………………………………………………………………………………………………………..27
External Cause of Injury – Principal E-Code …………………………………………………………………….28
External Cause of Injury -Other E-Codes ……………………………………………………………………….29
Major Diagnostic Category (MDC) ………………………………………………………………………………….30
Diagnosis Related Group (DRG) ……………………………………………………………………………………31
Principal Diagnosis ………………………………………………………………………………………………………32
Condition Present at Admission (Principal Diagnosis)……………………………………………………….33
Principal Procedure………………………………………………………………………………………………………34
Days from Admission to Principal Procedure……………………………………………………………………35
Other Diagnoses………………………………………………………………………………………………………….36
Condition Present at Admission (Other Diagnoses) ………………………………………………………….37
Other Procedures…………………………………………………………………………………………………………38
Days from Admission to Other Procedures………………………………………………………………………39
Appendices
Appendix A County Names and Codes………………………………………………………………….. A – 1
Appendix B Major Diagnostic Categories (MDCs) ………………………………………………….. B – 1
Appendix C Diagnosis Related Groups (DRGs)……………………………………………………….C – 1
Appendix D Data Exceptions (as reported) ……………………………………………………………..D – 1
Appendix E Plan Codes, Expected Source of Payment……………………………………………. E – 1
Appendix F Hospital Listing………………………………………………………………………………….. F – 1
Appendix G Manual Abstract Reporting Form ………………………………………………………….G – 1
Appendix H Comma-Delimited Field List…………………………………………………………………H – 1
Appendix I Masked Variable Frequencies ……………………………………………………………… I – 1
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 1 2004 Public Patient Discharge Data

INTRODUCTION
Patient Discharge Data: Public Patient-Level Dataset
The California Office of Statewide Health Planning and Development (OSHPD) provide a public dataset
of the Patient Discharge Database available for purchase on compact disc (CD). The data is made
available by OSHPD once it has been screened by the automated reporting software and corrected by
the individual hospitals. The public patient-level dataset includes patient zip code, demographic
variables and clinical information.
The public dataset is comprised of a record for each inpatient discharged from a licensed acute care
hospital. This includes: General Acute Care Hospitals, Acute Psychiatric Hospitals, Chemical
Dependency Recovery Hospitals, and Psychiatric Health Facilities. (Note: the only exceptions are
records not reported by some California State Hospitals; see the State Hospitals discussion on page
four.)
The patient discharge dataset is available for discharges in each calendar year. The data on CD-ROM are
stored on one CD containing three zipped data files and a full set of documentation files. The discharge
records are divided into three sets by the geography of the reporting hospitals. One file contains discharge
records from hospitals in Los Angeles County, another file contains discharges from the seven other counties
in Southern California and the third file contains discharges from hospitals in the remaining 50 Northern
California Counties.
MASKED VARIABLES
To protect patient confidentiality, those records with unique combinations of a select set of demographic
variables will have one or more of those variables masked to make sure the files are de-identified. Each
unique record will have the minimum number of fields masked to ensure it is no longer unique. The
variable masking will occur in the following order:
ORDER OF
MASKING DATA FIELDS SUBJECT TO MASKING
1st
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
Age in years (at admission)
Ethnicity
Race
Sex
Age Category 20 (20 Age Categories)
Age Category 5 (5 Age Categories)
Small County Groups*
Admit Quarter
Patient Zip Code **
OSHPD ID
*Small counties with total populations of 30,000 or less are grouped into 3
categories: Central (CE), Northeastern (NE), and Northwestern (NW). Ten
counties were grouped in 2003: Central: Alpine, Inyo, Mariposa, Mono;
Northeastern: Modoc, Plumas, Sierra; Northwestern: Colusa, Glenn, and Trinity.
**Five-digit zip will be masked to three-digits; if record is still unique, zip will be
totally masked with an asterisk.
General assistance is available by calling OSHPD’s Healthcare Information Resource Center at
(916) 322-2814.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 2 2004 Public Patient Discharge Data

Don't use plagiarized sources. Get Your Custom Essay on
Patient Discharge Data File Documentation
Just from $9/Page
Order Essay

Public Discharge Dataset
Data Fields in 2004 Public Discharge Dataset
Percent Remaining
Unmasked
For Variables
Subject to Masking
Hospital Identification Number 100.0%
Type (level) of Care
Age in Years 53.7%
Age (20 Categories) 86.6%
Age (5 Categories) 93.2%
Sex 81.7%
Ethnicity 69.9%
Race 73.8%
Zip Code (5 digits masked to 3 digits) 98.3%
Zip Code (3 digits masked to 0 digits) 99.6%
County of Patient’s Residence (or Small County Groups) 100.0%
Length of Stay
Quarter Admitted 96.6%
Year Admitted
Source of Admission
Type of Admission
Disposition of Patient
Pre-hospital Care and Resuscitation (Do Not Resuscitate Order)
Expected Principal Source of Payment – Payer Category
Expected Principal Source of Payment – Type of Coverage
Expected Principal Source of Payment – Plan Code Number
Total Charges
Principal External Cause of Injury (E-Code)
Other External Cause of Injuries (up to 4 Other E-Codes)
Major Diagnostic Category
Diagnosis Related Group
Principal Diagnosis
Condition Present at Admission (for Principal Diagnosis)
Principal Procedure
Days from Admission to Principal Procedure
Other Diagnoses (24 Other Diagnoses)
Condition Present at Admission (for Other Diagnoses)
Other Procedures (20 Other Procedures)
Days From Admission to Other Procedures
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 3 2004 Public Patient Discharge Data

IMPORTING NOTES
The fields listed below contain numeric codes, which are not numeric values; most PC software will treat
these fields as numeric values unless formatted otherwise. Thus, when importing the data into your software,
these fields should be formatted as text or alphanumeric to retain the leading and trailing zeros. Also, when
a text variable is masked, the field value is an asterisk, which may cause errors if imported as numeric.
• OSHPD-Hospital Identification Number
• 5 Age Category and 20 Age Category Fields
• Sex
• Ethnicity
• Race
• Patient Zip Code
• County of Patient’s Residence
• Admission Quarter
• Expected Principal Source of Payment – Plan Code Number
• MDC
• DRG
• All diagnosis code fields (principal and other)
• All procedure code fields (principal and other)
It is especially important that all Diagnosis and Procedure code fields be formatted as “text.” These fields are
comprised of ICD-9-CM codes, some of which begin with alpha characters that cannot be read if not
formatted as text. Also, many ICD-9-CM codes have leading and/or trailing zeros. For example, the ICD-9-
CM code for Salmonella Gastroenteritis is “003.0”. If it is not formatted as text, it will appear as “3”, which is
the numeric value, but is not the valid diagnostic code for Salmonella Gastroenteritis.
It is not absolutely essential but is recommended, to maintain leading zeros in the other codes that contain
leading zeros (Hospital Identification Number, Patient’s County of Residence, MDC, DRG, and Payer Plan
Code Number). When these fields are formatted as “text,” the number of digits in each respective field will
then remain constant. For example, Alameda County will then appear as “01”, rather than “1”, and will
contain two digits like the other 2-digit county codes (Fresno through Yuba, 10 through 58, respectively).
Comma Delimited Data Format:
In the comma-delimited set, the length of each field and the length of each record will vary according
to the data reported. To assist you in using the comma delimited patient discharge data sets, a
header row identifying each data element is provided in the position of the first record.
Each data element is separated by a comma and is defined and described in this documentation. In
Appendix H, there is a table listing the Field Label (used in the header row), Field Name, Field Type
(format), and Maximum Number of Characters.
Fields with no data will have consecutive delimiters (commas). Most PC software will have no difficulty
with consecutive delimiters. However, some software packages may handle consecutive delimiters as a
single delimiter and adjustments will need to be made.
Note: It is possible for some invalid values to remain in the database “as reported” by the hospital, due to
a lack of database enforced integrity. This means that for some observations, you may find blank values,
invalid alpha characters in numeric fields, out-of-range numeric values, etc.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 4 2004 Public Patient Discharge Data

FACILITY EXCEPTIONS
State Hospitals:
Through the first half of 1989, the database included twelve state hospitals. As of July 1989, the eleven
operated by the Department of Mental Health or the Department of Developmental Services, serving
mentally disordered and developmentally disabled patients, no longer report discharge data. The twelfth,
the Veterans Home of California, Nelson M. Holderman Memorial Hospital, in Yountville has continued to
report discharge data. Records from this hospital can be located using the Hospital Identification
Number “281297.”
Psychiatric Health Facilities:
Psychiatric Health Facilities, which provide care in licensed Acute Psychiatric beds, are subject to the
same reporting requirements as other California hospitals. This type of hospital was first licensed in
California in 1988. Patient discharge data for 1989 and for January through June 1990 included data
from six Psychiatric Health Facilities; data for July through December 1990 include data from all but one
of the 16 licensed Psychiatric Health Facilities. All of these facilities started reporting their patient
discharge data beginning in 1991.
Modifications and Non-Compliant Facilities:
Some hospitals have applied for and been granted “modifications” to standard Patient Discharge Data
reporting requirements. Other hospitals were unable to complete specific fields as required and were
deemed “non-compliant” at the time of reporting. See Appendix D (Data Exceptions) for a listing of all
non-compliant hospitals and those with approved modifications and their affected variables.
Formerly Freestanding Facilities on Parent Facility Licenses (Consolidated Licensure):
Beginning in the mid-1980s, via the Consolidated Licensure Act, the Department of Health Services
began merging formerly separately licensed hospitals and nursing homes onto the licenses of
“parent” hospitals. To become “Consolidated,” certain conditions had to be met, including common
ownership and medical staff, and the locations had to be within 15 miles. Beginning in the 1990s,
formerly separately licensed locations (including some existing consolidated satellite locations) now
appear as “Distinct Part Facilities” on their parent facility’s license.
Appendix F, Hospital Listing, lists all patient discharge data “reporting entities.” For “Consolidated”
reporting entities, the “Facility Name” is plural (e.g., Medical Centers, Hospitals), and the numbers of
consolidated locations are displayed. (The ZIP codes and counties noted each belong to the Parent
location. Some “Consolidations” cross county boundaries.)
As each set of consolidated locations shares the same license, they also share the same license
number. To view specific licenses, on the Internet, go to the OSHPD ALIRTS page,
www.alirts.oshpd.ca.gov. At the first ALIRTS screen, enter the license number, facility name, or
OSHPD_ID number in the search window and click “Search.” At the next screen, click on “View
License.” (Also, at this screen you can click on “View Reports” to see their most recent Annual
Utilization data submitted.)
The discharges reported for each single, parent, and satellite facility is unique to that location. The
only merged sets of discharges are those noted as from “Consolidated Facilities.”
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 5 2004 Public Patient Discharge Data

VARIABLE CHANGES OVER TIME
Hospital Identification Number:
The first six characters of each record contain the “Hospital Identification Number”. Beginning with data
reported for 1995, this former nine-digit hospital identification number was shortened to six digits. The
former first digit, that indicated the type of care reported, has been made a separate data element (Type
of Care) and is described below. The former filler number “06” (2nd and 3rd digits) has been dropped.
Thus the hospital identification number now consists of six digits. The first two indicate the county
number and the last four are unique to a facility within each county.
Type of Care:
The second field on each record is a single digit field that describes the “Type of Care” (“Level of Care” in
1995 and 1996) from which the patient was discharged. See Type of Care codes and labels on page 7.
Beginning with 1997 data, hospitals were required to report one of five Types of Care for each discharge.
For the 1995 and 1996 data years, hospitals were required to assign, to each discharge, one of three
Levels of Care (“3” for Long Term Care, “6” for Rehabilitation Care and “1” for all other types of care).
Prior to 1995, discharges were optionally reported in sets, by one of the five Types of Care. Most
hospitals chose to include all discharges, regardless of the type of care, in one set (usually acute care).
Note: there has never been a Type of Care or Level of Care code “2”.
HISTORICAL SUMMARY OF FORMAT AND CONTENT CHANGES
PATIENT DISCHARGE DATA COLLECTION PROGRAM
DATA ITEM: ACTION / EFFECTIVE DATE:
E-Code Added – July 1990
Social Security Number Added – July 1990
Record Linkage Number (Encrypted SSN) Added – July 1990
Zip Code for Homeless (ZZZZZ) Added – November 1993
Hospital Identification Number (from 9 to 6 digits) Changed – January 1995
Level of Care (see Type of Care, below) Added – January 1995
Ethnicity/Race Changed – January 1995
Source of Admission Expanded – January 1995
Type of Admission Changed – January 1995
Procedure Dates (for all reported procedures) Added – January 1995
Patient Disposition Expanded – January 1995
Changed – January 1995 Expected Source of Payment:
Expanded – January 1999
Principal Diagnosis-Condition Present at Admission Added – January 1996
Other Diagnoses-Condition Present at Admission Added – January 1996
Type of Care (formerly Level of Care) Changed – January 1997
Pre-hospital Care & Resuscitation (Do Not Resuscitate Order) Added – January 1999
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 6 2004 Public Patient Discharge Data

MISSING/INVALID DATA VALUES
Invalid or missing values (submitted below the error tolerance level) are defaulted to “unknown.” The
table below displays default numbers and percentages.
Default
Status
Numbers of
Records
Percent of
Records
Not Defaulted 3,948,168 99.76%
One Variable Defaulted 9,195 .23%
Multiple Variables Defaulted 277 .01%
Other data exceptions are listed by hospital in Appendix D, Data Exceptions.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 7 2004 Public Patient Discharge Data

HOSPITAL IDENTIFICATION NUMBER
FIELD NAME : OSHPD_ID
DEFINITION : A unique six-digit identifier assigned to each facility by the Office of Statewide
Health Planning and Development. The first two digits indicate the county in
which the hospital is located. The last four digits are unique within each
county.
CODES, CATEGORIES AND COMMENTS:
A – 99 = 01-58 = County Codes (see Appendix A)
B – 9999 = 0001-9999 = Unique Hospital Identifier (within county)
OSHPD Facility ID Number will be the 9th variable masked if necessary to de-identify unique patient records
by replacing code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 8 2004 Public Patient Discharge Data

TYPE OF CARE
FIELD NAME : TYP_CARE
DEFINITION : Defined by the California Health and Safety Code, this refers to the licensure of the
bed occupied by an inpatient. The types of care are documented on the official
license issued by Licensing and Certification of the California State Department of
Health Services.
CODES, CATEGORIES AND COMMENTS:
Code Category Licensed Bed Classification/Designation
1 = Acute Care General Acute Care
3 = Skilled Nursing/Intermediate Care Skilled Nursing/Intermediate Care (a.k.a. Long Term
Care)
4 = Psychiatric Care Acute Psychiatric Care
5 = Chemical Dependency Recovery Care Chemical Dependency Recovery Hospital/Service
6 = Physical Rehabilitation Care Rehabilitation Center, a bed designation within the
General Acute Care classification.
All other values for Type of Care are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 9 2004 Public Patient Discharge Data

AGE IN YEARS (at Admission)
FIELD NAME : AGE_YRS
DEFINITION : Age of patient at time of admission.
CODES, CATEGORIES AND COMMENTS:
Age = Blank indicates age has been masked or is unknown (the year of birth is incomplete or unknown
and an age of 0 has been assigned).
Newborns are identified with a code 7 in Source of Admission or infants (less than 24 hours old) are
coded with a 3 in Type of Admission.
To reduce the need for masking to protect patient confidentiality; all patients older than 85 will be
coded as “85” years of age. This can be considered “85 and older.”
If necessary, Age in Years will be the first variable masked to de-identify unique patient records, by
blanking-out reported age. This is the only numeric data element that will be masked; all other variables
subject to masking are text variables and contain an asterisk when masked.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 10 2004 Public Patient Discharge Data

AGE 20 CATEGORY
FIELD NAME : AGECAT20
DEFINITION : Age range categories based on the patient’s age at the time of admission.
Twenty age categories; mostly 5-year increments.
CODES, CATEGORIES AND COMMENTS:
The following age breakdown was provided in public version B for 1999 and 2000.
CATEGORY AGE DEFINITION
01 under 1 year under 1 year
02 1-4 years 366 days through 4 years
03 5-9 years 5 years through 9 years
04 10-14 years 10 years through 14 years
05 15-19 years 15 years through 19 years
06 20-24 years 20 years through 24 years
07 25-29 years 25 years through 29 years
08 30-34 years 30 years through 34 years
09 35-39 years 35 years through 39 years
10 40-44 years 40 years through 44 years
11 45-49 years 45 years through 49 years
12 50-54 years 50 years through 54 years
13 55-59 years 55 years through 59 years
14 60-64 years 60 years through 64 years
15 65-69 years 65 years through 69 years
16 70-74 years 70 years through 74 years
17 75-79 years 75 years through 79 years
18 80-84 years 80 years through 84 years
19 85 years & over 85 years or greater
00 unknown (0) Year of birth incomplete or unknown
Age Category (20) will be the 5th variable masked if necessary to de-identify unique patient records by
replacing age category code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 11 2004 Public Patient Discharge Data

AGE 5 CATEGORY
FIELD NAME : AGECAT5

DEFINITION : Five age categories; Random year increments.
CODES, CATEGORIES AND COMMENTS:
CATEGORY AGE DEFINITION
01 Under 1 year Under 1 year
02 1-17 years 1 year through 17 years
03 18-34 years 18 years through 34 years
04 35-64 years 35years through 64 years
05 65years & over 65 years or greater
00 Unknown (0) Year of birth incomplete or unknown
Age Category (5) will be the 6th variable masked if necessary to de-identify unique patient records by
replacing age category code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 12 2004 Public Patient Discharge Data

SEX
FIELD NAME : SEX
DEFINITION : This is the gender of the patient.
CODES, CATEGORIES AND COMMENTS:
Code Category
1 Male
2 Female
3 Other
4 Unknown
All other values for Sex are not considered valid.
“Other” includes sex changes, undetermined sex, and live births with congenital abnormalities that
obscure sex identification. “Unknown” indicates that the patient’s sex was not available from the
medical record.
Sex (gender of the patient) will be the 4th variable masked if necessary to de-identify unique patient
records by replacing code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 13 2004 Public Patient Discharge Data

ETHNICITY
FIELD NAME : ETHNCTY
DEFINITION : This code indicates whether or not the patient’s ethnicity is Hispanic.
CODES, CATEGORIES AND COMMENTS:
The single code digit indicates ethnicity and includes:
Code Category
1 Hispanic
2 Non-Hispanic
3 Unknown
All other values for Ethnicity are not considered valid.
Both ethnicity and race are self-reported by the patient.
Ethnicity will be the 2nd variable masked if necessary to de-identify unique patient records by replacing
code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 14 2004 Public Patient Discharge Data

RACE
FIELD NAME : RACE
DEFINITION : This code indicates the patient’s racial background.
CODES, CATEGORIES AND COMMENTS:
Code Category
1 White – A person having origins in or who identifies with any of the original
Caucasian peoples of Europe, North Africa, or the Middle East.
2 Black – A person having origins in or who identifies with any of the black
racial groups of Africa.
3 Native American/Eskimo/Aleut – A person having origins in or who identifies
with any of the original peoples of North America, and who maintains cultural
identification through tribal affiliation or community recognition.
4 Asian/Pacific Islander – A person having origins in or who identifies with any
of the original oriental peoples of the Far East, Southeast Asia, the Indian
subcontinent, or the Pacific Islands. Includes Hawaii, Laos, Vietnam,
Cambodia, Hong Kong, Taiwan, China, India, Japan, Korea, the Philippine
Islands, and Samoa.
5 Other – Any possible options not covered in the above categories.
6 Unknown
All other values for Race are not considered valid.
Both ethnicity and race are self-reported by the patient.
Race will be the 3rd variable masked if necessary to de-identify unique patient records by replacing code
with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 15 2004 Public Patient Discharge Data

PATIENT ZIP CODE
FIVE DIGIT / THREE DIGIT
FIELD NAME : PATZIP
DEFINITION : The ZIP Code of the patient’s residence (all five digits). This is a unique code
assigned to a specific geographic area by the U.S. Postal Service for the
patient’s usual residence.
CODES, CATEGORIES AND COMMENTS:
The five digits of the ZIP Code of the patient’s residence.
If the field is coded with XXXXX, the ZIP Code is unknown.
If it is coded with YYYYY, the patient is from an area outside the United States.
If it is coded with ZZZZZ, the patient has no residence (homeless).
If the city of residence is known but not the street address, or if the first three digits are the only
digits reported, then it is a partial ZIP Code. It will be shown as a 5-digit ZIP code—the first three
digits plus ‘00’. Example: Sacramento, CA 95800. There are no partial ZIP codes in the 2001 or
2002 data.
The reported ZIP Code will be the 8th variable masked if necessary to de-identify unique patient records
to protect patient confidentiality. The Patient ZIP Code can be masked sequentially from 5-digits to 3-
digits, then from 3-digits to just an asterisk, if required to de-identify the record.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 16 2004 Public Patient Discharge Data

COUNTY OF PATIENT’S RESIDENCE
FIELD NAME : PATCNTY
DEFINITION : The county of residence code is assigned based on the reported patient’s
ZIP code.
CODES, CATEGORIES AND COMMENTS:
Codes: 00-58, CE, NE and NW
01-58 indicates a county in California (see list in Appendix A); 00 indicates that the patient’s zip
code was unknown, outside California, outside the U.S., homeless, or partial.
The data for 2001 is the only data in which some records have a blank patient county, which
indicates the patient’s ZIP Code was unreported or partial.
To protect patient confidentiality, those counties with populations less than 30,000 are assigned
to one of three groups of small counties to de-identify unique patient records. The groups and
counties included are:
GROUP COUNTIES
CE (Central) Alpine, Inyo, Mariposa and Mono
NE (Northeastern) Modoc, Plumas and Sierra
NW (Northwestern) Colusa, Glenn and Trinity
Note – Using the reported ZIP Code, OSHPD assigns the patient’s county of residence. ZIP Codes
are designed for mail delivery, not to identify political boundaries. Therefore, some ZIP Codes cross
county boundaries. For such ZIP Codes, OSHPD assigns the county with the greatest population in
the respective ZIP Code.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 17 2004 Public Patient Discharge Data

LENGTH OF STAY (Days)
FIELD NAME : LOS
DEFINITION : Total number of days from admission date to discharge date of each patient.
CODES, CATEGORIES AND COMMENTS:
The days are calculated by subtracting the Admission Date from the Discharge Date. The length of
stay for patients admitted on day one and discharged on day two is counted as one day.
Patients admitted and discharged on the same day yield a calculated length of stay of “0” days. This
requires changing those (same-day admits and discharges) zeros to “ones” before performing
average length of stay calculations to achieve more meaningful average length of stay calculations.
The number of days is right justified and zero filled (for fixed-length data format).
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 18 2004 Public Patient Discharge Data

ADMISSION: QUARTER
FIELD NAME : ADM_QTR
DEFINITION : Quarter the patient was admitted to the hospital.
CODES, CATEGORIES AND COMMENTS:
Code Quarter
One-digit quarter 1 January-March
2 April-June
3 July-September
4 October-December
Quarter admitted will be the 7th variable masked if necessary to de-identify unique patient records by
replacing code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 19 2004 Public Patient Discharge Data

ADMISSION: YEAR
FIELD NAMES : ADM_YR
DEFINITION : Year the patient was admitted to the hospital.
CODES, CATEGORIES AND COMMENTS:
Four-digit year – This is comprised of first two digits century and last two digits year.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 20 2004 Public Patient Discharge Data

SOURCE OF ADMISSION
FIELD NAME : ADM_SRC
DEFINITION : Effective with discharges on January 1, 1995, the source of admission
describes three aspects of the source:
The first digit describes the site from which the patient originated.
The second digit describes the license of site from which the patient
originated.
The third digit describes the route by which the patient was admitted.
CODES, CATEGORIES AND COMMENTS:
Site:
Code Category
1 Home
2 Residential Care Facility
3 Ambulatory Surgery
4 Skilled Nursing/Intermediate Care
5 Acute Inpatient Hospital Care
6 Other Inpatient Hospital Care
7 Newborn*
8 Prison/Jail
9 Other
All other values for “Site” are not considered valid.
*”Newborn” source of admission is defined as a “baby born alive in this hospital.”
Licensure of Site:
Code Category
1 This Hospital
2 Another Hospital
3 Not a Hospital
All other values for “Licensure of Site” are not considered valid.
Route:
Code Category
1 Your ER
2 Not Your ER (or no ER)
All other values for “Route” are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 21 2004 Public Patient Discharge Data

TYPE OF ADMISSION
FIELD NAME : ADM_TYPE
DEFINITION : Effective with discharges on January 1, 1995, the patient’s type of admission
was reported using one of the categories listed below. The critical distinction
is not how but when the admission was arranged.
CODES, CATEGORIES AND COMMENTS:
Code Category
1 Scheduled (Scheduled in advance, at least of 24 hours or more prior to admission)
2 Unscheduled (Not scheduled within 24 hours or more prior to admission)
3 Infant, less than 24 hrs old
4 Unknown (Does not include stillbirths)
All other values for Type of Admission are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 22 2004 Public Patient Discharge Data

DISPOSITION OF PATIENT
FIELD NAME : DISP
DEFINITION : The consequent arrangement or event ending a patient’s stay in the reporting
facility. Effective with discharges beginning January 1, 1995, the codes are as
follows:
CODES, CATEGORIES AND COMMENTS:
Disposition of Patient:
Code Category
01 Routine (Home)
Within this Hospital:
Code Category
02 Acute Care
03 Other Care
04 Skilled Nursing/Intermediate Care
To Another Hospital:
Code Category
05 Acute Care
06 Other Care (not Skilled Nursing/Intermediate Care)
07 Skilled Nursing/Intermediate Care
08 Residential Care Facility
09 Prison/Jail
10 Against Medical Advice
11 Died
12 Home Health Service
13 Other
All other values for Disposition are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 23 2004 Public Patient Discharge Data

PREHOSPITAL CARE AND RESUSCITATION
FIELD NAME : DNR
DEFINITION : This code indicates whether or not there was a “Do Not Resuscitate” order
upon admission or within 24 hours of admission from a physician.
CODES, CATEGORIES AND COMMENTS:
A “Do Not Resuscitate” (DNR) order is a directive from a physician in a patient’s current inpatient
medical record instructing that the patient is not to be resuscitated in the event of a cardiac or
pulmonary arrest. In the event of a cardiac or pulmonary arrest, resuscitative measures include, but
are not limited to, the following: cardiopulmonary resuscitation (CPR), intubation, defibrillation,
cardioactive drugs, or assisted ventilation.
Code Category
Y = Yes – a DNR order was written at the time of or within the first 24 hours of patient’s
admission to the hospital.
N = No – a DNR order was not written at the time of or within the first 24 hours of the patient’s
admission to the hospital.
All other values for Prehospital Care and Resuscitation are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 24 2004 Public Patient Discharge Data

EXPECTED SOURCE OF PAYMENT
PAYER CATEGORY
FIELD NAME : PAY_CAT
DEFINITION : This code indicates the category of payer (type of entity or organization) who
is expected to pay or did pay the greatest share of the patient’s bill.
CODES, CATEGORIES AND COMMENTS:
Expected Payer Categories
Code Category Code Category
01 Medicare 06 Other Government
02 Medi-Cal 07 Other Indigent
03 Private Coverage 08 Self Pay
04 Workers’ Compensation 09 Other Payer
05 County Indigent Programs 00 Not reported or reported in error
All other values for Payer Category are not considered valid.
• Medicare – A federally administered third party reimbursement program authorized by Title XVIII of the Social
Security Act. Includes crossovers to secondary payers.
• Medi-Cal – A state administered third party reimbursement program authorized by Title XIX of the Social
Security Act.
• Private Coverage – Payment covered by private, non-profit, or commercial health plans, whether insurance
or other coverage, or organizations. Included are payments by local or organized charities, such as the
Cerebral Palsy Foundation, Easter Seals, March of Dimes, or Shriners.
• Workers’ Compensation – Payment from workers’ compensation insurance, government or privately
sponsored.
• County Indigent Programs – Patients covered under Welfare and Institutions Code Section 17000. includes
programs funded in whole or in part by County Medical Services Program (CMSP), California Healthcare for
Indigents Program (CHIP), and/or other Realignment Funds whether or not a bill is rendered.
• Other Government – Any form of payment from government agencies, whether local, state, federal or foreign,
except those listed above. Includes funds received through California Children Services (CCS), the Civilian
Health and Medical Program of the Uniformed Services (TRICARE), and the Veterans Administration.
• Other Indigent – Patients receiving care pursuant to Hill-Burton obligations or who meet the standards for
charity care pursuant to the hospital’s established charity care policy.
• Self Pay – Payment directly by the patient, personal guarantor, relatives, or friends. The greatest share of
patient’s bill is not expected to be paid by any form of insurance or other health plan.
• Other Payer – Any third party payment not included above. Included are cases where no payment will be
required by the facility, such as special research or courtesy patients.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 25 2004 Public Patient Discharge Data

EXPECTED SOURCE OF PAYMENT
PAYER TYPE OF COVERAGE
FIELD NAME: : PAY_TYPE
DEFINITION : This code indicates the type of coverage for the following: Medicare, MediCal, Private Coverage, Workers’ Compensation, County Indigent Programs,
and Other Government.
CODES, CATEGORIES AND COMMENTS:
Codes Category
1 = Managed Care – Knox-Keene/MCOHS
2 = Managed Care – Other
3 = Traditional Coverage
0 = Payer Type field is not considered applicable for payer categories other than:
Medicare, Medi-Cal, Private Coverage, Worker’s Compensation, County
Indigent or Other Government.
All other values of Payer Type are not considered valid.
Managed Care – Knox/Keene-Medi-Cal County Organized Health System. Healthcare service plans,
including Health Maintenance Organizations (HMO), licensed by the Department of Corporations under the
Knox-Keene Healthcare Service Plan Act of 1975. Includes Medi-Cal County Organized Health Systems
(MCOHS).
Managed Care-Other. – Healthcare plans, except those above, which provide managed care to enrollees
through a panel of providers on a pre-negotiated or per diem basis, usually involving utilization review.
Includes Preferred Provider Organization (PPO), Exclusive Provider Organization (EPO), Exclusive Provider
Organization with Point-of-Service option (POS).
Traditional Coverage. – All other forms of healthcare coverage, including the Medicare prospective payment
system, indemnity or fee-for-service plans, or other fee-for-service payers.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 26 2004 Public Patient Discharge Data

EXPECTED SOURCE OF PAYMENT
PAYER PLAN CODE
FIELD NAME: : PAY_PLAN
DEFINITION : This four-digit code number refers to the name of those plans which are
licensed under the Knox-Keene Healthcare Service Plan Act of 1975 or
designated as a Medi-Cal County Organized Health System (MCOHS).
CODES, CATEGORIES AND COMMENTS:
The Plan code number represents the name of the Knox-Knee licensed plan or the Medi-Cal County
Organized Health System. See Appendix E for the plan code names and numbers.
If the Payer Plan Code field is not applicable, determined by Type of Coverage, the Plan Code is zero
filled (i.e. assigned a value of “0000”).
Only values for Payer Plan, listed in Appendix E, are considered valid.
If the plan code numbers are the same and the plan names are different, it means they belong to
the same “parent” plan.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 27 2004 Public Patient Discharge Data

TOTAL CHARGES
FIELD NAME : CHARGE
DEFINITION : Total Charges include all charges for services rendered during the length of
stay for patient care at the facility, based on the hospital’s full established
rates.
CODES, CATEGORIES AND COMMENTS:
Charges include, but are not limited to, daily hospital services, ancillary services and any patient care
services. Hospital-based physician fees are excluded. Prepayment (e.g. deposits and prepaid
admissions) are not deducted from Total Charges.
If a patient’s length of stay is more than 1 year (365 days), Total Charges are reported for the
last year (365 days) of stay only. To calculate Adjusted Total Charges for stays over one year use
the following formula:
(Total Charges / 365 days) x Length of Stay = Adjusted Total Charges
Total Charges are expressed in whole dollars. However, there is a specific meaning attached to the
three values of “total charges,” below:
Where total charges equal 1 – the “1” is a code meaning that there were no ($0) charges generated
for the hospital stay (and was verified by the hospital). (Prior to 2004, all discharges from
Shriners Hospital – Los Angeles were coded as “1” because they did not charge their patients.
Programming note – the “1” allows the aggregation of all discharges with “valid total charges” by
selecting those with total charges greater than zero.
Where total charges equal 0 – the “0” is a code meaning that there was a charge, but that the
amount of the charge could not be reported by the hospital. This frequently means the reported
values were blank or otherwise invalid. This includes all Kaiser Foundation Hospitals which
report a “0” for Total Charges as they are exempted from reporting total charges because they do
not charge specifically for an inpatient stay. Rather, they receive a constant monthly (capitated)
payment from each member, whether or not that member is hospitalized, or received outpatient
care or no care at all.
Where total Charges equal 9999999 -The total charge of “9999999” indicates the actual charges
exceed the seven digit field size utilized by the hospital or designated agent.
Note – Beginning in 2002, Shriners Hospital – Northern California began coding all Total Charges
as $0, to note that they do not charge their patients. Beginning in 2004, Shriners Hospital – Los
Angeles did the same. Unfortunately, this is inconsistent with the coding scheme. Their Total
Charges now appear as invalid or missing data.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 28 2004 Public Patient Discharge Data

EXTERNAL CAUSE OF INJURY — PRINCIPAL E-CODE
FIELD NAME : ECODE_P
DEFINITION : The external cause of injury consists of the ICD-9-CM codes E800-E999 (ECodes), that are used to describe the external cause of injuries, poisonings,
and adverse effects. If the information is available in the medical record, ECodes sufficient to describe the external cause are reported for discharges
with a principal and/or other diagnoses classified as injuries or poisonings in
Chapter 17 of the ICD-9-CM (800-999), or where a code from Chapters 1-16
of the ICD-9-CM (001-799) indicates that an additional E-code is applicable.
The reporting of E-Codes in the range E870-E879 (misadventures and
abnormal reactions) is not required. The principal E-Code is reported only for
the inpatient hospitalization during which the injury, poisoning, and/or adverse
effect was first diagnosed and/or treated.
To assure uniform reporting of E-Codes, when multiple codes are required to
completely classify the cause, the first (principal) E-code will describe the
mechanism that resulted in the most severe injury, poisoning, or adverse
effect.
CODES, CATEGORIES AND COMMENTS:
The valid E-Codes are specified in Chapter 17 of the ICD-9-CM codebook. External cause of injury
was not required for discharges before July 1, 1990.
CODE STRUCTURE (examples):
Content of Field: E9068 Would be read as: E906.8
Content of Field: E899 Would be read as: E899.
(Implied decimal is read after the first four positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 29 2004 Public Patient Discharge Data

EXTERNAL CAUSE OF INJURY – OTHER E-CODES
FIELD NAME : ECODE1, ECODE2, ECODE3, and ECODE4
DEFINITION : The external cause of injury consists of the ICD-9-CM codes E800-E999 (ECodes), that are used to describe the external cause of injuries, poisonings,
and adverse effects. If the information is available in the medical record, Ecodes sufficient to describe the external cause are reported for discharges
with a principal and/or other diagnoses classified as injuries or poisonings in
Chapter 17 of the ICD-9-CM (800-999), or where a code from Chapters 1-16
of the ICD-9-CM (001-799) indicates that an additional E-code is applicable.
The reporting of E-Codes in the range E870-E879 (misadventures and
abnormal reactions) is not required. An E-Code is reported only for the
inpatient hospitalization during which the injury, poisoning, and/or adverse
effect was first diagnosed and/or treated.
If the principal E-Code does not include a description of the place of
occurrence of the most severe injury, or poisoning, an additional E-Code is
reported to designate the place of occurrence, if available in the medical
record. Place of occurrence is coded as E849.0 – E849.9. Up to three
additional E-codes will be reported, if necessary to completely describe the
mechanism(s) that contributed to, or the causal events surrounding, any injury
or poisoning, or adverse effect first diagnosed and/or treated during the
current inpatient hospitalization.
CODES, CATEGORIES AND COMMENTS:
The valid E-Codes specified in Chapter 17 of the ICD-9-CM codebook. External cause of injury was
not required for discharges before July 1, 1990.
CODE STRUCTURE (examples):
Content of Field: E9068 Would be read as: E906.8
Content of Field: E899 Would be read as: E899.
(Implied decimal is read after the first four positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 30 2004 Public Patient Discharge Data

MAJOR DIAGNOSTIC CATEGORY
(MDC)
FIELD NAME : MDC
DEFINITION : MDCs are mutually exclusive categories containing all possible principal
diagnosis areas. The diagnoses in each MDC correspond to a single major
organ system or etiology, and in general are associated with a particular
medical specialty. Some MDCs are residual categories containing diseases
or disorders that could not be assigned to an organ system-based MDC.
OSHPD purchases the DRG Grouper software from Centers for Medicare and
Medicaid Services (CMS) contractor, 3M® Health Information Systems. CMS
implements revisions to the DRG Grouper software effective October 1, the
start of the Federal fiscal year for the Medicare Prospective Payment System.
The Office implements the same software effective with discharges from the
beginning of the following calendar year. DRG Grouper Version 18.0, which
was implemented by CMS on October 1, 2000, is the DRG Grouper applied to
the Office’s calendar year 2001 patient discharge data.
The MDC is based on the principal diagnosis. The MDC is given “00” for
records where the principal diagnosis is not an existing ICD-9-CM code.
Beginning with 1993 data, new codes after October 1, are “mapped” by
OSHPD’s own mapping logic system to the closest equivalent code
recognized by the DRG Grouper Version for that calendar year and assigned
to an MDC based on that DRG Grouper Version’s logic.
CODES, CATEGORIES AND COMMENTS:
Codes: 00-25
MDC 00 is the label for records that could not be assigned to MDCs 1-25 by the DRG grouper
(e.g. some records from DRG 470 (ungroupable).
Appendix B displays the MDC descriptions.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 31 2004 Public Patient Discharge Data

DIAGNOSIS RELATED GROUP
(DRG)
FIELD NAME : DRG
DEFINITION : DRGs are case-mix assignments grouping hospital patients to categories
based on diagnostic, therapeutic and demographic characteristics for the
purpose of reimbursement. OSHPD purchases the DRG Grouper software
from Centers for Medicare and Medicaid Services (CMS) contractor, 3M®
Health Information Systems. CMS implements revisions to the DRG Grouper
software every October 1, the start of Federal fiscal year for the Medicare
Prospective Payment System. The Office implements the same software
effective with discharges from the beginning of the following calendar year.
Special note – New codes after October 1, are “mapped” by OSHPD’s own
mapping logic system to the closest equivalent code recognized by the DRG
Grouper Version for that calendar year and assigned to a DRG based on that
DRG Grouper Version’s logic.
CODES,CATEGORIES AND COMMENTS:
Codes: 001-511
Appendix C displays the DRG descriptions.
The following indicates the DRG Grouper Version used during recent years:
Calendar Year 1995 = Version 12.0 HCFA DRG Grouper
Calendar Year 1996 = Version 13.0 HCFA DRG Grouper
Calendar Year 1997 = Version 14.0 HCFA DRG Grouper
Calendar Year 1998 = Version 15.0 HCFA DRG Grouper
Calendar Year 1999 = Version 16.0 HCFA DRG Grouper
Calendar Year 2000 = Version 17.0 HCFA DRG Grouper
Calendar Year 2001 = Version 18.0 HCFA DRG Grouper
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 32 2004 Public Patient Discharge Data

PRINCIPAL DIAGNOSIS
FIELD NAME : DIAG_P
DEFINITION : The condition established, after study, to be the chief cause of the admission
of the patient to the facility for care.
CODES, CATEGORIES AND COMMENTS:
The appropriate codes to be entered for this data element are specified in the International
Classification of Diseases, 9th Revision, Clinical Modification, U.S. Department of Health and Human
Services, Washington D.C. (ICD-9-CM).
Beginning with 1999, the psychiatric codes from the Diagnostic and Statistical Manual of Mental
Disorders (DSM), by American Psychiatric Association, Washington, D.C. are not accepted by
OSHPD.
Note: Morphology codes are not accepted by OSHPD. SNODO codes are not accepted by OSHPD.
Codes from the Supplementary Classification of External causes (E-Code) of Injury and Poisoning
are not accepted in the Principal Diagnosis field. Italicized ICD-9-CM codes are not accepted in the
Principal Diagnosis field.
CODE STRUCTURE (examples):
Content of Field: V5781 Would be read as: V57.81
Content of Field: 3441 Would be read as: 344.1
(Implied decimal is read after the first three character positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 33 2004 Public Patient Discharge Data

CONDITION PRESENT AT ADMISSION
(for the Principal Diagnosis)
FIELD NAME : CPOA_P
DEFINITION : The indicator for whether or not the condition was present at admission by
reporting Yes, No, or Uncertain for the Principal Diagnosis.
CODES, CATEGORIES AND COMMENTS:
The indicator for the principal diagnosis is defaulted to Yes (present at admission), unless reported
otherwise.
Code Category
Y = Yes
N = No
U = Uncertain
All other values of Condition Present At Admission are not considered valid.
Detailed parameters for reporting Condition Present At Admission are available in the California
Patient Discharge Data Reporting Manual, Third Edition.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 34 2004 Public Patient Discharge Data

PRINCIPAL PROCEDURE
FIELD NAME : PROC_P
DEFINITION : The principal procedure is one which was performed for definitive treatment
rather than one performed for diagnostic or exploratory purposes, or which
was necessary to take care of a complication.
The principal procedure is the procedure most related to the principal
diagnosis.
If only non-therapeutic procedures were performed, then a significant nontherapeutic procedure should be reported. A significant procedure is one that
is surgical in nature, or carries a procedural risk, or carries an anesthetic risk,
or affects DRG assignment.
CODES, CATEGORIES AND COMMENTS:
The appropriate codes to be entered are specified in the International Classification of Diseases, 9th
Revision, Clinical Modification (ICD-9-CM), U.S. Department of Health and Human Services,
Washington, D.C.
Note: HCPCS and CPT codes are not accepted by OSHPD.
CODE STRUCTURE (examples):
Content of Field: 022 Would be read as: 02.2
Content of Field: 0293 Would be read as: 02.93
(Implied decimal is read after the first two positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 35 2004 Public Patient Discharge Data

DAYS FROM ADMISSION TO PRINCIPAL PROCEDURE
FIELD NAME : PROC_PDY
DEFINITION : The number of days between the patient’s admission date and the date of the
Principal Procedure.
CODES, CATEGORIES AND COMMENTS:
If the Principal Procedure was performed prior to admission, this numeric value will be prefixed with
a minus (-) sign. The days are calculated by subtracting the date of admission from the date of the
Principal Procedure. If the Principal Procedure was performed on the day of admission, the number
of days will be zero. If no Principal Procedure or date is reported, the days are shown as zero. The
maximum value is 9999, which means that the procedure was performed more than 9998 days after
admission.
Through 2000, if no procedure was performed, the days to procedure were shown as -999. For
procedures performed on the same day as admission, the days were displayed as zero.
Some hospitals report procedures performed on their inpatients, on an outpatient basis by another
facility, during the patient’s stay at the reporting hospital. Therefore, not all procedures reported by a
hospital were necessarily performed by and at that hospital.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 36 2004 Public Patient Discharge Data

OTHER DIAGNOSES (24 Other Diagnoses)
FIELD NAME : ODIAG1 to ODIAG24
DEFINITION : Conditions that coexist at the time of admission, develop subsequently during
the hospital stay, affect the treatment received, or affect the length of stay.
CODES, CATEGORIES AND COMMENTS:
Beginning with 1999, the psychiatric codes from Diagnostic and Statistical Manual of Mental Disorders
(DSM), by American Psychiatric Association, Washington D.C., are not accepted by OSHPD.
The appropriate codes to be entered are specified in the International Classification of Diseases 9th
Revision, Clinical Modification, U.S. Department of Health and Human Services, Washington, D.C.
(ICD-9-CM).
Other Diagnoses do not include E-Codes. E-Codes are located in special E-Code fields.
Note: Morphology or SNODO codes are not accepted by OSHPD.
CODE STRUCTURE (examples):
Content of Field: V5781 Would be read as: V57.81
Content of Field: 3441 Would be read as: 344.1
(Implied decimal is read after the first three positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 37 2004 Public Patient Discharge Data

CONDITION PRESENT AT ADMISSION
(for the Other Diagnoses)
FIELD NAME : CPOA1 to CPOA24
DEFINITION : The indicator for whether or not the condition was present at admission by
reporting Yes, No, or Uncertain for all Other Diagnoses.
CODES, CATEGORIES AND COMMENTS:
Code Category
Y = Yes
N = No
U = Uncertain
All other values of Condition Present At Admission are not considered valid.
Detailed parameters for reporting Condition Present At Admission are available in the California
Patient Discharge Data Reporting Manual, Third Edition.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 38 2004 Public Patient Discharge Data

OTHER PROCEDURES
(Maximum 20)
FIELD NAME : OPROC1 to OPROC20
DEFINITION : The procedure code is reported according to the ICD-9-CM. A procedure
is considered significant when it is a surgical risk, procedural risk,
anesthetic risk or is needed for DRG assignment.
CODES, CATEGORIES AND COMMENTS:
The appropriate codes to be entered are specified in the International Classification of Diseases 9th
Revision, Clinical Modification (ICD-9-CM), U.S. Department of Health and Human Services,
Washington, D.C. All significant procedures that are surgical in nature or carry procedural risk, or
carry an anesthetic risk, or affect DRG assignment, are reported.
Note: HCPCS and CPT codes are not accepted by OSHPD.
CODE STRUCTURE (examples):
Content of Field: 022 Would be read as: 02.2
Content of Field: 0293 Would be read as: 02.93
(Implied decimal is read after the first two positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 39 2004 Public Patient Discharge Data

DAYS FROM ADMISSION TO OTHER PROCEDURES
FIELD NAME : PROCDY1 to PROCDY20
DEFINITION : The number of days between the patient’s admission date and the date of the
Other Procedure.
CODES, CATEGORIES AND COMMENTS:
If Other Procedures were performed prior to admission, the numeric value will be prefixed with a
minus (-) sign. The days are calculated by subtracting the date of admission from the date of the
Other Procedure. If the Other Procedures were performed on the day of admission, the number of
days will be zero. If no Other Procedures or dates are reported, the days are shown as zero. The
maximum value is 9999, which means that the procedure was performed more than 9998 days after
admission.
Through 2000, if no procedure was performed, the days to procedure were shown as -999. For
procedures performed on the same day as admission, the days were displayed as zero.
Some hospitals report procedures performed on their inpatients, on an outpatient basis by another
facility, during the patient’s stay at the reporting hospital. Therefore, not all procedures reported by a
hospital were necessarily performed by and at that hospital.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 40 2004 Public Patient Discharge Data

APPENDICES
A full set of appendix files in a portable document format (.pdf) is included for easy viewing and
printing. In addition, a subset of five appendices is duplicated in an Excel file with each appendix in an
individual worksheet. These Excel worksheets can be used with relational database software to link
code numbers from the data to their respective labels (e.g., the Hospital ID Number, (OSHPD_ID),
from the data set can be matched with the hospital name in Appendix F). See the tables below for
appendix descriptions.
APPENDICES
PDF Files
The complete set of Appendices (PDF format) is located in the “Appendices_04” folder.
Appendices File Name PDF files must be viewed/read with Adobe Acrobat Reader
A App_A_counties.pdf Listing of California counties (names and codes).
B App_B_mdc.pdf Listing of Major Diagnostic Categories (names and
codes)
C App_C_drg.pdf Listing of Diagnosis Related Groups (names and
codes)
D App_D_exceptions.pdf Data Exceptions (Approved Requests for
Modifications and Non-Compliances)
E App_E_plan_codes.pdf Plan Codes for Expected Source of Payment
F App_F_hospital_list.pdf Listing of all hospitals in data set (Hospital ID#,
Name, ZIP, Facility Level, and Total Discharges)
G App_G_report_form.pdf Manual Abstract Reporting Form (OSHPD-1370)
H App_H_data_fields.pdf Data Fields, comma delimited format, public set
I App_I_masked_field_freqs.pdf Frequencies, by Value, of Fields Subject to
Masking
APPENDICES SUBSET
Excel File
A duplicate, sub-set of Appendices (in MS-Excel format) is also located in the “Appendices_04” folder. The
worksheets in this file can be used as relational database tables to link codes with labels
Appendices Worksheet Name Description
A App_A_counties Listing of California counties (names and codes)
B App_B_mdc Listing of Major Diagnostic Categories (names and
codes)
C App_C_drg Listing of Diagnosis Related Groups (names and
codes)
E App_E_plan_codes Plan Codes for Expected Source of Payment
F App_F_hospital_list
Listing of all hospitals in data set (Hospital ID#,
Name, ZIP, facility level of data aggregation and
total discharges)


Get Professional Assignment Help Cheaply

Buy Custom Essay

Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?

Whichever your reason is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.

Why Choose Our Academic Writing Service?

  • Plagiarism free papers
  • Timely delivery
  • Any deadline
  • Skilled, Experienced Native English Writers
  • Subject-relevant academic writer
  • Adherence to paper instructions
  • Ability to tackle bulk assignments
  • Reasonable prices
  • 24/7 Customer Support
  • Get superb grades consistently

Online Academic Help With Different Subjects

Literature

Students barely have time to read. We got you! Have your literature essay or book review written without having the hassle of reading the book. You can get your literature paper custom-written for you by our literature specialists.

Finance

Do you struggle with finance? No need to torture yourself if finance is not your cup of tea. You can order your finance paper from our academic writing service and get 100% original work from competent finance experts.

Computer science

Computer science is a tough subject. Fortunately, our computer science experts are up to the match. No need to stress and have sleepless nights. Our academic writers will tackle all your computer science assignments and deliver them on time. Let us handle all your python, java, ruby, JavaScript, php , C+ assignments!

Psychology

While psychology may be an interesting subject, you may lack sufficient time to handle your assignments. Don’t despair; by using our academic writing service, you can be assured of perfect grades. Moreover, your grades will be consistent.

Engineering

Engineering is quite a demanding subject. Students face a lot of pressure and barely have enough time to do what they love to do. Our academic writing service got you covered! Our engineering specialists follow the paper instructions and ensure timely delivery of the paper.

Nursing

In the nursing course, you may have difficulties with literature reviews, annotated bibliographies, critical essays, and other assignments. Our nursing assignment writers will offer you professional nursing paper help at low prices.

Sociology

Truth be told, sociology papers can be quite exhausting. Our academic writing service relieves you of fatigue, pressure, and stress. You can relax and have peace of mind as our academic writers handle your sociology assignment.

Business

We take pride in having some of the best business writers in the industry. Our business writers have a lot of experience in the field. They are reliable, and you can be assured of a high-grade paper. They are able to handle business papers of any subject, length, deadline, and difficulty!

Statistics

We boast of having some of the most experienced statistics experts in the industry. Our statistics experts have diverse skills, expertise, and knowledge to handle any kind of assignment. They have access to all kinds of software to get your assignment done.

Law

Writing a law essay may prove to be an insurmountable obstacle, especially when you need to know the peculiarities of the legislative framework. Take advantage of our top-notch law specialists and get superb grades and 100% satisfaction.

What discipline/subjects do you deal in?

We have highlighted some of the most popular subjects we handle above. Those are just a tip of the iceberg. We deal in all academic disciplines since our writers are as diverse. They have been drawn from across all disciplines, and orders are assigned to those writers believed to be the best in the field. In a nutshell, there is no task we cannot handle; all you need to do is place your order with us. As long as your instructions are clear, just trust we shall deliver irrespective of the discipline.

Are your writers competent enough to handle my paper?

Our essay writers are graduates with bachelor's, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college degree. All our academic writers have a minimum of two years of academic writing. We have a stringent recruitment process to ensure that we get only the most competent essay writers in the industry. We also ensure that the writers are handsomely compensated for their value. The majority of our writers are native English speakers. As such, the fluency of language and grammar is impeccable.

What if I don’t like the paper?

There is a very low likelihood that you won’t like the paper.

Reasons being:

  • When assigning your order, we match the paper’s discipline with the writer’s field/specialization. Since all our writers are graduates, we match the paper’s subject with the field the writer studied. For instance, if it’s a nursing paper, only a nursing graduate and writer will handle it. Furthermore, all our writers have academic writing experience and top-notch research skills.
  • We have a quality assurance that reviews the paper before it gets to you. As such, we ensure that you get a paper that meets the required standard and will most definitely make the grade.

In the event that you don’t like your paper:

  • The writer will revise the paper up to your pleasing. You have unlimited revisions. You simply need to highlight what specifically you don’t like about the paper, and the writer will make the amendments. The paper will be revised until you are satisfied. Revisions are free of charge
  • We will have a different writer write the paper from scratch.
  • Last resort, if the above does not work, we will refund your money.

Will the professor find out I didn’t write the paper myself?

Not at all. All papers are written from scratch. There is no way your tutor or instructor will realize that you did not write the paper yourself. In fact, we recommend using our assignment help services for consistent results.

What if the paper is plagiarized?

We check all papers for plagiarism before we submit them. We use powerful plagiarism checking software such as SafeAssign, LopesWrite, and Turnitin. We also upload the plagiarism report so that you can review it. We understand that plagiarism is academic suicide. We would not take the risk of submitting plagiarized work and jeopardize your academic journey. Furthermore, we do not sell or use prewritten papers, and each paper is written from scratch.

When will I get my paper?

You determine when you get the paper by setting the deadline when placing the order. All papers are delivered within the deadline. We are well aware that we operate in a time-sensitive industry. As such, we have laid out strategies to ensure that the client receives the paper on time and they never miss the deadline. We understand that papers that are submitted late have some points deducted. We do not want you to miss any points due to late submission. We work on beating deadlines by huge margins in order to ensure that you have ample time to review the paper before you submit it.

Will anyone find out that I used your services?

We have a privacy and confidentiality policy that guides our work. We NEVER share any customer information with third parties. Noone will ever know that you used our assignment help services. It’s only between you and us. We are bound by our policies to protect the customer’s identity and information. All your information, such as your names, phone number, email, order information, and so on, are protected. We have robust security systems that ensure that your data is protected. Hacking our systems is close to impossible, and it has never happened.

How our Assignment Help Service Works

1. Place an order

You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.

2. Pay for the order

Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.

3. Track the progress

You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.

4. Download the paper

The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.

smile and order essay GET A PERFECT SCORE!!! smile and order essay Buy Custom Essay


Place your order
(550 words)

Approximate price: $22

Patient Discharge Data File Documentation

STATE OF CALIFORNIA
OFFICE OF STATEWIDE HEALTH PLANNING AND DEVELOPMENT
Patient Discharge Data
File Documentation
January-December 2004
PUBLIC VERSION
COMMA-DELIMITED TEXT FORMAT
CD-ROM
July 2005
i
CONTENTS
Introduction
Masked Variables ………………………………………………………………………………………………………….1
Importing Notes……………………………………………………………………………………………………………..3
Facility Exceptions …………………………………………………………………………………………………………4
Variable Changes Over Time…………………………………………………………………………………………..5
Missing/Invalid Data Values…………………………………………………………………………………………….6
Data Element Field Descriptions
Hospital Identification Number…………………………………………………………………………………………7
Type of Care …………………………………………………………………………………………………………………8
Age in Years …………………………………………………………………………………………………………………9
Age (20 Age Categories) ……………………………………………………………………………………………..10
Age (5 Age Categories) ………………………………………………………………………………………………..11
Sex…………………………………………………………………………………………………………………………….12
Ethnicity ……………………………………………………………………………………………………………………..13
Race…………………………………………………………………………………………………………………………..14
Patient Zip Code ………………………………………………………………………………………………………….15
County of Patient’s Residence……………………………………………………………………………………….16
Length of Stay……………………………………………………………………………………………………………..17
Admission – Quarter ……………………………………………………………………………………………………..18
Admission – Year………………………………………………………………………………………………………….19
Source of Admission…………………………………………………………………………………………………….20
Type of Admission ……………………………………………………………………………………………………….21
Disposition of Patient ……………………………………………………………………………………………………22
Pre-hospital Care and Resuscitation (Do Not Resuscitate) ………………………………………………..23
Expected Source of Payment – Payer Category ……………………………………………………………….24
Expected Source of Payment – Payer Type of Coverage …………………………………………………..25
Expected Source of Payment – Payer Plan Code Number …………………………………………………26
Total Charges ……………………………………………………………………………………………………………..27
External Cause of Injury – Principal E-Code …………………………………………………………………….28
External Cause of Injury -Other E-Codes ……………………………………………………………………….29
Major Diagnostic Category (MDC) ………………………………………………………………………………….30
Diagnosis Related Group (DRG) ……………………………………………………………………………………31
Principal Diagnosis ………………………………………………………………………………………………………32
Condition Present at Admission (Principal Diagnosis)……………………………………………………….33
Principal Procedure………………………………………………………………………………………………………34
Days from Admission to Principal Procedure……………………………………………………………………35
Other Diagnoses………………………………………………………………………………………………………….36
Condition Present at Admission (Other Diagnoses) ………………………………………………………….37
Other Procedures…………………………………………………………………………………………………………38
Days from Admission to Other Procedures………………………………………………………………………39
Appendices
Appendix A County Names and Codes………………………………………………………………….. A – 1
Appendix B Major Diagnostic Categories (MDCs) ………………………………………………….. B – 1
Appendix C Diagnosis Related Groups (DRGs)……………………………………………………….C – 1
Appendix D Data Exceptions (as reported) ……………………………………………………………..D – 1
Appendix E Plan Codes, Expected Source of Payment……………………………………………. E – 1
Appendix F Hospital Listing………………………………………………………………………………….. F – 1
Appendix G Manual Abstract Reporting Form ………………………………………………………….G – 1
Appendix H Comma-Delimited Field List…………………………………………………………………H – 1
Appendix I Masked Variable Frequencies ……………………………………………………………… I – 1
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 1 2004 Public Patient Discharge Data

INTRODUCTION
Patient Discharge Data:
The California Office of Statewide Health Planning and Development (OSHPD) provide a public dataset
of the Patient Discharge Database available for purchase on compact disc (CD). The data is made
available by OSHPD once it has been screened by the automated reporting software and corrected by
the individual hospitals. The public patient-level dataset includes patient zip code, demographic
variables and clinical information.
The public dataset is comprised of a record for each inpatient discharged from a licensed acute care
hospital. This includes: General Acute Care Hospitals, Acute Psychiatric Hospitals, Chemical
Dependency Recovery Hospitals, and Psychiatric Health Facilities. (Note: the only exceptions are
records not reported by some California State Hospitals; see the State Hospitals discussion on page
four.)
The patient discharge dataset is available for discharges in each calendar year. The data on CD-ROM are
stored on one CD containing three zipped data files and a full set of documentation files. The discharge
records are divided into three sets by the geography of the reporting hospitals. One file contains discharge
records from hospitals in Los Angeles County, another file contains discharges from the seven other counties
in Southern California and the third file contains discharges from hospitals in the remaining 50 Northern
California Counties.
MASKED VARIABLES
To protect patient confidentiality, those records with unique combinations of a select set of demographic
variables will have one or more of those variables masked to make sure the files are de-identified. Each
unique record will have the minimum number of fields masked to ensure it is no longer unique. The
variable masking will occur in the following order:
ORDER OF
MASKING DATA FIELDS SUBJECT TO MASKING
1st
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
Age in years (at admission)
Ethnicity
Race
Sex
Age Category 20 (20 Age Categories)
Age Category 5 (5 Age Categories)
Small County Groups*
Admit Quarter
Patient Zip Code **
OSHPD ID
*Small counties with total populations of 30,000 or less are grouped into 3
categories: Central (CE), Northeastern (NE), and Northwestern (NW). Ten
counties were grouped in 2003: Central: Alpine, Inyo, Mariposa, Mono;
Northeastern: Modoc, Plumas, Sierra; Northwestern: Colusa, Glenn, and Trinity.
**Five-digit zip will be masked to three-digits; if record is still unique, zip will be
totally masked with an asterisk.
General assistance is available by calling OSHPDs Healthcare Information Resource Center at
(916) 322-2814.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 2 2004 Public Patient Discharge Data

Don't use plagiarized sources. Get Your Custom Essay on
Patient Discharge Data File Documentation
Just from $9/Page
Order Essay

Public Discharge Dataset
Data Fields in 2004 Public Discharge Dataset
Percent Remaining
Unmasked
For Variables
Subject to Masking
Hospital Identification Number 100.0%
Type (level) of Care
Age in Years 53.7%
Age (20 Categories) 86.6%
Age (5 Categories) 93.2%
Sex 81.7%
Ethnicity 69.9%
Race 73.8%
Zip Code (5 digits masked to 3 digits) 98.3%
Zip Code (3 digits masked to 0 digits) 99.6%
County of Patient’s Residence (or Small County Groups) 100.0%
Length of Stay
Quarter Admitted 96.6%
Year Admitted
Source of Admission
Type of Admission
Disposition of Patient
Pre-hospital Care and Resuscitation (Do Not Resuscitate Order)
Expected Principal Source of Payment – Payer Category
Expected Principal Source of Payment – Type of Coverage
Expected Principal Source of Payment – Plan Code Number
Total Charges
Principal External Cause of Injury (E-Code)
Other External Cause of Injuries (up to 4 Other E-Codes)
Major Diagnostic Category
Diagnosis Related Group
Principal Diagnosis
Condition Present at Admission (for Principal Diagnosis)
Principal Procedure
Days from Admission to Principal Procedure
Other Diagnoses (24 Other Diagnoses)
Condition Present at Admission (for Other Diagnoses)
Other Procedures (20 Other Procedures)
Days From Admission to Other Procedures
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 3 2004 Public Patient Discharge Data

IMPORTING NOTES
The fields listed below contain numeric codes, which are not numeric values; most PC software will treat
these fields as numeric values unless formatted otherwise. Thus, when importing the data into your software,
these fields should be formatted as text or alphanumeric to retain the leading and trailing zeros. Also, when
a text variable is masked, the field value is an asterisk, which may cause errors if imported as numeric.
OSHPD-Hospital Identification Number
5 Age Category and 20 Age Category Fields
Sex
Ethnicity
Race
Patient Zip Code
County of Patients Residence
Admission Quarter
Expected Principal Source of Payment Plan Code Number
MDC
DRG
All diagnosis code fields (principal and other)
All procedure code fields (principal and other)
It is especially important that all Diagnosis and Procedure code fields be formatted as text. These fields are
comprised of ICD-9-CM codes, some of which begin with alpha characters that cannot be read if not
formatted as text. Also, many ICD-9-CM codes have leading and/or trailing zeros. For example, the ICD-9-
CM code for Salmonella Gastroenteritis is 003.0. If it is not formatted as text, it will appear as 3, which is
the numeric value, but is not the valid diagnostic code for Salmonella Gastroenteritis.
It is not absolutely essential but is recommended, to maintain leading zeros in the other codes that contain
leading zeros (Hospital Identification Number, Patients County of Residence, MDC, DRG, and Payer Plan
Code Number). When these fields are formatted as text, the number of digits in each respective field will
then remain constant. For example, Alameda County will then appear as 01, rather than 1, and will
contain two digits like the other 2-digit county codes (Fresno through Yuba, 10 through 58, respectively).
Comma Delimited Data Format:
In the comma-delimited set, the length of each field and the length of each record will vary according
to the data reported. To assist you in using the comma delimited patient discharge data sets, a
header row identifying each data element is provided in the position of the first record.
Each data element is separated by a comma and is defined and described in this documentation. In
Appendix H, there is a table listing the Field Label (used in the header row), Field Name, Field Type
(format), and Maximum Number of Characters.
Fields with no data will have consecutive delimiters (commas). Most PC software will have no difficulty
with consecutive delimiters. However, some software packages may handle consecutive delimiters as a
single delimiter and adjustments will need to be made.
Note: It is possible for some invalid values to remain in the database as reported by the hospital, due to
a lack of database enforced integrity. This means that for some observations, you may find blank values,
invalid alpha characters in numeric fields, out-of-range numeric values, etc.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 4 2004 Public Patient Discharge Data

FACILITY EXCEPTIONS
State Hospitals:
Through the first half of 1989, the database included twelve state hospitals. As of July 1989, the eleven
operated by the Department of Mental Health or the Department of Developmental Services, serving
mentally disordered and developmentally disabled patients, no longer report discharge data. The twelfth,
the Veterans Home of California, Nelson M. Holderman Memorial Hospital, in Yountville has continued to
report discharge data. Records from this hospital can be located using the Hospital Identification
Number 281297.”
Psychiatric Health Facilities:
Psychiatric Health Facilities, which provide care in licensed Acute Psychiatric beds, are subject to the
same reporting requirements as other California hospitals. This type of hospital was first licensed in
California in 1988. Patient discharge data for 1989 and for January through June 1990 included data
from six Psychiatric Health Facilities; data for July through December 1990 include data from all but one
of the 16 licensed Psychiatric Health Facilities. All of these facilities started reporting their patient
discharge data beginning in 1991.
Modifications and Non-Compliant Facilities:
Some hospitals have applied for and been granted “modifications” to standard Patient Discharge Data
reporting requirements. Other hospitals were unable to complete specific fields as required and were
deemed “non-compliant” at the time of reporting. See Appendix D (Data Exceptions) for a listing of all
non-compliant hospitals and those with approved modifications and their affected variables.
Formerly Freestanding Facilities on Parent Facility Licenses (Consolidated Licensure):
Beginning in the mid-1980s, via the Consolidated Licensure Act, the Department of Health Services
began merging formerly separately licensed hospitals and nursing homes onto the licenses of
parent hospitals. To become Consolidated, certain conditions had to be met, including common
ownership and medical staff, and the locations had to be within 15 miles. Beginning in the 1990s,
formerly separately licensed locations (including some existing consolidated satellite locations) now
appear as Distinct Part Facilities on their parent facilitys license.
Appendix F, Hospital Listing, lists all patient discharge data reporting entities. For Consolidated
reporting entities, the Facility Name is plural (e.g., Medical Centers, Hospitals), and the numbers of
consolidated locations are displayed. (The ZIP codes and counties noted each belong to the Parent
location. Some Consolidations cross county boundaries.)
As each set of consolidated locations shares the same license, they also share the same license
number. To view specific licenses, on the Internet, go to the OSHPD ALIRTS page,
www.alirts.oshpd.ca.gov. At the first ALIRTS screen, enter the license number, facility name, or
OSHPD_ID number in the search window and click Search. At the next screen, click on View
License. (Also, at this screen you can click on View Reports to see their most recent Annual
Utilization data submitted.)
The discharges reported for each single, parent, and satellite facility is unique to that location. The
only merged sets of discharges are those noted as from Consolidated Facilities.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 5 2004 Public Patient Discharge Data

VARIABLE CHANGES OVER TIME
Hospital Identification Number:
The first six characters of each record contain the Hospital Identification Number. Beginning with data
reported for 1995, this former nine-digit hospital identification number was shortened to six digits. The
former first digit, that indicated the type of care reported, has been made a separate data element (Type
of Care) and is described below. The former filler number “06” (2nd and 3rd digits) has been dropped.
Thus the hospital identification number now consists of six digits. The first two indicate the county
number and the last four are unique to a facility within each county.
Type of Care:
The second field on each record is a single digit field that describes the “Type of Care” (Level of Care in
1995 and 1996) from which the patient was discharged. See Type of Care codes and labels on page 7.
Beginning with 1997 data, hospitals were required to report one of five Types of Care for each discharge.
For the 1995 and 1996 data years, hospitals were required to assign, to each discharge, one of three
Levels of Care (3 for Long Term Care, 6 for and 1 for all other types of care).
Prior to 1995, discharges were optionally reported in sets, by one of the five Types of Care. Most
hospitals chose to include all discharges, regardless of the type of care, in one set (usually acute care).
Note: there has never been a Type of Care or Level of Care code “2”.
HISTORICAL SUMMARY OF FORMAT AND CONTENT CHANGES
PATIENT DISCHARGE DATA COLLECTION PROGRAM
DATA ITEM: ACTION / EFFECTIVE DATE:
E-Code Added – July 1990
Social Security Number Added – July 1990
Record Linkage Number (Encrypted SSN) Added – July 1990
Zip Code for Homeless (ZZZZZ) Added – November 1993
Hospital Identification Number (from 9 to 6 digits) Changed – January 1995
Level of Care (see Type of Care, below) Added – January 1995
Ethnicity/Race Changed – January 1995
Source of Admission Expanded – January 1995
Type of Admission Changed – January 1995
Procedure Dates (for all reported procedures) Added – January 1995
Patient Disposition Expanded – January 1995
Changed – January 1995 Expected Source of Payment:
Expanded – January 1999
Principal Diagnosis-Condition Present at Admission Added – January 1996
Other Diagnoses-Condition Present at Admission Added – January 1996
Type of Care (formerly Level of Care) Changed – January 1997
Pre-hospital Care & Resuscitation (Do Not Resuscitate Order) Added – January 1999
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 6 2004 Public Patient Discharge Data

MISSING/INVALID DATA VALUES
Invalid or missing values (submitted below the error tolerance level) are defaulted to unknown. The
table below displays default numbers and percentages.
Default
Status
Numbers of
Records
Percent of
Records
Not Defaulted 3,948,168 99.76%
One Variable Defaulted 9,195 .23%
Multiple Variables Defaulted 277 .01%
Other data exceptions are listed by hospital in Appendix D, Data Exceptions.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 7 2004 Public Patient Discharge Data

HOSPITAL IDENTIFICATION NUMBER
FIELD NAME : OSHPD_ID
DEFINITION : A unique six-digit identifier assigned to each facility by the Office of Statewide
Health Planning and Development. The first two digits indicate the county in
which the hospital is located. The last four digits are unique within each
county.
CODES, CATEGORIES AND COMMENTS:
A – 99 = 01-58 = County Codes (see Appendix A)
B – 9999 = 0001-9999 = Unique Hospital Identifier (within county)
OSHPD Facility ID Number will be the 9th variable masked if necessary to de-identify unique patient records
by replacing code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 8 2004 Public Patient Discharge Data

TYPE OF CARE
FIELD NAME : TYP_CARE
DEFINITION : Defined by the California Health and Safety Code, this refers to the licensure of the
bed occupied by an inpatient. The types of care are documented on the official
license issued by Licensing and Certification of the California State Department of
Health Services.
CODES, CATEGORIES AND COMMENTS:
Code Category Licensed Bed Classification/Designation
1 = Acute Care General Acute Care
3 = Skilled Nursing/Intermediate Care Skilled Nursing/Intermediate Care (a.k.a. Long Term
Care)
4 = Psychiatric Care Acute Psychiatric Care
5 = Chemical Dependency Recovery Care Chemical Dependency Recovery Hospital/Service
6 = Physical Rehabilitation Care Rehabilitation Center, a bed designation within the
General Acute Care classification.
All other values for Type of Care are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 9 2004 Public Patient Discharge Data

AGE IN YEARS (at Admission)
FIELD NAME : AGE_YRS
DEFINITION : Age of patient at time of admission.
CODES, CATEGORIES AND COMMENTS:
Age = Blank indicates age has been masked or is unknown (the year of birth is incomplete or unknown
and an age of 0 has been assigned).
Newborns are identified with a code 7 in Source of Admission or infants (less than 24 hours old) are
coded with a 3 in Type of Admission.
To reduce the need for masking to protect patient confidentiality; all patients older than 85 will be
coded as 85 years of age. This can be considered 85 and older.
If necessary, Age in Years will be the first variable masked to de-identify unique patient records, by
blanking-out reported age. This is the only numeric data element that will be masked; all other variables
subject to masking are text variables and contain an asterisk when masked.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 10 2004 Public Patient Discharge Data

AGE 20 CATEGORY
FIELD NAME : AGECAT20
DEFINITION : Age range categories based on the patients age at the time of admission.
Twenty age categories; mostly 5-year increments.
CODES, CATEGORIES AND COMMENTS:
The following age breakdown was provided in public version B for 1999 and 2000.
CATEGORY AGE DEFINITION
01 under 1 year under 1 year
02 1-4 years 366 days through 4 years
03 5-9 years 5 years through 9 years
04 10-14 years 10 years through 14 years
05 15-19 years 15 years through 19 years
06 20-24 years 20 years through 24 years
07 25-29 years 25 years through 29 years
08 30-34 years 30 years through 34 years
09 35-39 years 35 years through 39 years
10 40-44 years 40 years through 44 years
11 45-49 years 45 years through 49 years
12 50-54 years 50 years through 54 years
13 55-59 years 55 years through 59 years
14 60-64 years 60 years through 64 years
15 65-69 years 65 years through 69 years
16 70-74 years 70 years through 74 years
17 75-79 years 75 years through 79 years
18 80-84 years 80 years through 84 years
19 85 years & over 85 years or greater
00 unknown (0) Year of birth incomplete or unknown
Age Category (20) will be the 5th variable masked if necessary to de-identify unique patient records by
replacing age category code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 11 2004 Public Patient Discharge Data

AGE 5 CATEGORY
FIELD NAME : AGECAT5

DEFINITION : Five age categories; Random year increments.
CODES, CATEGORIES AND COMMENTS:
CATEGORY AGE DEFINITION
01 Under 1 year Under 1 year
02 1-17 years 1 year through 17 years
03 18-34 years 18 years through 34 years
04 35-64 years 35years through 64 years
05 65years & over 65 years or greater
00 Unknown (0) Year of birth incomplete or unknown
Age Category (5) will be the 6th variable masked if necessary to de-identify unique patient records by
replacing age category code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 12 2004 Public Patient Discharge Data

SEX
FIELD NAME : SEX
DEFINITION : This is the gender of the patient.
CODES, CATEGORIES AND COMMENTS:
Code Category
1 Male
2 Female
3 Other
4 Unknown
All other values for Sex are not considered valid.
“Other” includes sex changes, undetermined sex, and live births with congenital abnormalities that
obscure sex identification. “Unknown” indicates that the patient’s sex was not available from the
medical record.
Sex (gender of the patient) will be the 4th variable masked if necessary to de-identify unique patient
records by replacing code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 13 2004 Public Patient Discharge Data

ETHNICITY
FIELD NAME : ETHNCTY
DEFINITION : This code indicates whether or not the patient’s ethnicity is Hispanic.
CODES, CATEGORIES AND COMMENTS:
The single code digit indicates ethnicity and includes:
Code Category
1 Hispanic
2 Non-Hispanic
3 Unknown
All other values for Ethnicity are not considered valid.
Both ethnicity and race are self-reported by the patient.
Ethnicity will be the 2nd variable masked if necessary to de-identify unique patient records by replacing
code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 14 2004 Public Patient Discharge Data

RACE
FIELD NAME : RACE
DEFINITION : This code indicates the patient’s racial background.
CODES, CATEGORIES AND COMMENTS:
Code Category
1 White A person having origins in or who identifies with any of the original
Caucasian peoples of Europe, North Africa, or the Middle East.
2 Black A person having origins in or who identifies with any of the black
racial groups of Africa.
3 Native American/Eskimo/Aleut A person having origins in or who identifies
with any of the original peoples of North America, and who maintains cultural
identification through tribal affiliation or community recognition.
4 Asian/Pacific Islander A person having origins in or who identifies with any
of the original oriental peoples of the Far East, Southeast Asia, the Indian
subcontinent, or the Pacific Islands. Includes Hawaii, Laos, Vietnam,
Cambodia, Hong Kong, Taiwan, China, India, Japan, Korea, the Philippine
Islands, and Samoa.
5 Other Any possible options not covered in the above categories.
6 Unknown
All other values for Race are not considered valid.
Both ethnicity and race are self-reported by the patient.
Race will be the 3rd variable masked if necessary to de-identify unique patient records by replacing code
with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 15 2004 Public Patient Discharge Data

PATIENT ZIP CODE
FIVE DIGIT / THREE DIGIT
FIELD NAME : PATZIP
DEFINITION : The ZIP Code of the patients residence (all five digits). This is a unique code
assigned to a specific geographic area by the U.S. Postal Service for the
patient’s usual residence.
CODES, CATEGORIES AND COMMENTS:
The five digits of the ZIP Code of the patient’s residence.
If the field is coded with XXXXX, the ZIP Code is unknown.
If it is coded with YYYYY, the patient is from an area outside the United States.
If it is coded with ZZZZZ, the patient has no residence (homeless).
If the city of residence is known but not the street address, or if the first three digits are the only
digits reported, then it is a partial ZIP Code. It will be shown as a 5-digit ZIP codethe first three
digits plus 00. Example: Sacramento, CA 95800. There are no partial ZIP codes in the 2001 or
2002 data.
The reported ZIP Code will be the 8th variable masked if necessary to de-identify unique patient records
to protect patient confidentiality. The Patient ZIP Code can be masked sequentially from 5-digits to 3-
digits, then from 3-digits to just an asterisk, if required to de-identify the record.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 16 2004 Public Patient Discharge Data

COUNTY OF PATIENTS RESIDENCE
FIELD NAME : PATCNTY
DEFINITION : The county of residence code is assigned based on the reported patient’s
ZIP code.
CODES, CATEGORIES AND COMMENTS:
Codes: 00-58, CE, NE and NW
01-58 indicates a county in California (see list in Appendix A); 00 indicates that the patient’s zip
code was unknown, outside California, outside the U.S., homeless, or partial.
The data for 2001 is the only data in which some records have a blank patient county, which
indicates the patients ZIP Code was unreported or partial.
To protect patient confidentiality, those counties with populations less than 30,000 are assigned
to one of three groups of small counties to de-identify unique patient records. The groups and
counties included are:
GROUP COUNTIES
CE (Central) Alpine, Inyo, Mariposa and Mono
NE (Northeastern) Modoc, Plumas and Sierra
NW (Northwestern) Colusa, Glenn and Trinity
Note Using the reported ZIP Code, OSHPD assigns the patients county of residence. ZIP Codes
are designed for mail delivery, not to identify political boundaries. Therefore, some ZIP Codes cross
county boundaries. For such ZIP Codes, OSHPD assigns the county with the greatest population in
the respective ZIP Code.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 17 2004 Public Patient Discharge Data

LENGTH OF STAY (Days)
FIELD NAME : LOS
DEFINITION : Total number of days from admission date to discharge date of each patient.
CODES, CATEGORIES AND COMMENTS:
The days are calculated by subtracting the Admission Date from the Discharge Date. The length of
stay for patients admitted on day one and discharged on day two is counted as one day.
Patients admitted and discharged on the same day yield a calculated length of stay of 0 days. This
requires changing those (same-day admits and discharges) zeros to ones before performing
average length of stay calculations to achieve more meaningful average length of stay calculations.
The number of days is right justified and zero filled (for fixed-length data format).
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 18 2004 Public Patient Discharge Data

ADMISSION: QUARTER
FIELD NAME : ADM_QTR
DEFINITION : Quarter the patient was admitted to the hospital.
CODES, CATEGORIES AND COMMENTS:
Code Quarter
One-digit quarter 1 January-March
2 April-June
3 July-September
4 October-December
Quarter admitted will be the 7th variable masked if necessary to de-identify unique patient records by
replacing code with an asterisk.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 19 2004 Public Patient Discharge Data

ADMISSION: YEAR
FIELD NAMES : ADM_YR
DEFINITION : Year the patient was admitted to the hospital.
CODES, CATEGORIES AND COMMENTS:
Four-digit year – This is comprised of first two digits century and last two digits year.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 20 2004 Public Patient Discharge Data

SOURCE OF ADMISSION
FIELD NAME : ADM_SRC
DEFINITION : Effective with discharges on January 1, 1995, the source of admission
describes three aspects of the source:
The first digit describes the site from which the patient originated.
The second digit describes the license of site from which the patient
originated.
The third digit describes the route by which the patient was admitted.
CODES, CATEGORIES AND COMMENTS:
Site:
Code Category
1 Home
2 Residential Care Facility
3 Ambulatory Surgery
4 Skilled Nursing/Intermediate Care
5 Acute Inpatient Hospital Care
6 Other Inpatient Hospital Care
7 Newborn*
8 Prison/Jail
9 Other
All other values for Site are not considered valid.
*Newborn” source of admission is defined as a baby born alive in this hospital.
Licensure of Site:
Code Category
1 This Hospital
2 Another Hospital
3 Not a Hospital
All other values for Licensure of Site are not considered valid.
Route:
Code Category
1 Your ER
2 Not Your ER (or no ER)
All other values for Route are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 21 2004 Public Patient Discharge Data

TYPE OF ADMISSION
FIELD NAME : ADM_TYPE
DEFINITION : Effective with discharges on January 1, 1995, the patient’s type of admission
was reported using one of the categories listed below. The critical distinction
is not how but when the admission was arranged.
CODES, CATEGORIES AND COMMENTS:
Code Category
1 Scheduled (Scheduled in advance, at least of 24 hours or more prior to admission)
2 Unscheduled (Not scheduled within 24 hours or more prior to admission)
3 Infant, less than 24 hrs old
4 Unknown (Does not include stillbirths)
All other values for Type of Admission are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 22 2004 Public Patient Discharge Data

DISPOSITION OF PATIENT
FIELD NAME : DISP
DEFINITION : The consequent arrangement or event ending a patient’s stay in the reporting
facility. Effective with discharges beginning January 1, 1995, the codes are as
follows:
CODES, CATEGORIES AND COMMENTS:
Disposition of Patient:
Code Category
01 Routine (Home)
Within this Hospital:
Code Category
02 Acute Care
03 Other Care
04 Skilled Nursing/Intermediate Care
To Another Hospital:
Code Category
05 Acute Care
06 Other Care (not Skilled Nursing/Intermediate Care)
07 Skilled Nursing/Intermediate Care
08 Residential Care Facility
09 Prison/Jail
10 Against Medical Advice
11 Died
12 Home Health Service
13 Other
All other values for Disposition are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 23 2004 Public Patient Discharge Data

PREHOSPITAL CARE AND RESUSCITATION
FIELD NAME : DNR
DEFINITION : This code indicates whether or not there was a Do Not Resuscitate order
upon admission or within 24 hours of admission from a physician.
CODES, CATEGORIES AND COMMENTS:
A Do Not Resuscitate (DNR) order is a directive from a physician in a patient’s current inpatient
medical record instructing that the patient is not to be resuscitated in the event of a cardiac or
pulmonary arrest. In the event of a cardiac or pulmonary arrest, resuscitative measures include, but
are not limited to, the following: cardiopulmonary resuscitation (CPR), intubation, defibrillation,
cardioactive drugs, or assisted ventilation.
Code Category
Y = Yes – a DNR order was written at the time of or within the first 24 hours of patient’s
admission to the hospital.
N = No – a DNR order was not written at the time of or within the first 24 hours of the patient’s
admission to the hospital.
All other values for Prehospital Care and Resuscitation are not considered valid.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 24 2004 Public Patient Discharge Data

EXPECTED SOURCE OF PAYMENT
PAYER CATEGORY
FIELD NAME : PAY_CAT
DEFINITION : This code indicates the category of payer (type of entity or organization) who
is expected to pay or did pay the greatest share of the patient’s bill.
CODES, CATEGORIES AND COMMENTS:
Expected Payer Categories
Code Category Code Category
01 Medicare 06 Other Government
02 Medi-Cal 07 Other Indigent
03 Private Coverage 08 Self Pay
04 Workers Compensation 09 Other Payer
05 County Indigent Programs 00 Not reported or reported in error
All other values for Payer Category are not considered valid.
Medicare A federally administered third party reimbursement program authorized by Title XVIII of the Social
Security Act. Includes crossovers to secondary payers.
Medi-Cal A state administered third party reimbursement program authorized by Title XIX of the Social
Security Act.
Private Coverage Payment covered by private, non-profit, or commercial health plans, whether insurance
or other coverage, or organizations. Included are payments by local or organized charities, such as the
Cerebral Palsy Foundation, Easter Seals, March of Dimes, or Shriners.
Workers Compensation Payment from workers compensation insurance, government or privately
sponsored.
County Indigent Programs – Patients covered under Welfare and Institutions Code Section 17000. includes
programs funded in whole or in part by County Medical Services Program (CMSP), California Healthcare for
Indigents Program (CHIP), and/or other Realignment Funds whether or not a bill is rendered.
Other Government – Any form of payment from government agencies, whether local, state, federal or foreign,
except those listed above. Includes funds received through California Children Services (CCS), the Civilian
Health and Medical Program of the Uniformed Services (TRICARE), and the Veterans Administration.
Other Indigent Patients receiving care pursuant to Hill-Burton obligations or who meet the standards for
charity care pursuant to the hospitals established charity care policy.
Self Pay Payment directly by the patient, personal guarantor, relatives, or friends. The greatest share of
patient’s bill is not expected to be paid by any form of insurance or other health plan.
Other Payer Any third party payment not included above. Included are cases where no payment will be
required by the facility, such as special research or courtesy patients.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 25 2004 Public Patient Discharge Data

EXPECTED SOURCE OF PAYMENT
PAYER TYPE OF COVERAGE
FIELD NAME: : PAY_TYPE
DEFINITION : This code indicates the type of coverage for the following: Medicare, MediCal, Private Coverage, Workers’ Compensation, County Indigent Programs,
and Other Government.
CODES, CATEGORIES AND COMMENTS:
Codes Category
1 = Managed Care – Knox-Keene/MCOHS
2 = Managed Care Other
3 = Traditional Coverage
0 = Payer Type field is not considered applicable for payer categories other than:
Medicare, Medi-Cal, Private Coverage, Workers Compensation, County
Indigent or Other Government.
All other values of Payer Type are not considered valid.
Managed Care – Knox/Keene-Medi-Cal County Organized Health System. Healthcare service plans,
including Health Maintenance Organizations (HMO), licensed by the Department of Corporations under the
Knox-Keene Healthcare Service Plan Act of 1975. Includes Medi-Cal County Organized Health Systems
(MCOHS).
Managed Care-Other. – Healthcare plans, except those above, which provide managed care to enrollees
through a panel of providers on a pre-negotiated or per diem basis, usually involving utilization review.
Includes Preferred Provider Organization (PPO), Exclusive Provider Organization (EPO), Exclusive Provider
Organization with Point-of-Service option (POS).
Traditional Coverage. – All other forms of healthcare coverage, including the Medicare prospective payment
system, indemnity or fee-for-service plans, or other fee-for-service payers.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 26 2004 Public Patient Discharge Data

EXPECTED SOURCE OF PAYMENT
PAYER PLAN CODE
FIELD NAME: : PAY_PLAN
DEFINITION : This four-digit code number refers to the name of those plans which are
licensed under the Knox-Keene Healthcare Service Plan Act of 1975 or
designated as a Medi-Cal County Organized Health System (MCOHS).
CODES, CATEGORIES AND COMMENTS:
The Plan code number represents the name of the Knox-Knee licensed plan or the Medi-Cal County
Organized Health System. See Appendix E for the plan code names and numbers.
If the Payer Plan Code field is not applicable, determined by Type of Coverage, the Plan Code is zero
filled (i.e. assigned a value of “0000”).
Only values for Payer Plan, listed in Appendix E, are considered valid.
If the plan code numbers are the same and the plan names are different, it means they belong to
the same “parent” plan.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 27 2004 Public Patient Discharge Data

TOTAL CHARGES
FIELD NAME : CHARGE
DEFINITION : Total Charges include all charges for services rendered during the length of
stay for patient care at the facility, based on the hospital’s full established
rates.
CODES, CATEGORIES AND COMMENTS:
Charges include, but are not limited to, daily hospital services, ancillary services and any patient care
services. Hospital-based physician fees are excluded. Prepayment (e.g. deposits and prepaid
admissions) are not deducted from Total Charges.
If a patient’s length of stay is more than 1 year (365 days), Total Charges are reported for the
last year (365 days) of stay only. To calculate Adjusted Total Charges for stays over one year use
the following formula:
(Total Charges / 365 days) x Length of Stay = Adjusted Total Charges
Total Charges are expressed in whole dollars. However, there is a specific meaning attached to the
three values of “total charges, below:
Where total charges equal 1 – the 1 is a code meaning that there were no ($0) charges generated
for the hospital stay (and was verified by the hospital). (Prior to 2004, all discharges from
Shriners Hospital Los Angeles were coded as 1 because they did not charge their patients.
Programming note – the 1 allows the aggregation of all discharges with valid total charges by
selecting those with total charges greater than zero.
Where total charges equal 0 – the 0 is a code meaning that there was a charge, but that the
amount of the charge could not be reported by the hospital. This frequently means the reported
values were blank or otherwise invalid. This includes all Kaiser Foundation Hospitals which
report a 0 for Total Charges as they are exempted from reporting total charges because they do
not charge specifically for an inpatient stay. Rather, they receive a constant monthly (capitated)
payment from each member, whether or not that member is hospitalized, or received outpatient
care or no care at all.
Where total Charges equal 9999999 -The total charge of 9999999 indicates the actual charges
exceed the seven digit field size utilized by the hospital or designated agent.
Note Beginning in 2002, Shriners Hospital – Northern California began coding all Total Charges
as $0, to note that they do not charge their patients. Beginning in 2004, Shriners Hospital Los
Angeles did the same. Unfortunately, this is inconsistent with the coding scheme. Their Total
Charges now appear as invalid or missing data.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 28 2004 Public Patient Discharge Data

EXTERNAL CAUSE OF INJURY — PRINCIPAL E-CODE
FIELD NAME : ECODE_P
DEFINITION : The external cause of injury consists of the ICD-9-CM codes E800-E999 (ECodes), that are used to describe the external cause of injuries, poisonings,
and adverse effects. If the information is available in the medical record, ECodes sufficient to describe the external cause are reported for discharges
with a principal and/or other diagnoses classified as injuries or poisonings in
Chapter 17 of the ICD-9-CM (800-999), or where a code from Chapters 1-16
of the ICD-9-CM (001-799) indicates that an additional E-code is applicable.
The reporting of E-Codes in the range E870-E879 (misadventures and
abnormal reactions) is not required. The principal E-Code is reported only for
the inpatient hospitalization during which the injury, poisoning, and/or adverse
effect was first diagnosed and/or treated.
To assure uniform reporting of E-Codes, when multiple codes are required to
completely classify the cause, the first (principal) E-code will describe the
mechanism that resulted in the most severe injury, poisoning, or adverse
effect.
CODES, CATEGORIES AND COMMENTS:
The valid E-Codes are specified in Chapter 17 of the ICD-9-CM codebook. External cause of injury
was not required for discharges before July 1, 1990.
CODE STRUCTURE (examples):
Content of Field: E9068 Would be read as: E906.8
Content of Field: E899 Would be read as: E899.
(Implied decimal is read after the first four positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 29 2004 Public Patient Discharge Data

EXTERNAL CAUSE OF INJURY – OTHER E-CODES
FIELD NAME : ECODE1, ECODE2, ECODE3, and ECODE4
DEFINITION : The external cause of injury consists of the ICD-9-CM codes E800-E999 (ECodes), that are used to describe the external cause of injuries, poisonings,
and adverse effects. If the information is available in the medical record, Ecodes sufficient to describe the external cause are reported for discharges
with a principal and/or other diagnoses classified as injuries or poisonings in
Chapter 17 of the ICD-9-CM (800-999), or where a code from Chapters 1-16
of the ICD-9-CM (001-799) indicates that an additional E-code is applicable.
The reporting of E-Codes in the range E870-E879 (misadventures and
abnormal reactions) is not required. An E-Code is reported only for the
inpatient hospitalization during which the injury, poisoning, and/or adverse
effect was first diagnosed and/or treated.
If the principal E-Code does not include a description of the place of
occurrence of the most severe injury, or poisoning, an additional E-Code is
reported to designate the place of occurrence, if available in the medical
record. Place of occurrence is coded as E849.0 – E849.9. Up to three
additional E-codes will be reported, if necessary to completely describe the
mechanism(s) that contributed to, or the causal events surrounding, any injury
or poisoning, or adverse effect first diagnosed and/or treated during the
current inpatient hospitalization.
CODES, CATEGORIES AND COMMENTS:
The valid E-Codes specified in Chapter 17 of the ICD-9-CM codebook. External cause of injury was
not required for discharges before July 1, 1990.
CODE STRUCTURE (examples):
Content of Field: E9068 Would be read as: E906.8
Content of Field: E899 Would be read as: E899.
(Implied decimal is read after the first four positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 30 2004 Public Patient Discharge Data

MAJOR DIAGNOSTIC CATEGORY
(MDC)
FIELD NAME : MDC
DEFINITION : MDCs are mutually exclusive categories containing all possible principal
diagnosis areas. The diagnoses in each MDC correspond to a single major
organ system or etiology, and in general are associated with a particular
medical specialty. Some MDCs are residual categories containing diseases
or disorders that could not be assigned to an organ system-based MDC.
OSHPD purchases the DRG Grouper software from Centers for Medicare and
Medicaid Services (CMS) contractor, 3M Health Information Systems. CMS
implements revisions to the DRG Grouper software effective October 1, the
start of the Federal fiscal year for the Medicare Prospective Payment System.
The Office implements the same software effective with discharges from the
beginning of the following calendar year. DRG Grouper Version 18.0, which
was implemented by CMS on October 1, 2000, is the DRG Grouper applied to
the Office’s calendar year 2001 patient discharge data.
The MDC is based on the principal diagnosis. The MDC is given 00 for
records where the principal diagnosis is not an existing ICD-9-CM code.
Beginning with 1993 data, new codes after October 1, are “mapped” by
OSHPD’s own mapping logic system to the closest equivalent code
recognized by the DRG Grouper Version for that calendar year and assigned
to an MDC based on that DRG Grouper Versions logic.
CODES, CATEGORIES AND COMMENTS:
Codes: 00-25
MDC 00 is the label for records that could not be assigned to MDCs 1-25 by the DRG grouper
(e.g. some records from DRG 470 (ungroupable).
Appendix B displays the MDC descriptions.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 31 2004 Public Patient Discharge Data

DIAGNOSIS RELATED GROUP
(DRG)
FIELD NAME : DRG
DEFINITION : DRGs are case-mix assignments grouping hospital patients to categories
based on diagnostic, therapeutic and demographic characteristics for the
purpose of reimbursement. OSHPD purchases the DRG Grouper software
from Centers for Medicare and Medicaid Services (CMS) contractor, 3M
Health Information Systems. CMS implements revisions to the DRG Grouper
software every October 1, the start of Federal fiscal year for the Medicare
Prospective Payment System. The Office implements the same software
effective with discharges from the beginning of the following calendar year.
Special note – New codes after October 1, are “mapped” by OSHPD’s own
mapping logic system to the closest equivalent code recognized by the DRG
Grouper Version for that calendar year and assigned to a DRG based on that
DRG Grouper Versions logic.
CODES,CATEGORIES AND COMMENTS:
Codes: 001-511
Appendix C displays the DRG descriptions.
The following indicates the DRG Grouper Version used during recent years:
Calendar Year 1995 = Version 12.0 HCFA DRG Grouper
Calendar Year 1996 = Version 13.0 HCFA DRG Grouper
Calendar Year 1997 = Version 14.0 HCFA DRG Grouper
Calendar Year 1998 = Version 15.0 HCFA DRG Grouper
Calendar Year 1999 = Version 16.0 HCFA DRG Grouper
Calendar Year 2000 = Version 17.0 HCFA DRG Grouper
Calendar Year 2001 = Version 18.0 HCFA DRG Grouper
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 32 2004 Public Patient Discharge Data

PRINCIPAL DIAGNOSIS
FIELD NAME : DIAG_P
DEFINITION : The condition established, after study, to be the chief cause of the admission
of the patient to the facility for care.
CODES, CATEGORIES AND COMMENTS:
The appropriate codes to be entered for this data element are specified in the International
Classification of Diseases, 9th Revision, Clinical Modification, U.S. Department of Health and Human
Services, Washington D.C. (ICD-9-CM).
Beginning with 1999, the psychiatric codes from the Diagnostic and Statistical Manual of Mental
Disorders (DSM), by American Psychiatric Association, Washington, D.C. are not accepted by
OSHPD.
Note: Morphology codes are not accepted by OSHPD. SNODO codes are not accepted by OSHPD.
Codes from the Supplementary Classification of External causes (E-Code) of Injury and Poisoning
are not accepted in the Principal Diagnosis field. Italicized ICD-9-CM codes are not accepted in the
Principal Diagnosis field.
CODE STRUCTURE (examples):
Content of Field: V5781 Would be read as: V57.81
Content of Field: 3441 Would be read as: 344.1
(Implied decimal is read after the first three character positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 33 2004 Public Patient Discharge Data

CONDITION PRESENT AT ADMISSION
(for the Principal Diagnosis)
FIELD NAME : CPOA_P
DEFINITION : The indicator for whether or not the condition was present at admission by
reporting Yes, No, or Uncertain for the Principal Diagnosis.
CODES, CATEGORIES AND COMMENTS:
The indicator for the principal diagnosis is defaulted to Yes (present at admission), unless reported
otherwise.
Code Category
Y = Yes
N = No
U = Uncertain
All other values of Condition Present At Admission are not considered valid.
Detailed parameters for reporting Condition Present At Admission are available in the California
Patient Discharge Data Reporting Manual, Third Edition.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 34 2004 Public Patient Discharge Data

PRINCIPAL PROCEDURE
FIELD NAME : PROC_P
DEFINITION : The principal procedure is one which was performed for definitive treatment
rather than one performed for diagnostic or exploratory purposes, or which
was necessary to take care of a complication.
The principal procedure is the procedure most related to the principal
diagnosis.
If only non-therapeutic procedures were performed, then a significant nontherapeutic procedure should be reported. A significant procedure is one that
is surgical in nature, or carries a procedural risk, or carries an anesthetic risk,
or affects DRG assignment.
CODES, CATEGORIES AND COMMENTS:
The appropriate codes to be entered are specified in the International Classification of Diseases, 9th
Revision, Clinical Modification (ICD-9-CM), U.S. Department of Health and Human Services,
Washington, D.C.
Note: HCPCS and CPT codes are not accepted by OSHPD.
CODE STRUCTURE (examples):
Content of Field: 022 Would be read as: 02.2
Content of Field: 0293 Would be read as: 02.93
(Implied decimal is read after the first two positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 35 2004 Public Patient Discharge Data

DAYS FROM ADMISSION TO PRINCIPAL PROCEDURE
FIELD NAME : PROC_PDY
DEFINITION : The number of days between the patient’s admission date and the date of the
Principal Procedure.
CODES, CATEGORIES AND COMMENTS:
If the Principal Procedure was performed prior to admission, this numeric value will be prefixed with
a minus (-) sign. The days are calculated by subtracting the date of admission from the date of the
Principal Procedure. If the Principal Procedure was performed on the day of admission, the number
of days will be zero. If no Principal Procedure or date is reported, the days are shown as zero. The
maximum value is 9999, which means that the procedure was performed more than 9998 days after
admission.
Through 2000, if no procedure was performed, the days to procedure were shown as -999. For
procedures performed on the same day as admission, the days were displayed as zero.
Some hospitals report procedures performed on their inpatients, on an outpatient basis by another
facility, during the patient’s stay at the reporting hospital. Therefore, not all procedures reported by a
hospital were necessarily performed by and at that hospital.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 36 2004 Public Patient Discharge Data

OTHER DIAGNOSES (24 Other Diagnoses)
FIELD NAME : ODIAG1 to ODIAG24
DEFINITION : Conditions that coexist at the time of admission, develop subsequently during
the hospital stay, affect the treatment received, or affect the length of stay.
CODES, CATEGORIES AND COMMENTS:
Beginning with 1999, the psychiatric codes from Diagnostic and Statistical Manual of Mental Disorders
(DSM), by American Psychiatric Association, Washington D.C., are not accepted by OSHPD.
The appropriate codes to be entered are specified in the International Classification of Diseases 9th
Revision, Clinical Modification, U.S. Department of Health and Human Services, Washington, D.C.
(ICD-9-CM).
Other Diagnoses do not include E-Codes. E-Codes are located in special E-Code fields.
Note: Morphology or SNODO codes are not accepted by OSHPD.
CODE STRUCTURE (examples):
Content of Field: V5781 Would be read as: V57.81
Content of Field: 3441 Would be read as: 344.1
(Implied decimal is read after the first three positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 37 2004 Public Patient Discharge Data

CONDITION PRESENT AT ADMISSION
(for the Other Diagnoses)
FIELD NAME : CPOA1 to CPOA24
DEFINITION : The indicator for whether or not the condition was present at admission by
reporting Yes, No, or Uncertain for all Other Diagnoses.
CODES, CATEGORIES AND COMMENTS:
Code Category
Y = Yes
N = No
U = Uncertain
All other values of Condition Present At Admission are not considered valid.
Detailed parameters for reporting Condition Present At Admission are available in the California
Patient Discharge Data Reporting Manual, Third Edition.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 38 2004 Public Patient Discharge Data

OTHER PROCEDURES
(Maximum 20)
FIELD NAME : OPROC1 to OPROC20
DEFINITION : The procedure code is reported according to the ICD-9-CM. A procedure
is considered significant when it is a surgical risk, procedural risk,
anesthetic risk or is needed for DRG assignment.
CODES, CATEGORIES AND COMMENTS:
The appropriate codes to be entered are specified in the International Classification of Diseases 9th
Revision, Clinical Modification (ICD-9-CM), U.S. Department of Health and Human Services,
Washington, D.C. All significant procedures that are surgical in nature or carry procedural risk, or
carry an anesthetic risk, or affect DRG assignment, are reported.
Note: HCPCS and CPT codes are not accepted by OSHPD.
CODE STRUCTURE (examples):
Content of Field: 022 Would be read as: 02.2
Content of Field: 0293 Would be read as: 02.93
(Implied decimal is read after the first two positions.)
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 39 2004 Public Patient Discharge Data

DAYS FROM ADMISSION TO OTHER PROCEDURES
FIELD NAME : PROCDY1 to PROCDY20
DEFINITION : The number of days between the patient’s admission date and the date of the
Other Procedure.
CODES, CATEGORIES AND COMMENTS:
If Other Procedures were performed prior to admission, the numeric value will be prefixed with a
minus (-) sign. The days are calculated by subtracting the date of admission from the date of the
Other Procedure. If the Other Procedures were performed on the day of admission, the number of
days will be zero. If no Other Procedures or dates are reported, the days are shown as zero. The
maximum value is 9999, which means that the procedure was performed more than 9998 days after
admission.
Through 2000, if no procedure was performed, the days to procedure were shown as -999. For
procedures performed on the same day as admission, the days were displayed as zero.
Some hospitals report procedures performed on their inpatients, on an outpatient basis by another
facility, during the patient’s stay at the reporting hospital. Therefore, not all procedures reported by a
hospital were necessarily performed by and at that hospital.
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
July 2005 40 2004 Public Patient Discharge Data

APPENDICES
A full set of appendix files in a portable document format (.pdf) is included for easy viewing and
printing. In addition, a subset of five appendices is duplicated in an Excel file with each appendix in an
individual worksheet. These Excel worksheets can be used with relational database software to link
code numbers from the data to their respective labels (e.g., the Hospital ID Number, (OSHPD_ID),
from the data set can be matched with the hospital name in Appendix F). See the tables below for
appendix descriptions.
APPENDICES
PDF Files
The complete set of Appendices (PDF format) is located in the Appendices_04 folder.
Appendices File Name PDF files must be viewed/read with Adobe Acrobat Reader
A App_A_counties.pdf Listing of California counties (names and codes).
B App_B_mdc.pdf Listing of Major Diagnostic Categories (names and
codes)
C App_C_drg.pdf Listing of Diagnosis Related Groups (names and
codes)
D App_D_exceptions.pdf Data Exceptions (Approved Requests for
Modifications and Non-Compliances)
E App_E_plan_codes.pdf Plan Codes for Expected Source of Payment
F App_F_hospital_list.pdf Listing of all hospitals in data set (Hospital ID#,
Name, ZIP, Facility Level, and Total Discharges)
G App_G_report_form.pdf Manual Abstract Reporting Form (OSHPD-1370)
H App_H_data_fields.pdf Data Fields, comma delimited format, public set
I App_I_masked_field_freqs.pdf Frequencies, by Value, of Fields Subject to
Masking
APPENDICES SUBSET
Excel File
A duplicate, sub-set of Appendices (in MS-Excel format) is also located in the Appendices_04 folder. The
worksheets in this file can be used as relational database tables to link codes with labels
Appendices Worksheet Name Description
A App_A_counties Listing of California counties (names and codes)
B App_B_mdc Listing of Major Diagnostic Categories (names and
codes)
C App_C_drg Listing of Diagnosis Related Groups (names and
codes)
E App_E_plan_codes Plan Codes for Expected Source of Payment
F App_F_hospital_list
Listing of all hospitals in data set (Hospital ID#,
Name, ZIP, facility level of data aggregation and
total discharges)


Get Professional Assignment Help Cheaply

Buy Custom Essay

Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?

Whichever your reason is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.

Why Choose Our Academic Writing Service?

  • Plagiarism free papers
  • Timely delivery
  • Any deadline
  • Skilled, Experienced Native English Writers
  • Subject-relevant academic writer
  • Adherence to paper instructions
  • Ability to tackle bulk assignments
  • Reasonable prices
  • 24/7 Customer Support
  • Get superb grades consistently

Online Academic Help With Different Subjects

Literature

Students barely have time to read. We got you! Have your literature essay or book review written without having the hassle of reading the book. You can get your literature paper custom-written for you by our literature specialists.

Finance

Do you struggle with finance? No need to torture yourself if finance is not your cup of tea. You can order your finance paper from our academic writing service and get 100% original work from competent finance experts.

Computer science

Computer science is a tough subject. Fortunately, our computer science experts are up to the match. No need to stress and have sleepless nights. Our academic writers will tackle all your computer science assignments and deliver them on time. Let us handle all your python, java, ruby, JavaScript, php , C+ assignments!

Psychology

While psychology may be an interesting subject, you may lack sufficient time to handle your assignments. Don’t despair; by using our academic writing service, you can be assured of perfect grades. Moreover, your grades will be consistent.

Engineering

Engineering is quite a demanding subject. Students face a lot of pressure and barely have enough time to do what they love to do. Our academic writing service got you covered! Our engineering specialists follow the paper instructions and ensure timely delivery of the paper.

Nursing

In the nursing course, you may have difficulties with literature reviews, annotated bibliographies, critical essays, and other assignments. Our nursing assignment writers will offer you professional nursing paper help at low prices.

Sociology

Truth be told, sociology papers can be quite exhausting. Our academic writing service relieves you of fatigue, pressure, and stress. You can relax and have peace of mind as our academic writers handle your sociology assignment.

Business

We take pride in having some of the best business writers in the industry. Our business writers have a lot of experience in the field. They are reliable, and you can be assured of a high-grade paper. They are able to handle business papers of any subject, length, deadline, and difficulty!

Statistics

We boast of having some of the most experienced statistics experts in the industry. Our statistics experts have diverse skills, expertise, and knowledge to handle any kind of assignment. They have access to all kinds of software to get your assignment done.

Law

Writing a law essay may prove to be an insurmountable obstacle, especially when you need to know the peculiarities of the legislative framework. Take advantage of our top-notch law specialists and get superb grades and 100% satisfaction.

What discipline/subjects do you deal in?

We have highlighted some of the most popular subjects we handle above. Those are just a tip of the iceberg. We deal in all academic disciplines since our writers are as diverse. They have been drawn from across all disciplines, and orders are assigned to those writers believed to be the best in the field. In a nutshell, there is no task we cannot handle; all you need to do is place your order with us. As long as your instructions are clear, just trust we shall deliver irrespective of the discipline.

Are your writers competent enough to handle my paper?

Our essay writers are graduates with bachelor's, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college degree. All our academic writers have a minimum of two years of academic writing. We have a stringent recruitment process to ensure that we get only the most competent essay writers in the industry. We also ensure that the writers are handsomely compensated for their value. The majority of our writers are native English speakers. As such, the fluency of language and grammar is impeccable.

What if I don’t like the paper?

There is a very low likelihood that you won’t like the paper.

Reasons being:

  • When assigning your order, we match the paper’s discipline with the writer’s field/specialization. Since all our writers are graduates, we match the paper’s subject with the field the writer studied. For instance, if it’s a nursing paper, only a nursing graduate and writer will handle it. Furthermore, all our writers have academic writing experience and top-notch research skills.
  • We have a quality assurance that reviews the paper before it gets to you. As such, we ensure that you get a paper that meets the required standard and will most definitely make the grade.

In the event that you don’t like your paper:

  • The writer will revise the paper up to your pleasing. You have unlimited revisions. You simply need to highlight what specifically you don’t like about the paper, and the writer will make the amendments. The paper will be revised until you are satisfied. Revisions are free of charge
  • We will have a different writer write the paper from scratch.
  • Last resort, if the above does not work, we will refund your money.

Will the professor find out I didn’t write the paper myself?

Not at all. All papers are written from scratch. There is no way your tutor or instructor will realize that you did not write the paper yourself. In fact, we recommend using our assignment help services for consistent results.

What if the paper is plagiarized?

We check all papers for plagiarism before we submit them. We use powerful plagiarism checking software such as SafeAssign, LopesWrite, and Turnitin. We also upload the plagiarism report so that you can review it. We understand that plagiarism is academic suicide. We would not take the risk of submitting plagiarized work and jeopardize your academic journey. Furthermore, we do not sell or use prewritten papers, and each paper is written from scratch.

When will I get my paper?

You determine when you get the paper by setting the deadline when placing the order. All papers are delivered within the deadline. We are well aware that we operate in a time-sensitive industry. As such, we have laid out strategies to ensure that the client receives the paper on time and they never miss the deadline. We understand that papers that are submitted late have some points deducted. We do not want you to miss any points due to late submission. We work on beating deadlines by huge margins in order to ensure that you have ample time to review the paper before you submit it.

Will anyone find out that I used your services?

We have a privacy and confidentiality policy that guides our work. We NEVER share any customer information with third parties. Noone will ever know that you used our assignment help services. It’s only between you and us. We are bound by our policies to protect the customer’s identity and information. All your information, such as your names, phone number, email, order information, and so on, are protected. We have robust security systems that ensure that your data is protected. Hacking our systems is close to impossible, and it has never happened.

How our Assignment Help Service Works

1. Place an order

You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.

2. Pay for the order

Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.

3. Track the progress

You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.

4. Download the paper

The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.

smile and order essay GET A PERFECT SCORE!!! smile and order essay Buy Custom Essay


Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!
Open chat
1
Need assignment help? You can contact our live agent via WhatsApp using +1 718 717 2861

Feel free to ask questions, clarifications, or discounts available when placing an order.
  +1 718 717 2861           + 44 161 818 7126           [email protected]
  +1 718 717 2861         [email protected]