Query NDC VAP No AcqDX but VAP DateinTMPV2: Difference between revisions

Revision as of 16:05, 31 October 2018

Data Integrity Checks
Summary:	Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .
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 want 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...

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