icd_procedure_hierarchy3_lookup

ICD procedure code hierarchy level 3 lookup.

Primary Key:

• icd_procedure_hierarchy_table_id
• release_date

Foreign Keys:

• icd_procedure_hierarchy1_id => icd_procedure_hierarchy1_lookup.icd_procedure_hierarchy1_id, release_date => icd_procedure_hierarchy1_lookup.release_date
• icd_procedure_hierarchy1_id => icd_procedure_hierarchy2_lookup.icd_procedure_hierarchy1_id, icd_procedure_hierarchy2_id => icd_procedure_hierarchy2_lookup.icd_procedure_hierarchy2_id, release_date => icd_procedure_hierarchy2_lookup.release_date

Indexes:

• icd_procedure_hierarchy3_lookup_icd_procedure_hierarchy1_idx - icd_procedure_hierarchy1_id, release_date
• icd_procedure_hierarchy3_lookup_icd_procedure_hierarchy2_idx - icd_procedure_hierarchy2_id

Column	Data Type	Nullable	Indexed	Description
icd_procedure_hierarchy_table_id	character	No	Yes	-
icd_procedure_hierarchy1_id	character	No	Yes	-
icd_procedure_hierarchy2_id	character	No	Yes	-
release_date	date	No	Yes	-
name	text	No	No	-