Query check Transfer DtTm after paired BL and before later BL

From CCMDB Wiki
Revision as of 14:02, 2022 May 3 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc
Related: Transfer Ready DtTm tmp entry, Boarding Loc
Firmness: not entered
Timing: always
App: CCMDB.accdb
Coding: query check_pairs_transfer_DtTm_after_BoardingLoc
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date: 2022-05-03
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

This check runs at pre-send checker time and considers all records except deleted ones.


  • this should also check that the transfer ready dttm of a pair is not after the next boarding loc. There is no "next" in SQL, but it can be checked when we change it to "that the trdttm is not bigger than any boarding loc that's bigger than the paired one.
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Log

  • 2022-05-03 - implementing

Related articles

Related articles: