Query check ICD10 dx implying death must have appropriate dispo

Data Integrity Checks
Summary:	If dx is (Brain death;Medical Assistance In Dying;Sudden cardiac death (and died)) then Dispo field must be one of the Deceased patients options
Related:	Brain death, Medical Assistance In Dying, Sudden cardiac death (and died), Dispo field, Deceased patients
Firmness:	hard check
Timing:
App:	CCMDB.accdb
Coding:	query check_ICD10_dx_implying_death_must_have_appropriate_dispo
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2020-01-28
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

Acceptable Dispo entries

Transplant Locations

Possible locations to which to transfer a deceased Organ donor (organ/tissue donation by the donor) are OR or ICU.

"Death" entries for Dispo

• "Died - to morgue"
• "Died - to OR"
• "Died - to other ICU"

Diagnoses implying death

ExpandDiagnosis implying death codes:

Brain death Medical Assistance In Dying

Log

2021-04-01 - updated to use the "died" entries we have been using for the last while - kind of surprised it took this long to rear its head... 2021-02-09 - fixed false positive for "Died - to morgue" 2020-01-28 - This was partly implemented 2018-11-24 but the check was not being triggered; set up the to trigger from dx checker and reg checker