Query check CCI TISS Vented without mechanism

Data Integrity Checks
Summary:	Any marked TISS Item T18 - Invasive Mechanical Ventilation (TISS Item) has to have (T22 - ETT Present (TISS Item) or T23 - Trach Tube Present (TISS Item)) for the same date.
Related:	Invasive Mechanical Ventilation (TISS Item), ETT Present (TISS Item), Trach Tube Present (TISS Item)
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_CCI_TISS_Vented_without_mechanism
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-01-28
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

Ventilated

• T18 - Invasive Mechanical Ventilation (TISS Item)

Mechanism

• T22 - ETT Present (TISS Item)
• T23 - Trach Tube Present (TISS Item)

Log

• 2021-02-10 - limited check to TISS entries with dts >= 2020-12-07 (Change_to_collect_TISS_data_in_CCI_Picklist#Change_date) and only complete records; Julie asked for the vent status to be entered as part of Minimal Data Set, but the mechanism might not be available until full chart review later.
• 2021-01-28 - Implemented