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	-
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	-