Query check Transfer DtTm after paired BL and before later BL: Difference between revisions

Revision as of 14:24, 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_Transfer_DtTm_after_paired_BL_and_before_later_BL
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.

@@ Line 11: / Line 11: @@
 This check runs at pre-send checker time and considers all records except deleted ones.
-{{TT |
-* this should also check that the transfer ready dttm of a pair is not after the next boarding loc. There is no "next" in SQL, but it can be checked when we change it to "that the trdttm is not bigger than any boarding loc that's bigger than the paired one.
-}}
 == Log ==
-* 2022-05-03 - implementing
+* 2022-05-03 - implementing; realized this replaces [[query s_tmp_check_combined_BL_and_TRDtTm_nonsequential]]
 == Related articles ==