Query s tmp QAInf LT 48 hrs after admit

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: DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank.
Related: QA Infection, QA Infection CLI, QA Infection VAP
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query s tmp QAInf LT 48 hrs after admit
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.

question=elsewhere we wrongly listed that we have a cross check that the date in tmp is checked/mandatory. This check currently doesn't test for mandatory date. Should it? The instructions in QA Infection CLI, QA Infection VAP make it look like it would be mandatory. Ttenbergen 10:35, 2018 September 25 (CDT)

 Since 48 hrs is part of the definition for VAP (i.e. in trach or ETT) and CLI (in ICU), this query maybe a helpful check. But I notice that in ICD10, we only required Date and not time, so the calculation of  exactly at least 48hrs after patient admission  will be hard to know without the time.  If we will use the dates only, then the cutoff must be 2 or more calendar days from admission date, does this make sense?  Onwards, the query must be done on the acquired ICD10 (since QAInf tmp will be dropped) but only for acquired VAP and CLI cases for now.  --JMojica 15:40, 2018 November 20 (CST)    

This query uses the following sub-queries:

  • s_tmp_QAInf__dx
  • s_tmp_QAInf__tmp

Related articles

Related articles: