QA Infection

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

• QA Infection CLI
• QA Infection VAP

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

Template:CCMDB Data Integrity Checks

• queries s_tmp_QA*

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.

Dx but no tmp

If Complication Diagnosis is one of:

• 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

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.