Query check CCI TISS Vented without mechanism: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "TISS28 checks" to "TISS28 check")
 
Line 18: Line 18:


== Log ==
== Log ==
* 2021-09-22 - check runs when dx checkbox is checked, but also only checked for complete records, so would have almost never found something; updated check to run on incomplete records as well, but it will still only run when checkbox is checked, so essentially still checks only on completes...
* 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-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

Latest revision as of 16:48, 2021 September 22

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

Mechanism

Log

  • 2021-09-22 - check runs when dx checkbox is checked, but also only checked for complete records, so would have almost never found something; updated check to run on incomplete records as well, but it will still only run when checkbox is checked, so essentially still checks only on completes...
  • 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

Related articles

Related articles: