Grossmont-Cuyamaca Community College District SPSS Health Data Analysis HW

User Generated

bcbyv31

Mathematics

Grossmont-Cuyamaca Community College District

Description

-Must be done in SPSS

-Must use all 3 documents to complete assignment

-Assignment must be done accuretely and well

-ZIP file needs to be exported to SPSS in order to complete the assignment. (would not let me post it as original "SAV" file.)

- If you have any questions please contact me ASAP.

Unformatted Attachment Preview

California County Codes Code 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Value Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings Lake Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas Riverside Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo San Mateo Santa Barbara Santa Clara Santa Cruz Shasta Sierra Siskiyou Solano 49 50 51 52 53 54 55 56 57 58 Sonoma Stanislaus Sutter Tehama Trinity Tulare Tuolumne Ventura Yolo 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 = N = Category Yes - a DNR order was written at the time of or within the first 24 hours of patient's admission to the hospital. 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 01 02 03 04 05 Category Medicare Medi-Cal Private Coverage Workers’ Compensation County Indigent Programs Code 06 07 08 09 00 Category 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
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Question 1
Disposition of Patient
Cumulative
Frequency
Valid

Percent

Valid Percent

Percent

0

3

.0

.0

.0

1

22028

76.0

76.0

76.0

2

101

.3

.3

76.4

3

210

.7

.7

77.1

4

404

1.4

1.4

78.5

5

608

2.1

2.1

80.6

6

246

.8

.8

81.4

7

1782

6.1

6.1

87.6

8

303

1.0

1.0

88.6

9

108

.4

.4

89.0

10

356

1.2

1.2

90.2

11

613

2.1

2.1

92.3

12

2150

7.4

7.4

99.8

13

67

.2

.2

100.0

28979

100.0

100.0

Total

a. What percent of all patients was discharged to another department within the hospital?

As per the documentation, the patients who were discharged to another department were the
ones with codes; 02-acute care, 03 – other care and 04 – Skilled Nursing/ Intermediate care.
The percentages of each category as shown in the SPSS output are;
02 = 0.3%
03 = 0.7%
04 = 1.4%
Thus total = (0.3 + 0.7+ 1.4) = 2.4%, which is the percentage of the patients who were
discharged to another department within the hospital.

b.

What percent of all patients was discharged to another hospital?



Refers to all codes from 05 to 13. Since all the values were valid as ...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4