hcup_diagnosis_crosswalk
HCUP diagnosis crosswalk. See icd_diagnosis_hcup_group for the linkage between icd_diagnosis_id and hcup_diagnosis_group_id. (https://hcup-us.ahrq.gov/toolssoftware/ccsr/dxccsr.jsp)
Primary Key:Checks:hcup_diagnosis_crosswalk_inpatient_default_principal_check-(((is_acceptable_as_inpatient_principal IS FALSE) AND (is_inpatient_default IS FALSE)) OR (is_acceptable_as_inpatient_principal = true))hcup_diagnosis_crosswalk_outpatient_default_principal_check-(((is_acceptable_as_outpatient_principal IS FALSE) AND (is_outpatient_default IS FALSE)) OR (is_acceptable_as_outpatient_principal = true))
hcup_diagnosis_group_id=>hcup_diagnosis_group_lookup.hcup_diagnosis_group_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
diagnosis_code | text | No | Yes | ICD diagnosis code. Generated through expression: |
hcup_diagnosis_group_id | bigint | No | Yes | Link to the HCUP diagnosis group record. Generated through expression: |
is_inpatient_default | boolean | No | No | Is the diagnosis code inpatient. Generated through expression: |
is_acceptable_as_inpatient_principal | boolean | No | No | If true, this diagnosis_code is acceptable as the principal diagnosis for an inpatient claim. Generated through expression: |
is_outpatient_default | boolean | No | No | If true, this hcup_diagnosis_group_id is the default for this diagnosis_code for an outpatient claim. This is important since a single diagnosis_code may have more than one hcup_diagnosis_group_id. In reporting, when I want to only have a single HCUP group, the group with is_outpatient_default = true should be used on outpatient claims. Generated through expression: |
is_acceptable_as_outpatient_principal | boolean | No | No | If true, this diagnosis_code is acceptable as the principal diagnosis for an outpatient claim. Generated through expression: |
release_date | date | No | Yes | - Generated through expression: |