Query s tmp QAInf dx no tmp

Legacy Content

This page contains Legacy Content.

• Explanation: Check using old DX coding schema
• Successor: Query check cooling vs arrest

Click Expand to show legacy content.

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:	always
App:	CCMDB.accdb
Coding:	Query s_tmp_QAInf_dx_no_tmp
Uses L Problem table:	not relevant for this app
Status:	retired
Implementation Date:	2009-12-29
Backlogged:	true

• Cargo

• SMW

• 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

Log

2019-01-01: tweaked to only include CC, since Med can have VAPs if they develop after admission from ICU, but would not fill out this project 2018-12-24: changed from the following codes to the new ICD10 ones

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

Related articles