icd_procedure_hierarchy
Crosswalk between ICD procedure code and the hierarchy lookups.
Primary Key:Foreign Keys:icd_procedure_hierarchy1_id=>icd_procedure_hierarchy1_lookup.icd_procedure_hierarchy1_idicd_procedure_hierarchy2_id=>icd_procedure_hierarchy2_lookup.icd_procedure_hierarchy2_idicd_procedure_hierarchy3_id=>icd_procedure_hierarchy3_lookup.icd_procedure_hierarchy3_idicd_procedure_hierarchy4_id=>icd_procedure_hierarchy4_lookup.icd_procedure_hierarchy4_idicd_procedure_hierarchy5_id=>icd_procedure_hierarchy5_lookup.icd_procedure_hierarchy5_id
icd_procedure_hierarchy_icd_procedure_hierarchy1_id_idx-icd_procedure_hierarchy1_idicd_procedure_hierarchy_icd_procedure_hierarchy2_id_idx-icd_procedure_hierarchy2_idicd_procedure_hierarchy_icd_procedure_hierarchy3_id_idx-icd_procedure_hierarchy3_idicd_procedure_hierarchy_icd_procedure_hierarchy4_id_idx-icd_procedure_hierarchy4_idicd_procedure_hierarchy_icd_procedure_hierarchy5_id_idx-icd_procedure_hierarchy5_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
icd_procedure_id | bigint | No | Yes | - Generated through expression: |
icd_procedure_hierarchy4_id | bigint | No | Yes | - Generated through expression: |
icd_procedure_hierarchy5_id | bigint | No | Yes | - Generated through expression: |
icd_procedure_hierarchy1_id | bigint | No | Yes | - Generated through expression: |
icd_procedure_hierarchy2_id | bigint | No | Yes | - Generated through expression: |
icd_procedure_hierarchy3_id | bigint | No | Yes | - Generated through expression: |