Query check Transfer DtTm after paired BL and before later BL: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Log) |
Ttenbergen (talk | contribs) m (→Log) |
||
(One intermediate revision by the same user not shown) | |||
Line 5: | Line 5: | ||
|DIC_coding=query ''check_Transfer_DtTm_after_paired_BL_and_before_later_BL'' | |DIC_coding=query ''check_Transfer_DtTm_after_paired_BL_and_before_later_BL'' | ||
|DIC_implementation_date=2022-05-03 | |DIC_implementation_date=2022-05-03 | ||
|DIC_status= | |DIC_status=implemented | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
This check runs at pre-send checker time and considers all records except deleted ones. | This check runs at pre-send checker time and considers all records except deleted ones. | ||
== 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: |