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:	Template:Discussion Pagasa, put the names of the queries
Uses L Problem table:	not entered
Status:	needs review
Implementation Date:	2018-10-25
Backlogged:	true

• Cargo

• SMW

 Property "DICRelatedConcepts" (as page type) with input value "Invasive Mechanical Ventilation (TISS Item)]],Invasive mechanical ventilation at 2300 hrs (TISS Item),ETT Present (TISS Item),[[Trach Tube Present (TISS Item)" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• 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.