QA Infection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎{{CCMDB Data Integrity Checks|implemented}}: Template:CCMDB Data Integrity Checks change, replaced: {{CCMDB Data Integrity Checks}} → {{CCMDB Data Integrity Checks|implemented}})
Line 15: Line 15:
then  
then  
* L_TmpV2 entry with project "ICU Infection Audit" with date needed
* L_TmpV2 entry with project "ICU Infection Audit" with date needed
[[query s_tmp_QAInf_dx_no_tmp]]


=== Tmp but no dx ===
=== Tmp but no dx ===
Line 20: Line 22:
* program must be "CC"
* program must be "CC"
* the '''corresponding''' diagnosis must exist
* 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 ===
uses query ''s_tmp_QAInf_LT_48_hrs_after_admit''
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.
DtTm of QAInf entry has to be '''at least 48hrs after patient admission''' unless the inf_dttm is blank.



Revision as of 09:55, 2018 September 25

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.

Template:CCMDB Data Integrity Checks

  • queries s_tmp_QA*

Tmp Checker will check for the following:

Dx but no tmp

If Complication Diagnosis is one of:

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.