Query check CCI TISS Vented without mechanism: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by the same user not shown)
Line 3: Line 3:
|DIC_related_concepts=Invasive Mechanical Ventilation (TISS Item); ETT Present (TISS Item); Trach Tube Present (TISS Item)
|DIC_related_concepts=Invasive Mechanical Ventilation (TISS Item); ETT Present (TISS Item); Trach Tube Present (TISS Item)
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_coding=query ''check_CCI_TISS_Vented_without_mechanism''
|DIC_coding=query ''check_CCI_TISS_Vented_without_mechanism''
|DIC_implementation_date=2021-01-28
|DIC_implementation_date=2021-01-28
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=Yes
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
== Ventilated ==
== Ventilated ==
* {{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}}
* {{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}}
Line 18: Line 18:


== Log ==
== Log ==
* 2021-01-28 - Implemented  
* 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 ==
Line 24: Line 26:


[[Category:Tracheostomy]]
[[Category:Tracheostomy]]
[[Category:TISS28 checks]]
[[Category:TISS28 check]]

Latest revision as of 16:48, 22 September 2021

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: