Query check Transfer DtTm after paired BL and before later BL: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) m (→Log) |
||
Line 12: | Line 12: | ||
== Log == | == Log == | ||
* 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-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]] | * 2022-05-03 - implementing; realized this replaces [[query s_tmp_check_combined_BL_and_TRDtTm_nonsequential]] |
Revision as of 13:40, 2022 December 1
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-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
Related articles
Related articles: |