Query s tmp Borrow duplicates

From CCMDB Wiki
Revision as of 11:01, 2019 September 22 by Ttenbergen (talk | contribs) (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
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.accdb
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


  • 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: