icd_diagnosis_hierarchy1_lookup
ICD diagnosis code hierarchy level 1 lookup (https://www.cms.gov/medicare/coding-billing/icd-10-codes).
Primary Key:Indexes:icd_diagnosis_hierarchy1_lookup_uq(Unique) -name
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
icd_diagnosis_hierarchy1_id | bigint | No | Yes | Snowflake ID for ICD Diagnosis hierarchy level 1. Generated through expression: |
name | text | No | Yes | The name of the first level of the hierarchy, for example: 'Endocrine, Nutritional, and Metabolic Diseases (E00-E89)'. Generated through expression: |