Query s tmp QAInf LT 48 hrs after admit
| Data Integrity Checks | |
| Summary: | DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank. |
| Related: | QA Infection, QA Infection CLI, QA Infection VAP |
| Firmness: | hard check |
| Timing: | |
| App: | CCMDB.mdb |
| Coding: | query s tmp QAInf LT 48 hrs after admit |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | 2009-12-29 |
| Backlogged: | true |
Approximate implementation date, this is the first mention in a change log so it was present before.
|
elsewhere we wrongly listed that we have a cross check that the date in tmp is checked/mandatory. This check currently doesn't test for mandatory date. Should it? The instructions in QA Infection CLI, QA Infection VAP make it look like it would be mandatory. Ttenbergen 10:35, 2018 September 25 (CDT) |
This query uses the following sub-queries:
- s_tmp_QAInf__dx
- s_tmp_QAInf__tmp
Related articles
| Related articles: |