icd_procedure_hierarchy_title_lookup
Stores the titles used to describe each of the hierarchy levels, which vary depending on the section code (hierarchy level 1). For example in 'Medical and Surgical procedures' the letters of the procedure describe the 'section', 'body system', 'operation', etc. but for 'Physical Rehabilitation and Diagnostic Audiology', the letters of the procedure describe the 'section', 'section qualifier', 'type', etc. This table makes it possible to correctly build a ICD-procedure drill-down UI.
Primary Key:Foreign Keys:icd_procedure_hierarchy1_id=>icd_procedure_hierarchy1_lookup.icd_procedure_hierarchy1_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
icd_procedure_hierarchy1_id | bigint | No | Yes | - Generated through expression: |
hierarchy2_title | text | No | No | Level 2 hierarchy title. Generated through expression: |
hierarchy3_title | text | No | No | Level 3 hierarchy title. Generated through expression: |
hierarchy4_title | text | No | No | Level 4 hierarchy title. Generated through expression: |
hierarchy5_title | text | No | No | Level 5 hierarchy title. Generated through expression: |
release_date | date | No | Yes | - Generated through expression: |