Query check Transfer DtTm after paired BL and before later BL

From CCMDB Wiki
Revision as of 13:10, 2022 December 1 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_Transfer_DtTm_after_paired_BL_and_before_later_BL
Uses L Problem table: not relevant for this app
Status: implemented
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.

Log

  • 2022-10-13 - query had a D_ID specified that was left from testing it, which would have meant cases like this would have slipped through. Took out that D_ID. Also additional fixes.
  • 2022-05-03 - implementing; realized this replaces query s_tmp_check_combined_BL_and_TRDtTm_nonsequential

Related articles

Related articles: