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) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
== Log == | == Log == | ||
* 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-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]] | ||
Latest revision as of 16:29, 2023 February 8
| 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
- 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
Related articles
| Related articles: |