Query check CCI InExtubation consistent

Data Integrity Checks
Summary:	Any marked TISS Item Insertion of ETT (TISS Item) or in ETT Present (TISS Item) must have at least one marked TISS item either in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item)
Related:	[[Insertion of ETT (TISS Item), Planned extubation (TISS Item), Unplanned extubation (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 "Insertion of ETT (TISS Item)]], Planned extubation (TISS Item), [[Unplanned extubation (TISS Item)" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Any marked TISS Item Insertion of ETT (TISS Item) or in ETT Present (TISS Item) must have at least one marked TISS item either in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item)

Query1

• A = Total the number of days Insertion of ETT (TISS Item) are marked per patient
• B = Total the number of days Planned extubation (TISS Item) and Unplanned extubation (TISS Item) are marked per patient
• The difference between A and B can be -1, 0, 1. Other values will be questionable.

Query2

Any marked TISS Item in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item) must have the ETT Present (TISS Item) on the same date.