hcup_procedure_group_lookup
Information about the HCUP CCS groups for HCPCS codes. See https://hcup-us.ahrq.gov/toolssoftware/procedureicd10/procedure_icd10.jsp for more information.
Primary Key:Indexes:hcup_procedure_group_lookup_hcup_procedure_group_code_relea_idx-hcup_procedure_group_code,release_date
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
description | text | No | No | Description of the HCUP procedure group code. For example, 'Peripheral arterial bypass procedures' is the description for code 'CAR014'. Generated through expression: |
release_date | date | No | Yes | Release date of HCUP CCS groups for ICD procedure codes. Generated through expression: |
hcup_procedure_group_id | bigint | No | Yes | Snowflake ID for the HCUP procedure group. Generated through expression: |
hcup_procedure_group_code | smallint | No | Yes | HCUP procedure group code. For example, 'CAR014' is the group code for 'Peripheral arterial bypass procedures'. Generated through expression: |