Query check tmp 2 BL TR S same tm: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (updated page to reflect what the query actually does) |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary= There can't be two [[Transfer Ready DtTm]] entries with the same date and time | |DIC_summary= There can't be two [[Transfer Ready DtTm]] or two [[Boarding Loc]] or two [[Service tmp entry|Service tmp entries]] with the same date and time | ||
|DIC_related_concepts=Transfer Ready DtTm | |DIC_related_concepts=Transfer Ready DtTm, Boarding Loc, Service tmp entry | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=Query ''check_tmp_2_BL_TR_S_same_tm'' | |DIC_coding=Query ''check_tmp_2_BL_TR_S_same_tm'' | ||
| Line 13: | Line 13: | ||
== Log == | == Log == | ||
2021-08-05 - updated [[query check_tmp_2_BL_TR_S_same_tm]] to only list completes and incompletes (ie not deleteds). | * 2021-08-05 - updated [[query check_tmp_2_BL_TR_S_same_tm]] to only list completes and incompletes (ie not deleteds). | ||
* 2021-08-04 - implemented | |||
2021-08-04 - implemented | |||
== Related articles == | == Related articles == | ||
Revision as of 16:14, 2022 August 10
| Data Integrity Checks | |
| Summary: | There can't be two Transfer Ready DtTm or two Boarding Loc or two Service tmp entries with the same date and time |
| Related: | Transfer Ready DtTm, Boarding Loc, Service tmp entry |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | Query check_tmp_2_BL_TR_S_same_tm |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2021-08-04 |
| Backlogged: | No |
This is similar to query check_tmp_service_or_location_duplicate.
Log
- 2021-08-05 - updated query check_tmp_2_BL_TR_S_same_tm to only list completes and incompletes (ie not deleteds).
- 2021-08-04 - implemented
Related articles
| Related articles: |
|