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:	CCMDB.accdb
Coding:
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

_Dev_CCMDB This could be done in CCMDB instead now that we collect TISS there. Confirming with Lisa if she thinks this would be problematic.

added: 2021-07-15 action: 2021-07-22

• Cargo

• Categories

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