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=ready to implement
|DIC_status=needs review
|DIC_LProblem=No
|DIC_LProblem=No
|DIC_app=CCMDB.mdb
|DIC_app=CCMDB.mdb
}}
}}
Implement ICD10/CCI part
Implement ICD10/CCI part
{{Discuss | who = Julie | question = * I think there was discussion elsewhere about no longer collecting the tmps QA_inf once we move to ICD10, so deferring for now. }}


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

Revision as of 18:25, 2018 November 24

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: needs review
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

  • I think there was discussion elsewhere about no longer collecting the tmps QA_inf once we move to ICD10, so deferring for now.
  • 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: