claim_diagnosis

Provides information about the ICD diagnosis codes associated with a claim

Primary Key:

• claim_id
• claim_diagnosis_index

Foreign Keys:

• claim_id => claim.claim_id
• icd_diagnosis_id => icd_diagnosis_lookup.icd_diagnosis_id

Indexes:

• claim_diagnosis_claim_id_idx - claim_id
• claim_diagnosis_icd_diagnosis_id_idx - icd_diagnosis_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	-
diagnosis_code	text	No	No	-
icd_version	text	No	No	-
diagnosis_type	diagnosis_code_type	Yes	No	-
present_on_admission	yes_no_response_type	Yes	No	-
icd_diagnosis_id	bigint	Yes	Yes	-
claim_diagnosis_index	smallint	No	Yes	-
hcup_diagnosis_group_id	bigint	Yes	No	-