Query TISS Errors vent vs vent2300: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 8: Line 8:
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
}}
}}
== Query1 -  Ventilation any time vs at 23 HR ==
== Query1 -  Ventilation any time vs at 23 HR ==
Any marked [[Invasive mechanical ventilation at 2300 hrs (TISS Item)]] has to have a corresponding marked [[Invasive Mechanical Ventilation (TISS Item)]] for the same date.
Any marked [[Invasive mechanical ventilation at 2300 hrs (TISS Item)]] has to have a corresponding marked [[Invasive Mechanical Ventilation (TISS Item)]] for the same date.


== Query2 - Ventilation any time vs ETT/Trach Tube present ==
 
Any marked [[Invasive Mechanical Ventilation (TISS Item)]] has to have a corresponding marked either in [[ETT Present (TISS Item)]] or [[Trach Tube Present (TISS Item)]] for the same date.


== Related articles ==
== Related articles ==

Revision as of 14:52, 6 January 2019

Data Integrity Checks
Summary: Any marked TISS Item Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked TISS Item Invasive Mechanical Ventilation (TISS Item) for the same date.
Related: Invasive Mechanical Ventilation (TISS Item), Invasive mechanical ventilation at 2300 hrs (TISS Item), ETT Present (TISS Item), Trach Tube Present (TISS Item)
Firmness: hard check
Timing: always
App: Centralized data front end.accdb
Coding: query TISS_Errors_Has_Tiss48_No_Tiss18
Uses L Problem table: not entered
Status: needs review
Implementation Date: 2018-10-25
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Query1 - Ventilation any time vs at 23 HR

Any marked Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked Invasive Mechanical Ventilation (TISS Item) for the same date.


Related articles

Related articles: