Query check CCI TISS Intubation vs Intubated

Data Integrity Checks
Summary:	Any marked TISS Item in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) must have the T22 - ETT Present (TISS Item) on the same date.
Related:	Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (TISS Item)
Firmness:	hard check
Timing:	always
App:	CCMDB.accdb
Coding:	query check_CCI_TISS_Intubation_vs_Intubated
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-01-28
Backlogged:	true

implemented check details

If any of #intubation or extubation is present on a day, then at least one of #ETT or ventilation also need to be marked for that day.

Julie had requested the following but there could be false positives; flagging for Task to decide if to defer or how to check.

if previous date has no T22 - ETT Present (TISS Item) and today date has T22 - ETT Present (TISS Item) then T40 - Insertion of ETT (TISS Item) should be marked
- not necessarily, could have been done in OR or elsewhere
if previous date has T22 - ETT Present (TISS Item) and today date has no T22 - ETT Present (TISS Item) then previous date of the T29 - Unplanned extubation (TISS Item) or T28 - Planned extubation (TISS Item) should be entered
- not necessarily, could have been done in OR or elsewhere
if previous date has T22 - ETT Present (TISS Item) and today date has T22 - ETT Present (TISS Item) and T40 - Insertion of ETT (TISS Item) are marked then today date of T29 - Unplanned extubation (TISS Item) or T28 - Planned extubation (TISS Item) should be marked
- not necessarily, could have been done in OR or elsewhere

T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item) can only be marked when both 1) T40 - Insertion of ETT (TISS Item) is marked on same day and 2) T22 - ETT Present (TISS Item) is marked in previous day.

the sequence is being intub yesterday and the next day extub then new insertion on same day.

T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item) can only be marked when both 1) T40 - Insertion of ETT (TISS Item) is marked on same day and 2) T22 - ETT Present (TISS Item) is not marked the next day.

	A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT) I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT) Actually, no: Someone can arrive intubated from another ICU and then be extubated their first day here. I don't see how Insertion can be included in these two. Ttenbergen 20:13, 2020 December 2 (CST) Julie and Tina discussed this, but Julie wonders how common these false positives would be. Are they rare enough to add at least a soft cross-check for this? Ttenbergen 16:22, 2021 September 2 (CDT) Discussed between Julie, Allan and Tina; Julie to provide numbers of how often there is potentially inconsistent data, and how often that data is correct and how often false since the beginning of PatientFollow Project. Ttenbergen 10:51, 2021 September 22 (CDT)	added: 2021-11-01 action: 2021-09-22

	discussed at Task, soft cross check is OK for this number of false positives. Tina to implement.	added: no added date action: no action date