Query check transfer DtTm during admission: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check | DIC_summary = Transfer Ready DtTm tmp entry should never be later than Dispo DtTm | DIC_related_concepts = Transfer Ready DtTm tmp entry; Disp..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = [[Transfer Ready DtTm tmp entry]] should never be 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 = | |DIC_coding=query ''check_transfer_DtTm_during_admission'' | ||
|DIC_implementation_date=2021-01-28 | |||
| DIC_coding = query '' | |DIC_status=implemented | ||
| DIC_status = | |DIC_app=CCMDB.accdb | ||
| | |DIC_backlogged=No | ||
}} | }} | ||
This check runs at pre-send checker time and considers all records except deleted ones. | |||
== Log == | |||
* 2022-06-29 - confirmed that this catches this problem; records with it still seem to show up in CFE, not sure how that's possible | |||
* 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 | |||
== Related articles == | == Related articles == |
Latest revision as of 10:40, 29 June 2022
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: | implemented |
Implementation Date: | 2021-01-28 |
Backlogged: | No |
This check runs at pre-send checker time and considers all records except deleted ones.
Log
- 2022-06-29 - confirmed that this catches this problem; records with it still seem to show up in CFE, not sure how that's possible
- 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
Related articles
Related articles: |