Query check tmp 2 BL TR S same tm
Jump to navigation
Jump to search
| 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 |
|
do we have a query where two consecutive date_times have the same boarding loc? When checking ER_delay, found 2 cases with 2 ER entries which when re-checked was typo error on the second location. --JMojica 13:44, 2024 October 24 (CDT) |
|
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