Query check CCI InExtubation consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
superseded by other cross checks in CCMDB.accdn
 
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Any marked TISS Item {{TISS w Nr | Insertion of ETT (TISS Item)}} or in  {{TISS w Nr | ETT Present (TISS Item)}} must have at least one marked TISS item either in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}}
|DIC_summary=Any marked TISS Item {{TISS w Nr | Insertion of ETT (TISS Item)}} or in  {{TISS w Nr | ETT Present (TISS Item)}} must have at least one marked TISS item either in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}}
|DIC_related_concepts=Insertion of ETT (TISS Item); Planned extubation (TISS Item); Unplanned extubation (TISS Item)
|DIC_related_concepts=Insertion of ETT (TISS Item); Planned extubation (TISS Item); Unplanned extubation (TISS Item)
|DIC_firmness=soft check
|DIC_firmness=soft check
|DIC_coding=
|DIC_status=retired
|DIC_implementation_date=
|DIC_app=Centralized data front end.accdb
|DIC_status=ready to implement
|DIC_backlogged=No
|DIC_app=CCMDB.accdb
}}
}}


{{Todo
| who = Tina
| todo_added = 2021-07-15 
| todo_action = 2021-07-27
| question = _Dev_CCMDB
* This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic.
** Lisa couldn't think of problems with it either, so will implement like this to start and we can tweak if there are problems. [[User:Ttenbergen|Ttenbergen]] 09:52, 2021 July 27 (CDT)
}}


== Insertion of ETT and Extubation consistency ==
== Insertion of ETT and Extubation consistency ==

Latest revision as of 16:06, 8 December 2021

Data Integrity Checks
Summary: Any marked TISS Item T40 - Insertion of ETT (TISS Item) or in T22 - ETT Present (TISS Item) must have at least one marked TISS item either in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item)
Related: Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness: soft check
Timing: always
App: Centralized data front end.accdb
Coding: not entered
Uses L Problem table: not entered
Status: retired
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:


Insertion of ETT and Extubation consistency

Soft check

This will be implemented as a soft check because, due to the fact we only allow one entry per day for the CCIs, there are scenarios in which the difference would be more than 1.

Examples:

  • Pt arrives intubated. On day 1, they are extubated. On day 2 they are intubated, extubated and then intubated again on the same day, which will look on TISS as one insertion on that day and one removal. If you then had a removal the next day you will have an error because you have a count of 3 extubations with only 1 intubation.
  • We don’t always extubate for those that are ill and have cardiac arrest and die, we often leave the ETT in

Related articles

Related articles: