QA Infection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 6: Line 6:


== {{CCMDB Data Integrity Checks|implemented}} ==
== {{CCMDB Data Integrity Checks|implemented}} ==
* queries ''s_tmp_QA*''
[[Tmp Checker]] will check for the following:  
[[Tmp Checker]] will check for the following:  


[[query s_tmp_QAInf_basic]] -  query was set up a million years ago but not called until [[CCMDB.mdb_Change_Log_2018#2018-09-25]].
* [[query s_tmp_QAInf_basic]]
 
* [[query s_tmp_QAInf_dx_no_tmp]]
=== Dx but no tmp ===
* [[query s_tmp_QAInf_tmp_no_dx]]
If '''Complication Diagnosis''' is one of:
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)
*[[VAP]] (code 39)
then
* L_TmpV2 entry with project "ICU Infection Audit" with date needed
 
[[query s_tmp_QAInf_dx_no_tmp]]
 
=== Tmp but no dx ===
If "QAInf" entry is present in [[L_TmpV2]] then
* program must be "CC"
* the '''corresponding''' diagnosis must exist
[[query s_tmp_QAInf_tmp_no_dx]]


=== DtTm has to be min 48hrs after admission ===
=== DtTm has to be min 48hrs after admission ===

Revision as of 10:24, 25 September 2018

This article has been split into the following two to clear up instructions:

Leaving info about the cross-checks here because they are done together.

Tmp Checker will check for the following:

DtTm has to be min 48hrs after admission

uses query s_tmp_QAInf_LT_48_hrs_after_admit DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank.