Query s tmp QAInf dx no tmp

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" with date needed

Data Integrity Checks
Summary:	what is the check (one-liner)
Related:	list of related pages (probably the one it's on, but there might be others...)
Firmness:	hard check or soft check
Timing:	always
App:	CCMDB.mdb
Coding:	how to find this in containing program, eg. SAS file, function name, query name...
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. 

• 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