Query s tmp QAInf dx no tmp

Data Integrity Checks
Summary:	If Complication Diagnosis is one of: Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) Pneumonia, ventilator-associated (VAP) 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:	implemented
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

Legacy Content

This page contains Legacy Content.

• Explanation: Pre-ICD10 dx codes
• Successor: No successor was entered

Click Expand to show legacy content.

Pre ICD10 dxs

2018-12-24: changed from the following codes to the new ICD10 ones

• Central line infection (code 86)
• VAP (code 39)

Related articles