Query s tmp QAInf dx no tmp: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
If '''Complication Diagnosis''' is one of:
{{LegacyContent
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)
|explanation=Check using old DX coding schema
*[[VAP]] (code 39)
|successor=[[Query check cooling vs arrest]]
then there has to be a
|content=
* L_TmpV2 entry with project "ICU Infection Audit" with date needed


{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = what is the check (one-liner)
|DIC_summary=If '''Complication Diagnosis''' is one of:
| DIC_related_concepts = list of related pages (probably the one it's on, but there might be others...)
*[[Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)]]
| DIC_firmness = hard check or soft check  
*[[Pneumonia, ventilator-associated (VAP)]]
| DIC_app = CCMDB.mdb
then there has to be a
| DIC_coding = how to find this in containing program, eg. SAS file, function name, query name...
* L_TmpV2 entry with project "ICU Infection Audit"
| DIC_status = needs review
|DIC_related_concepts=QA Infection; QA Infection CLI; QA Infection VAP
| DIC_implementation_date = 2009-12-29
|DIC_firmness=hard check
|DIC_coding=Query s_tmp_QAInf_dx_no_tmp
|DIC_implementation_date=2009-12-29
|DIC_status=retired
|DIC_LProblem=No
|DIC_app=CCMDB.accdb
}}
}}
Approximate implementation date, this is the first mention in a change log so it was present before.
Approximate implementation date, this is the first mention in a change log so it was present before.


Line 20: Line 23:
* s_tmp_QAInf__dx
* s_tmp_QAInf__dx
* s_tmp_QAInf__tmp
* 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
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)
*[[VAP]] (code 39)


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: Tmp check‎]]
}}

Latest revision as of 11:01, 2019 September 22

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

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

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=139667"