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:

• diagnosis_code
• release_date
• hcup_diagnosis_group_id

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

Foreign Keys:

• hcup_diagnosis_group_id => hcup_diagnosis_group_lookup.hcup_diagnosis_group_id

Indexes:

• hcup_diagnosis_crosswalk_hcup_diagnosis_group_id_idx - hcup_diagnosis_group_id

Column	Data Type	Nullable	Indexed	Description
diagnosis_code	text	No	Yes	ICD diagnosis code.
hcup_diagnosis_group_id	bigint	No	Yes	Link to the HCUP diagnosis group record.
is_inpatient_default	boolean	No	No	Is the diagnosis code inpatient.
is_acceptable_as_inpatient_principal	boolean	No	No	If true, this diagnosis_code is acceptable as the principal diagnosis for an inpatient claim.
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.
is_acceptable_as_outpatient_principal	boolean	No	No	If true, this diagnosis_code is acceptable as the principal diagnosis for an outpatient claim.
release_date	date	No	Yes	-