Query s tmp QAInf tmp no dx: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 3: Line 3:
* program must be "CC"
* program must be "CC"
* the '''corresponding''' diagnosis must exist
* the '''corresponding''' diagnosis must exist
| DIC_related_concepts = QA Infection; QA Infection CLI; QA Infection VAP, Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); Pneumonia, ventilator-associated (VAP)
| DIC_related_concepts = QA Infection; QA Infection CLI; QA Infection VAP; Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); Pneumonia, ventilator-associated (VAP)
| DIC_firmness = hard check
| DIC_firmness = hard check
| DIC_timing =
| DIC_timing =

Revision as of 17:44, 2018 November 6

Data Integrity Checks
Summary: If "QAInf" entry is present in L_TmpV2 then
  • program must be "CC"
  • the corresponding diagnosis must exist
Related: QA Infection, QA Infection CLI, QA Infection VAP, Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI), Pneumonia, ventilator-associated (VAP)
Firmness: hard check
Timing:
App: CCMDB.mdb
Coding: Query s tmp QAInf dx no tmp
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: 2009-12-29
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) 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

Related articles

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