Query s tmp QAInf tmp no dx: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) 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) | | 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 16:44, 6 November 2018
| Data Integrity Checks | |
| Summary: | If "QAInf" entry is present in L_TmpV2 then
|
| 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 |
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