Query check transfer DtTm during admission: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
mNo edit summary
 
(3 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_timing=always
|DIC_timing=always
|DIC_coding=query ''check_transfer_DtTm_during_admission''
|DIC_coding=query ''check_transfer_DtTm_during_admission''
|DIC_implementation_date=2021-01-28
|DIC_implementation_date=2021-01-28
|DIC_status=needs review
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
This check runs at pre-send checker time and considers all records except deleted ones.
== Log ==
== Log ==
* 2021-02-03 disabled check;
* 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
{{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-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


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
  • Cargo


  • SMW


  • Categories:  
  • form:

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_transfer_DtTm_during_admission&oldid=156703"