Query check CCI TISS Vented without mechanism: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 18: Line 18:


== Log ==
== Log ==
* 2021-02-10 - limited check to TISS entries with dts >= 2020-12-07
* 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
* 2021-01-28 - Implemented



Revision as of 16:15, 2021 February 10

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: always
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: true
  • Cargo


  • SMW


  • Categories: 
  • form:

Ventilated

Mechanism

Log

Related articles

Related articles: