Query NDC VAP AcqDX but NoVAP DateinTMPV2

Data Integrity Checks
Summary:	Checks that any record with an Acquired Diagnosis VAP has a QA Infection VAP entry with a date.
Related:	Pneumonia, ventilator-associated (VAP), Acquired Diagnosis / Complication, QA Infection VAP
Firmness:	hard check
Timing:	always
App:	Centralized data front end.accdb
Coding:	query NDC VAP AcqDX but NoVAP DateinTMPV2
Uses L Problem table:	not entered
Status:	needs review
Implementation Date:	not entered
Backlogged:	true

Despite the name this query doesn't check for the date entry, just for the presence of a line in tmp.

	Needs ICD10 added, and likely be moved to CCMDB.mdb.

	Was there a reason we didn't move this into ccmdb, or was that just a ball dropped? We'd need to review with ICD10 anyway... Same comment as in CLI. --JMojica 12:01, 2018 November 20 (CST)

	in ICD10 we will have Dx Date available; do we wan to change this check to include that? yes, include all. --JMojica 12:01, 2018 November 20 (CST)

	If a sputum culture is no longer a defining feature of VAP, then is collecting the date of one in QA Infection VAP really reasonable in the first place? If it is not then this check can go away. See discussion at QA Infection VAP, just flagging it here. the Tmp QAInf will stop when we collect Acquired dates - no need to enter in two places. --JMojica 12:01, 2018 November 20 (CST)

Related articles