Query s tmp QAInf dx no tmp: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 9: Line 9:
| DIC_timing =
| DIC_timing =
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.mdb
| DIC_coding = Query s tmp QAInf dx no tmp
| DIC_coding = Query s_tmp_QAInf_dx_no_tmp
| DIC_status = needs review
| DIC_status = implemented
| DIC_implementation_date = 2009-12-29
| DIC_implementation_date = 2009-12-29
}}
}}
Line 19: Line 19:
* s_tmp_QAInf__dx
* s_tmp_QAInf__dx
* s_tmp_QAInf__tmp
* s_tmp_QAInf__tmp
{{DT | 1
Waiting to hear from Allan about the medicine rules for VAP. }}


== Log ==
== 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
2018-12-24: changed from the following codes to the new ICD10 ones
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)  
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)  

Revision as of 19:40, 1 January 2019

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:
App: CCMDB.mdb
Coding: Query s_tmp_QAInf_dx_no_tmp
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2009-12-29
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property.
  • 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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_QAInf_dx_no_tmp&oldid=132770"