Query NDC VAP AcqDX but NoVAP DateinTMPV2: Difference between revisions

Revision as of 16:08, 31 October 2018

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.

	in ICD10 we will have Dx Date available; do we wan to change this check to include that?

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

	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.

@@ Line 8: / Line 8: @@
 }}
-Needs ICD10 added
+Despite the name this query doesn't check for the date entry, just for the presence of a line in tmp.
-{{Discuss | who = Tina | question = * Need to confirm what it actually does with the date. }}
+{{Discuss | who = Tina | question = * Needs ICD10 added, and likely be moved to [[CCMDB.mdb]]. }}
 {{Discuss | who = Julie | question = * in [[ICD10]] we will have [[Dx Date]] available; do we wan to change this check to include that? }}
 {{Discuss | who= Julie | question = 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...}}
+{{Discuss | who = Julie | question = * 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. }}
 == Related articles ==
 {{Related Articles}}