Query check tmp service or location duplicate

Data Integrity Checks
Summary:	Service tmp entry and Boarding_Loc entries must not have duplicate dates and services resp. locations and comments
Related:	Service tmp entry, Boarding_Loc
Firmness:	hard check
Timing:	always
App:	CCMDB.accdb
Coding:	query check_tmp_service_or_location_duplicate
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-01-15
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

This is similar to query check_tmp_2_BL_TR_S_same_tm.

we also need to check whether there is a duplicate dttm on DIFFERENT items; same query or better in a different one

added: 2021-09-02 action: 2021-09-02

• Cargo

• Categories

Log

• 2021-09-02 - removed "item" from listing since we don't allow duplicates even if the item is different, and removed the exclusion of ER records from check
• 2021-05-04 - changed query to catch a scenario I had not thought of earlier
• 2021-01-15 - check implemented