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 | | 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 = | ||
| DIC_app = CCMDB.mdb | | DIC_app = CCMDB.mdb | ||
| DIC_coding = Query s tmp QAInf dx no tmp | | DIC_coding = Query s tmp QAInf dx no tmp | ||
| DIC_status = | | DIC_status = ready to implement | ||
| DIC_implementation_date = 2009-12-29 | | DIC_implementation_date = 2009-12-29 | ||
}} | }} | ||
Line 17: | Line 17: | ||
* s_tmp_QAInf__dx | * s_tmp_QAInf__dx | ||
* s_tmp_QAInf__tmp | * s_tmp_QAInf__tmp | ||
== Related articles == | == Related articles == |
Revision as of 17:44, 2018 November 6
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