Query s tmp check combined Boarding Loc and TransferReadyDtTm

Data Integrity Checks
Summary:	Validates that there are no unmatched Transfer Ready DtTm tmp entry and Boarding Loc as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc.
Related:	Boarding Loc, Transfer Ready DtTm tmp entry
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-03-31
Backlogged:	No

	This doesn't catch duplicate Transfer Ready DtTm tmp entry for Boarding Loc on incompletes. That is probably fine since we don't use the incompletes, but it could be added the next time the check is worked on anyway.

Log

2021-03-31 implemented

2021-04-07 - changed query to also accept a null as match; for profiles where there is more than one pair, query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs will flag those.
2021-04-01 - initial implementation had mistake and lots of false-positives, fixed
2021-03-31 - initial implementation