Hospital Discharge Database
Inpatient Interactive Query System
Data Element Descriptions

Data Element Categories Description Comments
Primary Diagnostic Category Diagnosis codes from the ICD-9-CM classification system are used.
The categories available for selection are derived from the principle diagnosis code. Diagnostic grouping is done using the clinical classificaton software (CCS) developed by the Healthcare Cost and Utilization Project (HCUP). The ICD-9-CM's diagnosis codes (more than 12,000) are collapsed into a smaller number of clinically meaningful categories that are sometimes more useful for presenting descriptive statistics than are individual ICD-9-CM codes.
There are currently 259 separate categories of diagnosis codes in the CCS system.
Primary Surgical Category Procedure (surgical) codes from the ICD-9-CM classification system are used.
The categories available for selection are derived from the principle procedure (surgical) code. Surgical grouping is done using the clinical classificaton software developed by the HCUP. The ICD-9-CM's procedure codes (more than 3,500) are collapsed into a smaller number of clinically meaningful categories that are sometimes more useful for presenting descriptive statistics than are individual ICD-9-CM codes.
There are currently 231 separate categories of surgical procedures in the CCS system.
Diagnosis Related Groups (DRGs) One of the most common categories used in the analysis and study of health care data.
All possible principle diagnoses are divided into major diagnostic categories (MDCs) which are further divided into smaller groups of clinically coherent categories of patients with treatments consuming generally consistent amounts of resources. There are currently 25 MDCs and more than 500 DRGs with potential new categories evaluated each year.
Major Diagnostic Categories (MDCs) Diagnoses in each MDC correspond to a single organ system or etiology and are generally associated with a certain medical specialty. MDCs provide high order categories to focus on entire body systems. There are currently 25 separate MDC categories. All possible principle diagnoses are divided into major diagnostic categories (MDCs) as the first step in assigning a specific diagnosis related group (DRG) to the treatment received by each patient. There are certain conditions in which no MDC is assigned. These are organ transplants, conditions involving tracheostomy, certain surgical procedures unrelated to the principle diagnosis, principle diagnosis invalid as a discharge diagnosis and ungroupable clinical data. The last two situations should rarely be found due to exhaustive pre-editing of data received from Illinois hosptials. You may wish to refer to other resources for additional information related to MDC assignments.
Time Period Year and quarter
  Quarterly time frames are based on the date of discharge from the hospital.
ZIP Code Category All ZIP code populations in Illinois were aggregated to the first four then the first three digits. All groups with at least 20,000 residents in the population were retained, with all other ZIP codes, along with unknown Illinois, out-of-state and foreign addresses were included in category 0000 as unknown. ZIP code of patient residence at the time of hospitalization.
Post office box addresses are considered unknown.
Patient Residence Strata City of Chicago
Suburban Cook county
Metro collar counties
Urban counties
Rural counties
out-of-state/unknown
Strata of patient residence at the time of hospitalization. Post office box addresses considered unknown.
Patient Admit Type Emergency
Urgent
Elective
Newborn
Trauma center
Info not available
  Identifies the type of admission to the hospital.
Patient Admit Source Physician referral
Clinical referral
HMO referral
Another hospital
Skilled nursing facility
Another health care
  facility
Emergency department
Court/law
  enforcement
Info not avail
Critical access
  hospital
Newborn - normal
  delivery
Newborn - premature
  delivery
Newborn - sick baby
Newborn - extramural
  birth
Newborn - info not
  avail
  Identifies the source of admission to the hospital.
Patient Discharge Status Routine discharge
Short-term general
  hospital
Skilled nursing
  facility
Intermediate care
  facility
Another type of
  institution
Home under care of
  organized home
  health service
Left against medical
  advice
Home under the care
  of home IV drug
  therapy provider
Other
  Identifies the status of the patient at discharge from the provider.
Length of Stay (days) Less than 7
7 - 13
14 - 29
30 and more
The number of days a patient was hospitalized. Identifies the length of time that patients were hospitalized, including outlier cases in which the degree of severity of the condition within the respective diagnosis related group (DRG) required stays below or beyond the average length of stay.
Hospital Charges Less than $ 3,500.00
$ 3,500.00-6,499.99
$ 6,500.00-11,999.99
$ 12,000.00-35,999.99
$ 36,000.00-99,999.99
$ 100,000.00 or more
Identifies the hospital charges incurred during hospitalization. Due to managed care contracting, payor discount arrangements, Medicare and Medicaid payment plans, and other agreements, charges reflect hospital billing only, not necessarily actual consumer payment.

In addition, some services or items provided in the hospital may not be reflected in each hospital's charges due to contractual arrangements or limitations with other clinical providers, e.g., anesthesia, diagnostic testing, professional clinical services, etc.
Payor Medicare
Medicaid
Insurance
Self pay
Other
Indicates the primary source of expected payment for the hospital charges. The final payment may vary from the initial charge for services. HMO and all commercial payers are combined as insurance.
Age Group 0
1 - 4
5 - 14
15 - 24
25 - 34
35 - 44
45 - 54
55 - 64
75 - 74
75 - 84
85 and older
Age in years, based on the date of discharge from the hospital. Age values are, for the most part, provided in 10 year intervals.
Gender Female
Male
   

Back to previous page