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) mNo edit summary |
||
(3 intermediate revisions by the same user not shown) | |||
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 10: | Line 10: | ||
}} | }} | ||
This is | This is similar to [[query check_tmp_service_or_location_duplicate]]. | ||
== Log == | == Log == | ||
2021-08-04 - implemented | * 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 == |
Latest 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: |
|