Query check CCI InExtubation consistent

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

• A = Total the number of days Insertion of ETT (TISS Item) are marked per patient
• B = Total the number of days Planned extubation (TISS Item) and Unplanned extubation (TISS Item) are marked per patient
• The difference between A and B can be -1, 0, 1. Other values will be questionable.

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

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.