Query check Transfer DtTm after paired BL and before later BL
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 |
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: |