Query NDC dx implying death across encounters: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = [[:Category:Diagnosis implying death]] across encounters
|DIC_summary=[[:Category:Diagnosis implying death]] across encounters
| DIC_related_concepts ={{#ask: [[Category:Diagnosis implying death]]|format=list|link=none|limit=2000|sep=; }}; Organ donor (organ/tissue donation by the donor); Deceased patients
|DIC_related_concepts={{#ask: [[Category:Diagnosis implying death]]|format=plainlist|link=none|limit=2000|sep=; }}; Deceased patients
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing =  
|DIC_timing=always
| DIC_app = Centralized data front end.accdb
|DIC_coding=query NDC_dx_implying_death_across_encounters
| DIC_coding =
|DIC_implementation_date=2021-07-15
| DIC_status = needs review
|DIC_status=implemented
| DIC_implementation_date =  
|DIC_LProblem=yes
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
If a patient has one of the following codes during a stay on a unit/ward:
If a patient has one of the following codes during a stay on a unit/ward:
{{ListICD10Category | categoryName = Diagnosis implying death}}
{{ListICD10Category | categoryName = Diagnosis implying death}}
and that patient is subsequently admitted to another unit/ward then this is an error, unless the patient  
and that patient is subsequently admitted to another unit/ward then this is an error, unless the patient  
* has a dx [[Organ donor (organ/tissue donation by the donor)]]
* has a dx [[Brain death]]
* is going to an ICU
* is going to an ICU


{{DT | Need to update the definition for this and implement once we have [[Deceased patients]] figured out. I have left a link there to remember.  }}
== 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


== Related articles ==
== Related articles ==

Latest revision as of 09:33, 2023 June 28

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 NDC_dx_implying_death_across_encounters
Uses L Problem table: yes
Status: implemented
Implementation Date: 2021-07-15
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

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

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

Related articles

Related articles: