Query s tmp QAInf tmp no dx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 7: Line 7:
|DIC_coding=Query s tmp QAInf dx no tmp
|DIC_coding=Query s tmp QAInf dx no tmp
|DIC_implementation_date=2009-12-29
|DIC_implementation_date=2009-12-29
|DIC_status=needs review
|DIC_status=retired
|DIC_LProblem=No
|DIC_LProblem=No
|DIC_app=CCMDB.mdb
|DIC_app=CCMDB.mdb

Revision as of 19:00, 2019 January 16

Data Integrity Checks
Summary: If "QAInf" entry is present in L_TmpV2 then
  • program must be "CC"
  • the corresponding diagnosis must exist
Related: QA Infection, QA Infection CLI, QA Infection VAP, Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI), Pneumonia, ventilator-associated (VAP)
Firmness: hard check
Timing: always
App: CCMDB.mdb
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
"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 
  • Categories: 
  • form:

Implement ICD10/CCI part

There are questions in QA Infection CLI; QA Infection VAP that need to be answered before this can be implemented.

  • SMW


  • Cargo


  • Categories

There is currently discussion whether CCI should have a Central Line entry... delaying implementation in case it changes this.

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

Related articles

Related articles: