Query s tmp Borrow duplicates: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check |DIC_summary=Checks that data for Project Borrow arrive follows that project's |DIC_related_concepts=Project Borrow arrive |DIC_firmness=hard check..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
|DIC_status= | |DIC_coding=query ''s_tmp_Borrow_duplicates'' | ||
|DIC_app=CCMDB. | |DIC_implementation_date=2019/01/24 | ||
|DIC_status=retired | |||
|DIC_LProblem=No | |||
|DIC_app=CCMDB.accdb | |||
}} | }} | ||
Retired 2019-09-24 as part of ending that project. | |||
== No duplicates == | == No duplicates == | ||
=== can't have two entries that | === can't have two different entries that have same (start_dt, start_tm)=== | ||
Can't have two | Can't have two different entries in item with same (start_dt, start_tm) per D_ID. | ||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:Tmp check]] | [[Category:Tmp check]] | ||
Latest revision as of 10:58, 2020 January 29
| 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 |
Retired 2019-09-24 as part of ending that project.
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: |