Query s tmp Borrow duplicates

From CCMDB Wiki
Revision as of 08:16, 2019 January 24 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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: query s_tmp_Borrow_duplicates
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2019/01/24
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:

No duplicates

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.

Related articles

Related articles: