Query s tmp QAInf dx no tmp

From CCMDB Wiki
Jump to navigationJump to search

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Data Integrity Checks
Summary: If Complication Diagnosis is one of:

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: 

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


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

Related articles

Related articles: