Query check CCI InExtubation consistent

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:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:
Uses L Problem table:	not entered
Status:	ready to implement
Implementation Date:	2018-10-25
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

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)

Query1 - Insertion of ETT and Extubation consistency

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

{{{1}}}

added: no added date action: no action date

• Cargo

• Categories