hcup_diagnosis_group_lookup
Information about the HCUP CCS groups for diagnosis codes. See https://hcup-us.ahrq.gov/toolssoftware/ccs10/ccs10.jsp for more information.
Primary Key:Indexes:hcup_diagnosis_group_lookup_hcup_diagnosis_group_code_relea_idx(Unique) -hcup_diagnosis_group_code,release_date
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
description | text | No | No | Description of HCUP diagnosis CCSR group. For example the description for 'BLD001' is 'Nutritional anemia'. Generated through expression: |
release_date | date | No | Yes | Release date of HCUP diagnosis group. Generated through expression: |
hcup_diagnosis_group_id | bigint | No | Yes | Snowflake ID for HCUP diagnosis group. Generated through expression: |
hcup_diagnosis_group_code | text | No | Yes | HCUP diagnosis CCSR group code. Generated through expression: |