icd_diagnosis_hierarchy2_lookup
ICD diagnosis code hierarchy level 2 lookup (https://www.cms.gov/medicare/coding-billing/icd-10-codes).
Primary Key:Indexes:icd_diagnosis_hierarchy2_lookup_uq(Unique) -name
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
icd_diagnosis_hierarchy2_id | bigint | No | Yes | Snowflake ID for ICD Diagnosis hierarchy level 2. Generated through expression: |
name | text | No | Yes | The name of the second level of the hierarchy, for example: 'Disorders of thyroid gland (E00-E07)'. Generated through expression: |