Query check Transfer DtTm after paired BL and before later BL: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_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]] | |DIC_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]] | ||
|DIC_related_concepts=Transfer Ready DtTm tmp entry | |DIC_related_concepts=Transfer Ready DtTm tmp entry; Boarding Loc | ||
|DIC_timing=always | |DIC_timing=always | ||
|DIC_coding=query ''check_pairs_transfer_DtTm_after_BoardingLoc'' | |DIC_coding=query ''check_pairs_transfer_DtTm_after_BoardingLoc'' |
Revision as of 14:02, 2022 May 3
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_pairs_transfer_DtTm_after_BoardingLoc |
Uses L Problem table: | not relevant for this app |
Status: | ready to implement |
Implementation Date: | 2022-05-03 |
Backlogged: | No |
This check runs at pre-send checker time and considers all records except deleted ones.
Log
- 2022-05-03 - implementing
Related articles
Related articles: |