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 deceased or transplant location
Related:	Brain death, Medical Assistance In Dying, Sudden cardiac death (and died), Dispo field, Deceased patients
Firmness:	hard check
Timing:
App:	CCMDB.mdb
Coding:	query check_ICD10_dx_implying_death_must_have_appropriate_dispo
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	2018-11-24
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 

• Categories:  

• form:

Started to build query but not applied yet; see discussion in Deceased patients.

• SMW

• Cargo

• Categories

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 - NOT organ donor"
• "Died - organ donor"

Diagnoses implying death

Diagnosis implying death codes:

Brain death Medical Assistance In Dying