Query Check BL TR combiner null

Data Integrity Checks
Summary:	Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer.
Related:	Transfer Ready DtTm tmp entry, Boarding Loc
Firmness:	hard check
Timing:	always
App:	CCMDB.accdb
Coding:	Query check_BL_TR_combiner_null
Uses L Problem table:	not relevant for this app
Status:	ready to program
Implementation Date:	not entered
Backlogged:	No

Checks that all Boarding Locs and Transfer Ready DtTm tmp entrys have non-null combiners. Query check transfer ready tmp for each Boarding Loc checks that they are paired, but it turns out a common null also satisfies that check, but would later cause problems with the data.

Log