Query check Transfer DtTm after paired BL and before later BL
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|
|Uses L Problem table:||not relevant for this app|
This check runs at pre-send checker time and considers all records except deleted ones.
- 2023-02-08 - updated so it will not allow transfer ready to be equal to next boarding loc start
- 2022-12-01 - wasn't linking to later ones correctly, fixed
- 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