icd_procedure_hierarchy

Crosswalk between ICD procedure code and the hierarchy lookups.

Primary Key:

• icd_procedure_id

Foreign Keys:

• icd_procedure_hierarchy1_id => icd_procedure_hierarchy1_lookup.icd_procedure_hierarchy1_id
• icd_procedure_hierarchy2_id => icd_procedure_hierarchy2_lookup.icd_procedure_hierarchy2_id
• icd_procedure_hierarchy3_id => icd_procedure_hierarchy3_lookup.icd_procedure_hierarchy3_id
• icd_procedure_hierarchy4_id => icd_procedure_hierarchy4_lookup.icd_procedure_hierarchy4_id
• icd_procedure_hierarchy5_id => icd_procedure_hierarchy5_lookup.icd_procedure_hierarchy5_id

Indexes:

• icd_procedure_hierarchy_icd_procedure_hierarchy1_id_idx - icd_procedure_hierarchy1_id
• icd_procedure_hierarchy_icd_procedure_hierarchy2_id_idx - icd_procedure_hierarchy2_id
• icd_procedure_hierarchy_icd_procedure_hierarchy3_id_idx - icd_procedure_hierarchy3_id
• icd_procedure_hierarchy_icd_procedure_hierarchy4_id_idx - icd_procedure_hierarchy4_id
• icd_procedure_hierarchy_icd_procedure_hierarchy5_id_idx - icd_procedure_hierarchy5_id

Column	Data Type	Nullable	Indexed	Description
icd_procedure_id	bigint	No	Yes	-
icd_procedure_hierarchy4_id	bigint	No	Yes	-
icd_procedure_hierarchy5_id	bigint	No	Yes	-
icd_procedure_hierarchy1_id	bigint	No	Yes	-
icd_procedure_hierarchy2_id	bigint	No	Yes	-
icd_procedure_hierarchy3_id	bigint	No	Yes	-