Query s tmp Borrow duplicates

From CCMDB Wiki
Revision as of 10:57, 2020 January 29 by Ttenbergen (talk | contribs) (project was retired, so retiring check as well)
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: retired
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: