Query s tmp QAInf dx no tmp: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
If '''Complication Diagnosis''' is one of:  
{{Data Integrity Check
| DIC_summary = If '''Complication Diagnosis''' is one of:  
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)  
*[[Central Line Related Blood stream Infection (CLR-BSI) | Central line infection]] (code 86)  
*[[VAP]] (code 39)
*[[VAP]] (code 39)
then there has to be a
then there has to be a
* L_TmpV2 entry with project "ICU Infection Audit" with date needed
* L_TmpV2 entry with project "ICU Infection Audit" with date needed
{{Data Integrity Check
| DIC_summary = what is the check (one-liner)
| DIC_related_concepts = list of related pages (probably the one it's on, but there might be others...)
| DIC_related_concepts = list of related pages (probably the one it's on, but there might be others...)
| DIC_firmness = hard check or soft check  
| DIC_firmness = hard check or soft check  
Line 23: Line 21:
== ICD10 dxs ==
== ICD10 dxs ==
{{Discuss | who = Allan | question =  
{{Discuss | who = Allan | question =  
* what will be the ICd10 codes to use for this cross check? }}
* what will be the ICD10 codes to use for this cross check? }}


== Related articles ==
== Related articles ==

Revision as of 09:25, 25 September 2018

Data Integrity Checks
Summary: If Complication Diagnosis is one of:

then there has to be a

  • L_TmpV2 entry with project "ICU Infection Audit" with date needed
Related: list of related pages (probably the one it's on, but there might be others...)
Firmness: hard check or soft check
Timing: always
App: CCMDB.mdb
Coding: Query s tmp QAInf dx no tmp
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: 2009-12-29
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property.
  • Categories:  
  • form:

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

ICD10 dxs

  • what will be the ICD10 codes to use for this cross check?
  • SMW


  • Cargo


  • Categories

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_QAInf_dx_no_tmp&oldid=119916"