Query s tmp Borrow duplicates: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| Line 8: | Line 8: | ||
|DIC_status=implemented | |DIC_status=implemented | ||
|DIC_LProblem=No | |DIC_LProblem=No | ||
|DIC_app=CCMDB. | |DIC_app=CCMDB.accdb | ||
}} | }} | ||
== No duplicates == | == No duplicates == | ||
Revision as of 11:01, 2019 September 22
| 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 |
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: |