Query s tmp Borrow duplicates: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→No duplicates: the fact that there can;t be duplicate start Dttms already implies that there can't be duplicate complete-twins, so taking that requirement out.) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 5: | Line 5: | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_coding=query ''s_tmp_Borrow_duplicates'' | |DIC_coding=query ''s_tmp_Borrow_duplicates'' | ||
|DIC_status= | |DIC_implementation_date=2019/01/24 | ||
|DIC_status=implemented | |||
|DIC_LProblem=No | |DIC_LProblem=No | ||
|DIC_app=CCMDB.mdb | |DIC_app=CCMDB.mdb | ||
}} | }} | ||
== No duplicates == | == No duplicates == | ||
=== can't have two different entries that have same (start_dt, start_tm)=== | === can't have two different entries that have same (start_dt, start_tm)=== |
Revision as of 09:16, 2019 January 24
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 |
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: |