Query check transfer DtTm during admission: Difference between revisions

mNo edit summary
 
(4 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 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]]
| 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_firmness = hard
|DIC_timing=always
| DIC_timing = incomplete
|DIC_coding=query ''check_transfer_DtTm_during_admission''
| DIC_app = CCMDB.accdb
|DIC_implementation_date=2021-01-28
| DIC_coding = query ''check_transfer_DtTm_during_admission''
|DIC_status=implemented
| DIC_status = ready to implement
|DIC_app=CCMDB.accdb
| DIC_implementation_date = 2021-01-28
|DIC_backlogged=No
}}
}}
This check runs at pre-send checker time and considers all records except deleted ones.


== Log ==
== 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
* 2021-01-28 implemented