Query s tmp QAInf dx no tmp: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m date is checked in Query s tmp QAInf LT 48 hrs after admit, not in this check. |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
(9 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 '''Complication Diagnosis''' is one of: | |DIC_summary=If '''Complication Diagnosis''' is one of: | ||
*[[ | *[[Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)]] | ||
*[[VAP]] | *[[Pneumonia, ventilator-associated (VAP)]] | ||
then there has to be a | then there has to be a | ||
* L_TmpV2 entry with project "ICU Infection Audit" | * L_TmpV2 entry with project "ICU Infection Audit" | ||
| DIC_related_concepts = | |DIC_related_concepts=QA Infection; QA Infection CLI; QA Infection VAP | ||
| DIC_firmness = hard check | |DIC_firmness=hard check | ||
|DIC_coding=Query s_tmp_QAInf_dx_no_tmp | |||
| DIC_coding = Query | |DIC_implementation_date=2009-12-29 | ||
|DIC_status=retired | |||
| DIC_implementation_date = 2009-12-29 | |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 19: | Line 24: | ||
* 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}} | ||
}} | |||
Latest revision as of 11:01, 2019 September 22
Legacy Content
This page contains Legacy Content.- Explanation: Check using old DX coding schema
- Successor: Query check cooling vs arrest
Click Expand to show legacy content.
Data Integrity Checks | |
Summary: | If Complication Diagnosis is one of:
then there has to be a
|
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 |
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
- Central line infection (code 86)
- VAP (code 39)
Related articles
Related articles: |