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

Revision as of 11:56, 1 December 2022

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:	not entered
Backlogged:	No

@@ Line 5: / Line 5: @@
 |DIC_timing=always
 |DIC_coding=query check_no_consecutive_same_BL_or_Service
-|DIC_status=needs review
+|DIC_status=implemented
 |DIC_app=CCMDB.accdb
 |DIC_backlogged=No
 }}
-{{Todo
+== Log ==
- | who = Allan, Julie, Pagasa, Tina
+* 2022-12-01 - implemented query
- | 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 ==