Query check CCI InExtubation consistent: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 17: Line 17:
{{Discuss | who = Julie | question =  
{{Discuss | who = Julie | question =  
* 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 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) }}
*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 ==
== 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.
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.

Revision as of 12:19, 2018 October 29

Data Integrity Checks
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)
Related: Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding:

Pagasa, please put the names of the queries

  • SMW


  • Cargo


  • Categories
Uses L Problem table: not entered
Status: needs review
Implementation Date: 2018-10-25
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

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

  • 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)
  • SMW


  • Cargo


  • Categories
  • 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.--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.


Related articles

Related articles: