QA Infection

From CCMDB Wiki
Revision as of 15:55, 2017 April 18 by Ttenbergen (talk | contribs) (cat and TISS28 data)
Jump to navigation Jump to search

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

Tmp but no dx

If "QAInf" entry is present in L_TmpV2 then

  • program must be "CC"
  • the corresponding diagnosis must exist

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.

Relationship to TISS28

Central line counts, ETT counts and unplanned extubation will be on the TISS28. After a month or two of starting new TISS28, CRN's in ICU's in the Region will no longer have to fax in this information to the database office. Julie to advise how long she wants to have overlap and if dicussed with Jodi Waker Tweed. Trish Ostryzniuk 21:53, 2012 October 7 (CDT)Trish Ostryzniuk 19:47, 2012 December 10 (EST)