Query s tmp QAInf dx no tmp

Data Integrity Checks
Summary:	If Complication Diagnosis is one of: Central line infection (code 86) VAP (code 39) then there has to be a L_TmpV2 entry with project "ICU Infection Audit"
Related:	[[QA Infection, QA Infection CLI, QA Infection VAP]]
Firmness:	hard check
Timing:
App:	CCMDB.mdb
Coding:	Query s tmp QAInf dx no tmp
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	2009-12-29
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. Property "DICRelatedConcepts" (as page type) with input value "QA Infection]], QA Infection CLI, [[QA Infection VAP" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

Approximate implementation date, this is the first mention in a change log so it was present before.

This query uses the following sub-queries:

• s_tmp_QAInf__dx
• s_tmp_QAInf__tmp

ICD10 dxs

what will be the ICD10 codes to use for this cross check?

• SMW

• Cargo

• Categories