Query check no consecutive same BL or Service: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 5: Line 5:
|DIC_timing=always
|DIC_timing=always
|DIC_coding=query check_no_consecutive_same_BL_or_Service
|DIC_coding=query check_no_consecutive_same_BL_or_Service
|DIC_status=needs review
|DIC_implementation_date=2022-12-01
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
 
== Log ==
{{Todo
* 2022-12-01 - implemented query
| who = Allan, Julie, Pagasa, Tina
| todo_added = 2022-04-21
| todo_action = 2022-04-21
| question = _dev_CCMDB
* Lisa, would there be a concern if I implemented this? [[User:Ttenbergen|Ttenbergen]] 13:27, 2022 March 23 (CDT)
**Should be fine, we'll hear about it if there are issues [[User:Lkaita|Lisa Kaita]] 12:50, 2022 April 13 (CDT)
}}
 


== Related articles ==
== Related articles ==

Latest revision as of 12:56, 2022 December 1

Data Integrity Checks
Summary: Check that there are no two identical Boarding Locs or Services without a different one with a time stamp in between those two.
Related: Boarding Loc, Service tmp entry
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_no_consecutive_same_BL_or_Service
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2022-12-01
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

Log

  • 2022-12-01 - implemented query

Related articles

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