Query s tmp QAInf tmp no dx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=Check using old DX coding schema
|successor=[[Query check cooling vs arrest]]
|content=
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=If "QAInf" entry is present in [[L_TmpV2]] then
|DIC_summary=If "QAInf" entry is present in [[L_TmpV2]] then
Line 7: Line 12:
|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.accdb
}}
}}
Implement ICD10/CCI part
Implement ICD10/CCI part
{{Discuss | who = Julie | question = There are questions in [[QA Infection CLI]]; [[QA Infection VAP]] that need to be answered before this can be implemented.}}


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.
Line 26: Line 30:
{{Related Articles}}
{{Related Articles}}


[[Category: Tmp check‎]]
}}
[[Category: ICD10 Dx check]]
[[Category: Old dx check‎]]

Latest revision as of 12:02, 2019 September 22

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

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.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:

Implement ICD10/CCI part

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_QAInf_tmp_no_dx&oldid=139729"