Query s tmp QAInf tmp no dx

Data Integrity Checks
Summary:	If "QAInf" entry is present in L_TmpV2 then program must be "CC" the corresponding diagnosis must exist
Related:	[[QA Infection, QA Infection CLI, QA Infection VAP]]
Firmness:	hard check
Timing:	always
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 (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) 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