Query TISS Errors vent vs vent2300

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:	Pagasa, please put the names of the queries SMW Cargo Categories
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.

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.