icd_procedure_hierarchy

Crosswalk between ICD procedure code and the hierarchy lookups.

Primary Key:

• icd_procedure_id

Foreign Keys:

• icd_procedure_hierarchy_table_id => icd_procedure_hierarchy3_lookup.icd_procedure_hierarchy_table_id, release_date => icd_procedure_hierarchy3_lookup.release_date
• icd_procedure_hierarchy_table_id => icd_procedure_hierarchy4_lookup.icd_procedure_hierarchy_table_id, icd_procedure_hierarchy4_id => icd_procedure_hierarchy4_lookup.icd_procedure_hierarchy4_id, release_date => icd_procedure_hierarchy4_lookup.release_date
• icd_procedure_hierarchy_table_id => icd_procedure_hierarchy5_lookup.icd_procedure_hierarchy_table_id, icd_procedure_hierarchy5_id => icd_procedure_hierarchy5_lookup.icd_procedure_hierarchy5_id, release_date => icd_procedure_hierarchy5_lookup.release_date

Indexes:

• icd_procedure_hierarchy_3_idx - icd_procedure_hierarchy_table_id
• icd_procedure_hierarchy_4_idx - icd_procedure_hierarchy4_id
• icd_procedure_hierarchy_5_idx - icd_procedure_hierarchy5_id

Column	Data Type	Nullable	Indexed	Description
icd_procedure_id	bigint	No	Yes	-
icd_procedure_hierarchy_table_id	character	No	Yes	-
icd_procedure_hierarchy4_id	character	No	Yes	-
icd_procedure_hierarchy5_id	character	No	Yes	-
release_date	date	No	No	-