icd_diagnosis_hierarchy

ICD diagnosis code hierarchy.

Primary Key:

• icd_diagnosis_id

Foreign Keys:

• icd_diagnosis_hierarchy1_id => icd_diagnosis_hierarchy1_lookup.icd_diagnosis_hierarchy1_id
• icd_diagnosis_hierarchy2_id => icd_diagnosis_hierarchy2_lookup.icd_diagnosis_hierarchy2_id
• icd_diagnosis_hierarchy3_id => icd_diagnosis_hierarchy3_lookup.icd_diagnosis_hierarchy3_id
• icd_diagnosis_hierarchy4_id => icd_diagnosis_hierarchy4_lookup.icd_diagnosis_hierarchy4_id

Indexes:

• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy1_id_idx - icd_diagnosis_hierarchy1_id
• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy2_id_idx - icd_diagnosis_hierarchy2_id
• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy3_id_idx - icd_diagnosis_hierarchy3_id
• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy4_id_idx - icd_diagnosis_hierarchy4_id

Column	Data Type	Nullable	Indexed	Description
icd_diagnosis_id	bigint	No	Yes	Link to the ICD diagnosis record (https://www.cms.gov/medicare/coding-billing/icd-10-codes). Generated through expression:
icd_diagnosis_hierarchy1_id	bigint	No	Yes	Link to the first level of the ICD diagnosis hierarchy. Generated through expression:
icd_diagnosis_hierarchy2_id	bigint	No	Yes	Link to the second level of the ICD diagnosis hierarchy. Generated through expression:
icd_diagnosis_hierarchy3_id	bigint	No	Yes	Link to the third level of the ICD diagnosis hierarchy. Generated through expression:
icd_diagnosis_hierarchy4_id	bigint	Yes	Yes	Link to the fourth level of the ICD diagnosis hierarchy. Generated through expression: