Programming Question

https://drive.google.com/file/d/1f7rR__IsLTGrkXP2s…

PH 307
Assignment #4 – Using SPSS to Analyze Health Data
Students should work in pairs on the assignment, with one assignment submitted per pair; both
students in a pair will receive the same grade. It is strongly recommended that both students
actively participate in preparing the assignment. If, instead, partners choose to split the
assignment (with each being responsible for different parts of the assignment), be aware than
one person’s poor/non-completion of his/her portion is NOT an acceptable reason for
submitting the assignment late.
To complete this assignment, you will need the following files:
a) OSHPD Data File
b) OSHPD Documentation
c) CA County Codes
All the necessary files can be found on the Assignment 4 page.
INSTRUCTIONS – READ CAREFULLY
These instructions apply to all parts of Assignment 4. Points are associated with all
instructions; not following the instructions will result in a loss of points and can have a
significant impact on your grade.
Copy results from your SPSS output file into a Word document. (Add your answers and output
to this document.) If you are asked for percent, use complete sentences; it is NOT sufficient to
paste the results into Word.
Name the Word document as follows: OurLastNamesFirst Initials_Assign4.docx (or
MyLastNameFirstInitial_Assign3.xlsx), where you replace OurLastNamesFirst Initials with your
first initials and last names (e.g., WolfJ_LoboJ_Assign4.docx). Your names must be a part of the
file name. Please also type your names at the top of the Word document. Your SPSS data file
(.sav file) should be named in the same way as the Word document. Upload both the Word
document and your SPSS data file (.sav file) to Canvas on the Assignment 4 page.
You must paste the log that describes the recoding of all variables needing to be recoded and
all information on the work you have completed to answer the questions in this document
holding your answers. Your SPSS data file (.sav) should match your answers. (In other words, I
should be able to run the analyses from your SPSS file and get the same results you report.) You
are required to type the value labels into the variable view of the SPSS file for all variables
that you use, including the original variables you recode.
1
PH 307
NOTE: You will want to save your SPSS .sav file as you will be using some of these recoded
variables in Assignment 5.
Read each question carefully.
Question 1 (10 points)
Run a frequency on the variable “race.” The frequency table should be ordered (within SPSS) to
show the races from the greatest number to the least. (3 pts)
B. Show the frequency table with all values labeled. (2 pts)
C. What percent of individuals were white? (2 pts)
D. What percent of individuals were of “other” race? (2 pts)
C. Show the log for running the frequency. (1 pt)
Question 2 (8 points)
A. Recode the variable “pay_cat” (payer category) into 4 groups: Medicare/Medi-Cal, Private
Coverage, Self-Pay, and Other (“Other” should include all other values that represent a valid
group.). (3 pts)
B. Show frequency tables of the original and recoded variables with all values labeled. (3 pts)
C. Show the log for the recode and for running the frequencies. (2 pts)
Question 3 (8 points)
A. Recode the variable “race” into 2 groups: “White” and “All other races combined.” (“All
other races combined should include all valid races.) HINT: Check to see if “race” is a string
or numeric variable. (3 pts)
B. Show the frequency table of the recoded variable with values labeled. (3 pts)
C. Show the log for the recode and for running the frequency. (2 pts)
Question 4 (8 points)
A. Recode the variable “charges” so that charges of “0” and “1” are made system missing; all
other charges should remain the same. Name this variable “NewChg.” (4 pts)
2
PH 307
B. Run frequencies on both the original and new charges variables. Paste the “Statistics” table
(do NOT paste the frequency tables) showing the number of valid and missing cases for the
old and new variables into your homework. (2 pts)
C. Show the log for the recode and for running the frequencies. (2 pts)
Question 5 (10 points)
A. Recode the variable “los” (length of stay) per the instructions in the Patient Data Discharge
File Documentation into a new variable, NewLOS. Make certain to handle all values
appropriately. (4 pts)
B. Run frequencies on both the original and new variables. (2 pts)
C. Paste the “Statistics” table (do NOT paste the frequency tables) showing the number of
valid and missing cases for the old and new variables into your homework. (2 pt)
D. Show the log for the recode and for running the frequencies. (2 pts)
Question 6 (4 points)
A. Using the new variables NewChg and NewLOS, create a variable for charge per day,
ChargeDay, using this equation: NewChg / NewLOS. (3 pts)
B. Show the log for creating the variable. (1 pt)
Question 7 (10 points)
A. Recode the variable “agecat20” into 4 groups: age 19 and below, age 20-34 and age 35-64,
age 65 and above. (3 pts)
B. Create an show a crosstabs table using the original and recoded variable to check that
recode was completed correctly. (3 pts)
C. What percent of individuals are ages 20 to 34? (2 pts)
D. Show the log for the recode and for the crosstabs table with values labeled. (2 pts)
Attach your SPSS data file. (2 pts)
3
California County Codes
Code
Value
Code
Value
01
Alameda
30
Orange
02
Alpine
31
Placer
03
Amador
32
Plumas
04
Butte
33
Riverside
05
Calaveras
34
Sacramento
06
Colusa
35
San Benito
07
Contra Costa
36
San Bernardino
08
Del Norte
37
San Diego
09
El Dorado
38
San Francisco
10
Fresno
39
San Joaquin
11
Glenn
40
San Luis Obispo
12
Humboldt
41
San Mateo
13
Imperial
42
Santa Barbara
14
Inyo
43
Santa Clara
15
Kern
44
Santa Cruz
16
Kings
45
Shasta
17
Lake
46
Sierra
18
Lassen
47
Siskiyou
19
Los Angeles
48
Solano
20
Madera
49
Sonoma
21
Marin
50
Stanislaus
22
Mariposa
51
Sutter
23
Mendocino
52
Tehama
24
Merced
53
Trinity
25
Modoc
54
Tulare
26
Mono
55
Tuolumne
27
Monterey
56
Ventura
28
Napa
57
Yolo
29
Nevada
58
Yuba
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
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
Appendix B
Appendix C
Appendix D
Appendix E
Appendix F
Appendix G
Appendix H
Appendix I
County Names and Codes………………………………………………………………….. A – 1
Major Diagnostic Categories (MDCs) ………………………………………………….. B – 1
Diagnosis Related Groups (DRGs)………………………………………………………. C – 1
Data Exceptions (as reported) …………………………………………………………….. D – 1
Plan Codes, Expected Source of Payment……………………………………………. E – 1
Hospital Listing………………………………………………………………………………….. F – 1
Manual Abstract Reporting Form ………………………………………………………….G – 1
Comma-Delimited Field List………………………………………………………………… H – 1
Masked Variable Frequencies ……………………………………………………………… I – 1
i
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
1st
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
DATA FIELDS SUBJECT TO MASKING
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.
July 2005
1
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
Public Discharge Dataset
Data Fields in 2004 Public Discharge Dataset
Hospital Identification Number
Percent Remaining
Unmasked
For Variables
Subject to Masking
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
July 2005
2
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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-9CM 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.
July 2005
3
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.”
July 2005
4
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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)
July 2005
5
Added – January 1999
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
Not Defaulted
One Variable Defaulted
Multiple Variables Defaulted
3,948,168
9,195
277
Percent of
Records
99.76%
.23%
.01%
Other data exceptions are listed by hospital in Appendix D, Data Exceptions.
July 2005
6
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
B – 9999
=
=
01-58 = County Codes (see Appendix A)
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.
July 2005
7
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
1 = Acute Care
3 = Skilled Nursing/Intermediate Care
4 = Psychiatric Care
5 = Chemical Dependency Recovery Care
6 = Physical Rehabilitation Care
Licensed Bed Classification/Designation
General Acute Care
Skilled Nursing/Intermediate Care (a.k.a. Long Term
Care)
Acute Psychiatric Care
Chemical Dependency Recovery Hospital/Service
Rehabilitation Center, a bed designation within the
General Acute Care classification.
All other values for Type of Care are not considered valid.
July 2005
8
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
9
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
00
AGE
under 1 year
1-4 years
5-9 years
10-14 years
15-19 years
20-24 years
25-29 years
30-34 years
35-39 years
40-44 years
45-49 years
50-54 years
55-59 years
60-64 years
65-69 years
70-74 years
75-79 years
80-84 years
85 years & over
unknown (0)
DEFINITION
under 1 year
366 days through 4 years
5 years through 9 years
10 years through 14 years
15 years through 19 years
20 years through 24 years
25 years through 29 years
30 years through 34 years
35 years through 39 years
40 years through 44 years
45 years through 49 years
50 years through 54 years
55 years through 59 years
60 years through 64 years
65 years through 69 years
70 years through 74 years
75 years through 79 years
80 years through 84 years
85 years or greater
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.
July 2005
10
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
AGE 5 CATEGORY
FIELD NAME
:
AGECAT5
DEFINITION
:
Five age categories; Random year increments.
CODES, CATEGORIES AND COMMENTS:
CATEGORY
01
02
03
04
05
00
AGE
Under 1 year
1-17 years
18-34 years
35-64 years
65years & over
Unknown (0)
DEFINITION
Under 1 year
1 year through 17 years
18 years through 34 years
35years through 64 years
65 years or greater
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.
July 2005
11
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
SEX
FIELD NAME
:
SEX
DEFINITION
:
This is the gender of the patient.
CODES, CATEGORIES AND COMMENTS:
Code
1
2
3
4
Category
Male
Female
Other
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.
July 2005
12
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
1
2
3
Category
Hispanic
Non-Hispanic
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.
July 2005
13
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
RACE
FIELD NAME
:
RACE
DEFINITION
:
This code indicates the patient’s racial background.
CODES, CATEGORIES AND COMMENTS:
Code
1
Category
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.
July 2005
14
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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 3digits, then from 3-digits to just an asterisk, if required to de-identify the record.
July 2005
15
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
CE (Central)
NE (Northeastern)
NW (Northwestern)
COUNTIES
Alpine, Inyo, Mariposa and Mono
Modoc, Plumas and Sierra
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.
July 2005
16
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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).
July 2005
17
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
ADMISSION: QUARTER
FIELD NAME
:
ADM_QTR
DEFINITION
:
Quarter the patient was admitted to the hospital.
CODES, CATEGORIES AND COMMENTS:
One-digit quarter
Code
1
2
3
4
Quarter
January-March
April-June
July-September
October-December
Quarter admitted will be the 7th variable masked if necessary to de-identify unique patient records by
replacing code with an asterisk.
July 2005
18
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
19
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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:
Category
Code
1
This Hospital
2
Another Hospital
3
Not a Hospital
All other values for “Licensure of Site” are not considered valid.
Route:
Category
Code
1
Your ER
2
Not Your ER (or no ER)
All other values for “Route” are not considered valid.
July 2005
20
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
1
2
3
4
Category
Scheduled (Scheduled in advance, at least of 24 hours or more prior to admission)
Unscheduled (Not scheduled within 24 hours or more prior to admission)
Infant, less than 24 hrs old
Unknown (Does not include stillbirths)
All other values for Type of Admission are not considered valid.
July 2005
21
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
01
Category
Routine (Home)
Within this Hospital:
Code
Category
02
Acute Care
03
Other Care
04
Skilled Nursing/Intermediate Care
To Another Hospital:
Category
Code
05
Acute Care
06
Other Care (not Skilled Nursing/Intermediate Care)
07
08
09
10
11
12
13
Skilled Nursing/Intermediate Care
Residential Care Facility
Prison/Jail
Against Medical Advice
Died
Home Health Service
Other
All other values for Disposition are not considered valid.
July 2005
22
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
Y =
Category
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.
July 2005
23
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
02
03
04
05
Medicare
Medi-Cal
Private Coverage
Workers’ Compensation
County Indigent Programs
06
07
08
09
00
Other Government
Other Indigent
Self Pay
Other Payer
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.
July 2005
24
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
1
2
3
0
=
=
=
=
Category
Managed Care – Knox-Keene/MCOHS
Managed Care – Other
Traditional Coverage
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.
July 2005
25
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
26
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
27
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.)
July 2005
28
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.)
July 2005
29
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
30
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
July 2005
31
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.)
July 2005
32
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
Y
N
U
=
=
=
Category
Yes
No
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.
July 2005
33
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.)
July 2005
34
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
35
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.)
July 2005
36
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
37
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.)
July 2005
38
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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.
July 2005
39
2004 Public Patient Discharge Data
CALIFORNIA PATIENT DISCHARGE DATA
January-December 2004
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
A
App_A_counties.pdf
B
App_B_mdc.pdf
C
App_C_drg.pdf
D
App_D_exceptions.pdf
E
App_E_plan_codes.pdf
F
App_F_hospital_list.pdf
G
H
App_G_report_form.pdf
App_H_data_fields.pdf
I
App_I_masked_field_freqs.pdf
PDF files must be viewed/read with Adobe Acrobat Reader
Listing of California counties (names and codes).
Listing of Major Diagnostic Categories (names and
codes)
Listing of Diagnosis Related Groups (names and
codes)
Data Exceptions (Approved Requests for
Modifications and Non-Compliances)
Plan Codes for Expected Source of Payment
Listing of all hospitals in data set (Hospital ID#,
Name, ZIP, Facility Level, and Total Discharges)
Manual Abstract Reporting Form (OSHPD-1370)
Data Fields, comma delimited format, public set
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
A
App_A_counties
B
App_B_mdc
C
App_C_drg
E
App_E_plan_codes
F
App_F_hospital_list
July 2005
Description
Listing of California counties (names and codes)
Listing of Major Diagnostic Categories (names and
codes)
Listing of Diagnosis Related Groups (names and
codes)
Plan Codes for Expected Source of Payment
Listing of all hospitals in data set (Hospital ID#,
Name, ZIP, facility level of data aggregation and
total discharges)
40
2004 Public Patient Discharge Data