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, Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI),Pneumonia, ventilator-associated (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:	ready to implement
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. 

• 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