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:	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

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

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