claim_drg

Provides information about the Diagnosis-Related Group (DRG) code associated with an inpatient claim. https://www.cms.gov/medicare/payment/prospective-payment-systems/acute-inpatient-pps/ms-drg-classifications-and-software

Primary Key:

• claim_id

Checks:

• claim_drg_drg_code_check - (drg_code <> ''::text)

Foreign Keys:

• claim_id => claim.claim_id
• drg_id => msdrg_lookup.drg_id
• grouped_drg_id => msdrg_lookup.drg_id

Indexes:

• claim_drg_drg_id_idx - drg_id
• claim_drg_grouped_drg_id_idx - grouped_drg_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	Link to the claim record. Generated through expression:
drg_code	text	No	No	The Medicare Severity-Diagnosis Related Group (MS-DRG) code given by the provider in a claim. (Loop 2300 HI01=DR / UB04 FL71). See https://www.cms.gov/icd10m/version37-fullcode-cms/fullcode_cms/Defining_the_Medicare_Severity_Diagnosis_Related_Groups_(MS-DRGs).pdf for information about how it is calculated. Generated through expression:
drg_id	bigint	Yes	Yes	Link to the canonical MSDRG lookup record. Generated through expression:
grouped_drg_code	text	No	No	The Medicare Severity-Diagnosis Related Group (MS-DRG) calculated by the CMS inpatient grouper. See https://www.cms.gov/icd10m/version37-fullcode-cms/fullcode_cms/Defining_the_Medicare_Severity_Diagnosis_Related_Groups_(MS-DRGs).pdf for information about how it is calculated. Generated through expression:
grouped_drg_id	bigint	Yes	Yes	Link to the Grouped DRG MSDRG lookup record. Generated through expression: