DRG Codes

Hospital level table

drgcodes

Diagnosis related groups (DRGs) are used by the hospital to obtain reimbursement for a patient’s hospital stay. The codes correspond to the primary reason for a patient’s stay at the hospital.

Table columns

Name Postgres data type
subject_id INTEGER
hadm_id INTEGER
drg_type VARCHAR(4)
drg_code VARCHAR(10)
description VARCHAR(195)
drg_severity SMALLINT
drg_mortality SMALLINT

Detailed Description

subject_id

subject_id is a unique identifier which specifies an individual patient. Any rows associated with a single subject_id pertain to the same individual.

hadm_id

hadm_id is an integer identifier which is unique for each patient hospitalization.

drg_type

The specific DRG ontology used for the code.

drg_code

The DRG code.

description

A description for the given DRG code.

drg_severity, drg_mortality

Some DRG ontologies further qualify the patient severity of illness and likelihood of mortality, which are recorded here.


Last modified August 14, 2020: update website to use docsy (adc506c)