Query check tmp 2 BL TR S same tm: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "{{Data Integrity Check |DIC_summary= There can't be two Transfer Ready DtTm entries with the same date and time |DIC_related_concepts=Transfer Ready DtTm |DIC_firmness=har...")
 
mNo edit summary
 
(7 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_service_2_Transfer_Ready_same_time''
|DIC_coding=Query ''check_tmp_2_BL_TR_S_same_tm''
|DIC_implementation_date=
|DIC_implementation_date=2021-08-04
|DIC_status=ready to implement
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
.
 
{{Todo
This is similar to [[query check_tmp_service_or_location_duplicate]].
| who = Tina
 
| todo_added = 2021-07-27
| todo_action = 2021-08-10
| question = Needs to be implemented; keep in mind that linking number could be different
}}
== 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-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
  • Cargo


  • SMW


  • Categories: 
  • form:

This is similar to query check_tmp_service_or_location_duplicate.

Log

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_tmp_2_BL_TR_S_same_tm&oldid=157105"