Query check CCI InExtubation consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,813 edits
No edit summary
superseded by other cross checks in CCMDB.accdn
 
(22 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Any marked TISS Item [[Insertion of ETT (TISS Item)]] or in  [[ETT Present (TISS Item)]] must have at least one marked TISS item either in [[Planned extubation (TISS Item)]] or in [[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=hard check
|DIC_firmness=soft check
|DIC_coding={{Discuss | who = all | question =  Pagasa, please put the names of the queries}}
|DIC_status=retired
|DIC_implementation_date=2018-10-25
|DIC_status=needs review
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
Any marked TISS Item [[Insertion of ETT (TISS Item)]] or in  [[ETT Present (TISS Item)]] must have at least one marked TISS item either in [[Planned extubation (TISS Item)]] or in [[Unplanned extubation (TISS Item)]]


== Query1  - Insertion of ETT and Extubation consistency ==
 
* A = Total the number of days  [[Insertion of ETT (TISS Item)]] are marked per patient
== Insertion of ETT and Extubation consistency ==
* B = Total the number of days  [[Planned extubation (TISS Item)]] and [[Unplanned extubation (TISS Item)]] are marked per patient
* A = Total the number of days  {{TISS w Nr | Insertion of ETT (TISS Item)}} are marked per patient
* B = Total the number of days  {{TISS w Nr | Planned extubation (TISS Item)}} and {{TISS w Nr | Unplanned extubation (TISS Item)}} are marked per patient
* The difference between A and B can be -1, 0, 1.  Other values will be questionable.
* The difference between A and B can be -1, 0, 1.  Other values will be questionable.


{{Discuss | who = Julie | question =  
=== Soft check ===
* this cross check would not know the difference between (on one day, intubated, extubated, and reintubated) vs (intubated and then extubated); while this hopefully not too common of a thing, would it cause false positives for Pagasa to run after? Ttenbergen 11:33, 2018 October 29 (CDT) }}
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.  
*yes that is correct because both have a difference of zero. Using the cut off >= |2| will get true negatives and not false positives.  This query considers only the counts and not the dates which will have numerous scenarios and too complicated to define. For those having a difference of -1,0,1 , there are also the possibility for incorrect sequence of dates of intubation or extubation  - this is not captured in the query.  If you have other suggestions, let us know.--[[User:JMojica|JMojica]] 12:19, 2018 October 29 (CDT)
 
== Query2  - ETT present and Extubation consistency ==
Any marked TISS Item in [[Planned extubation (TISS Item)]] or in [[Unplanned extubation (TISS Item)]] must have the [[ETT Present (TISS Item)]] on the same date.
 


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 ==
{{Related Articles}}
{{Related Articles}}

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_InExtubation_consistent&oldid=153262"