msdrg_lookup

Contains Medicare Severity Diagnosis-Related Group (MS-DRG) information. (See: https://www.cms.gov/medicare/payment/prospective-payment-systems/acute-inpatient-pps/ms-drg-classifications-and-software)

Primary Key:

• drg_id

Indexes:

• msdrg_lookup_drg_code_release_date_idx (Unique) - drg_code, release_date

Column	Data Type	Nullable	Indexed	Description
drg_id	bigint	No	Yes	Snowflake ID for DRG record. Generated through expression:
drg_code	text	No	Yes	DRG Code. For example, DRG '291' or '470'. Generated through expression:
mdc	smallint	Yes	No	Major Diagnostic Category. For example, '01' for 'Diseases & Disorders of the Nervous System'. Generated through expression:
medical_or_surgical	medical_or_surgical_type	No	No	Indicates whether DRG code is medical or surgical. Generated through expression:
drg_description	text	No	No	DRG description such as for '001' for 'Heart transplant or implant of heart assist system with MCC'. Generated through expression:
base_drg_description	text	No	No	Describes the DRG excluding the severity. For example DRG 001 and 002 both have the Base DRG Description of 'Heart transplant or implant of heart assist system' while 001 has a severity of 'with MCC' and 002 has a severity of 'without MCC' Generated through expression:
mdc_description	text	No	No	Major Diagnostic Category description. For example, for MDC '01': 'Diseases & Disorders of the Nervous System'. Generated through expression:
severity	smallint	No	No	Severity of the MS-DRG. '1': 'Basic (no MCC or CC)', '2': 'Complication or Comorbidity (CC)', '3': 'Major Complication or Comorbidity (MCC). Generated through expression:
version	text	No	No	Version of the Medicare Severity Diagnosis-Related Groups (MS-DRGs). Generated through expression:
release_date	date	No	Yes	Release date of the Medicare Severity Diagnosis-Related Groups (MS-DRGs). Generated through expression: