Query check transfer DtTm during admission: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Ttenbergen moved page Query check check transfer DtTm during admission to Query check transfer DtTm during admission) |
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]], and if the [[Transfer Ready DtTm tmp entry]] has no dttm its checbox has to be checked | |DIC_summary=[[Transfer Ready DtTm tmp entry]] should never be earlier than first [[Boarding Loc]] dttm or later than [[Dispo DtTm]], and if the [[Transfer Ready DtTm tmp entry]] has no dttm its checbox has to be checked | ||
| DIC_related_concepts = Transfer Ready DtTm tmp entry; Dispo DtTm field | |DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field | ||
|DIC_timing=always | |||
| DIC_timing = | |DIC_coding=query ''check_transfer_DtTm_during_admission'' | ||
|DIC_implementation_date=2021-01-28 | |||
| DIC_coding = query ''check_transfer_DtTm_during_admission'' | |DIC_status=needs review | ||
|DIC_app=CCMDB.accdb | |||
| DIC_implementation_date = 2021-01-28 | |DIC_backlogged=No | ||
}} | }} | ||
== Log == | == Log == | ||
* 2021-02-03 disabled check; | |||
{{TT | turns out just because someone has a [[Dispo DtTm]] doesn't mean we can assume they should have a proper [[Transfer Ready DtTm tmp entry]]; will need to reconsider what we can test when (always vs complete)}} | |||
* 2021-01-28 implemented | * 2021-01-28 implemented | ||
Revision as of 13:09, 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, and if the Transfer Ready DtTm tmp entry has no dttm its checbox has to be checked |
| Related: | Transfer Ready DtTm tmp entry, Dispo DtTm field |
| 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 disabled check;
|
turns out just because someone has a Dispo DtTm doesn't mean we can assume they should have a proper Transfer Ready DtTm tmp entry; will need to reconsider what we can test when (always vs complete) |
|
- 2021-01-28 implemented