icd_diagnosis_hcup_group

Links ICD Diagnosis code to the appropriate HCUP CCS Group. See https://hcup-us.ahrq.gov/toolssoftware/ccs10/ccs10.jsp for more information.

Primary Key:

• icd_diagnosis_id
• hcup_diagnosis_group_id

Checks:

• icd_diagnosis_hcup_group_inpatient_default_principal_check - (((is_acceptable_as_inpatient_principal IS FALSE) AND (is_inpatient_default IS FALSE)) OR (is_acceptable_as_inpatient_principal = true))
• icd_diagnosis_hcup_group_outpatient_default_principal_check - (((is_acceptable_as_outpatient_principal IS FALSE) AND (is_outpatient_default IS FALSE)) OR (is_acceptable_as_outpatient_principal = true))

Foreign Keys:

• hcup_diagnosis_group_id => hcup_diagnosis_group_lookup.hcup_diagnosis_group_id
• icd_diagnosis_id => icd_diagnosis_lookup.icd_diagnosis_id

Column	Data Type	Nullable	Indexed	Description
icd_diagnosis_id	bigint	No	Yes	Link to the ICD Diagnosis record. 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	If true, this hcup_diagnosis_group_id is the default for this diagnosis_code for an inpatient 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_inpatient_default = true should be used on inpatient claims. 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: