Query check CCI TISS Vented without mechanism: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Data Integrity Check |DIC_summary=Any marked TISS Item Invasive Mechanical Ventilation (TISS Item) has to have (ETT Present (TISS Item) or Trach Tube Present (TISS..."
 
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Any marked TISS Item [[Invasive Mechanical Ventilation (TISS Item)]] has to have ([[ETT Present (TISS Item)]] or [[Trach Tube Present (TISS Item)]]) for the same date.
|DIC_summary=Any marked TISS Item {{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}} has to have ({{TISS w Nr | ETT Present (TISS Item)}} or {{TISS w Nr | Trach Tube Present (TISS Item)}}) for the same date.
|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_coding=query ''TISS_Errors_Vent_vs_mechanism''
|DIC_timing=complete
|DIC_implementation_date=2019-01-06
|DIC_coding=query ''check_CCI_TISS_Vented_without_mechanism''
|DIC_status=needs review
|DIC_implementation_date=2021-01-28
|DIC_app=Centralized data front end.accdb
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
}}
}}
== Ventilated ==
* {{TISS w Nr | Invasive Mechanical Ventilation (TISS Item)}}


== Mechanism ==
* {{TISS w Nr | ETT Present (TISS Item)}}
* {{TISS w Nr | Trach Tube Present (TISS Item)}}


== 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 ==
{{Related Articles}}
{{Related Articles}}
[[Category:Tracheostomy]]
[[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: