claim_drg

Provides information about the DRG code associated with an inpatient claim

Primary Key:

• claim_id

Foreign Keys:

• 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	-
drg_code	text	No	No	-
drg_id	bigint	Yes	Yes	-
grouped_drg_code	text	No	No	-
grouped_drg_id	bigint	Yes	Yes	-