Query check transfer DtTm during admission: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=[[Transfer Ready DtTm tmp entry]] should never be earlier than first [[Boarding Loc]] dttm or later than [[Dispo DtTm]] | |DIC_summary=[[Transfer Ready DtTm tmp entry]] should never be earlier than first [[Boarding Loc]] dttm or later than [[Dispo DtTm]] | ||
|DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field | |DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field; Boarding Loc | ||
|DIC_timing=always | |DIC_timing=always | ||
|DIC_coding=query ''check_transfer_DtTm_during_admission'' | |DIC_coding=query ''check_transfer_DtTm_during_admission'' | ||
Line 9: | Line 9: | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
. | |||
== Log == | == Log == | ||
* 2021-02-03 | * 2021-02-03 broke check into two, since we can check date in range always, but date present only when record is complete. | ||
* 2021-01-28 implemented | * 2021-01-28 implemented | ||
Revision as of 15:25, 2021 February 3
Data Integrity Checks | |
Summary: | Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm |
Related: | Transfer Ready DtTm tmp entry, Dispo DtTm field, Boarding Loc |
Firmness: | not entered |
Timing: | always |
App: | CCMDB.accdb |
Coding: | query check_transfer_DtTm_during_admission |
Uses L Problem table: | not relevant for this app |
Status: | needs review |
Implementation Date: | 2021-01-28 |
Backlogged: | No |
.
Log
- 2021-02-03 broke check into two, since we can check date in range always, but date present only when record is complete.
- 2021-01-28 implemented