Query s tmp Borrow duplicates

Data Integrity Checks
Summary:	Checks that data for Project Borrow arrive follows that project's
Related:	Project Borrow arrive
Firmness:	hard check
Timing:	complete
App:	CCMDB.mdb
Coding:	not entered
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:	not entered
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 

• Categories:  

• form:

query s_tmp_Borrow_duplicates

No duplicates

can't have two entries that are exactly the same

Can't have two identical entries.

can't have two different entries that have same (start_dt, start_tm)

Can't have two different entries in item with same (start_dt, start_tm) per D_ID.