Query NDC dx implying death across encounters
| Data Integrity Checks | |
| Summary: | Category:Diagnosis implying death across encounters |
| Related: | Brain death, Medical Assistance In Dying, Sudden cardiac death (and died), Deceased patients |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query NCD_dx_implying_death_across_encounters |
| Uses L Problem table: | yes |
| Status: | implemented |
| Implementation Date: | 2021-07-15 |
| Backlogged: | No |
If a patient has one of the following codes during a stay on a unit/ward:
| Diagnosis implying death codes: |
and that patient is subsequently admitted to another unit/ward then this is an error, unless the patient
- has a dx Brain death
- is going to an ICU
Log
- 2023-06-28 - fixed problem with first service date and time that would have left this query broken since we changed that months ago
- 2021-07-15 - implemented