Query s tmp QAInf dx no tmp

From CCMDB Wiki
Jump to navigation Jump 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:  
  • 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

Related articles

Related articles: