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
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = Check that there are no identical Boarding Locs or Services without a different one with a time stamp in between those two.  
|DIC_summary=Check that there are no identical Boarding Locs or Services without a different one with a time stamp in between those two.
| DIC_related_concepts = Boarding Loc; Service tmp entry
|DIC_related_concepts=Boarding Loc; Service tmp entry
| DIC_firmness = hard check
|DIC_firmness=hard check
| DIC_timing = always
|DIC_timing=always
| DIC_app = CCMDB.accdb
|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_status = ready to implement
|DIC_app=CCMDB.accdb
| DIC_implementation_date = date change was rolled out / first applied
|DIC_backlogged=No
}}
{{Discuss |  
* Lisa, would there be a concern if I implemented this? [[User:Ttenbergen|Ttenbergen]] 13:27, 2022 March 23 (CDT)
}}
}}



Revision as of 12:27, 23 March 2022

Data Integrity Checks
Summary: Check that there are no 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: needs review
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:
  • Lisa, would there be a concern if I implemented this? Ttenbergen 13:27, 2022 March 23 (CDT)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: