Query check VAP admit must be from ICU

Data Integrity Checks
Summary:	VAP should only be Admit Diagnosis when Previous Location is an ICU.
Related:	Pneumonia, ventilator-associated (VAP), Previous Location, Admit Diagnosis
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	query check_VAP_admit_must_be_from_ICU
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	2018/11/24
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

The new definition of VAP has a possibility of this being collected on medicine wards: Pneumonia,_ventilator-associated_(VAP)#VAPs_on_medicine_wards. So we would need a different definition for this query. Checked instructions for medicine and had a question, which I posted to Allan. Ttenbergen 15:39, 2018 December 26 (CST)

• SMW

• Cargo

• Categories