hcup_diagnosis_crosswalk
HCUP diagnosis crosswalk. See icd_diagnosis_hcup_group for the linkage between icd_diagnosis_id and hcup_diagnosis_group_id.
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 | - |
hcup_diagnosis_group_id | bigint | No | Yes | - |
is_inpatient_default | boolean | No | No | - |
is_acceptable_as_inpatient_principal | boolean | No | No | - |
is_outpatient_default | boolean | No | No | - |
is_acceptable_as_outpatient_principal | boolean | No | No | - |