Query check tmp service or location duplicate: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=[[Service tmp entry]]and [[Boarding_Loc]] entries must not have duplicate dates and services resp. locations and comments
|DIC_summary=[[Service tmp entry]] and [[Boarding_Loc]] entries must not have duplicate dates and services resp. locations and comments
|DIC_related_concepts=Service tmp entry; Boarding_Loc
|DIC_related_concepts=Service tmp entry; Boarding_Loc
|DIC_firmness=hard check
|DIC_firmness=hard check
Line 9: Line 9:
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
This is similar to [[query check_tmp_2_BL_TR_S_same_tm]].


== Log ==
== Log ==
* 2021-01-15 - check defined
* 2022-03-09 - confirmed that this will also catch when there are two different boarding loc entries with the same dttm
* 2021-09-02 - removed "item" from listing since we don't allow duplicates even if the item is different, and removed the exclusion of ER records from check
* 2021-05-04 - changed query to catch a scenario I had not thought of earlier
* 2021-01-15 - check implemented


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

Latest revision as of 10:23, 2022 March 9

Data Integrity Checks
Summary: Service tmp entry and Boarding_Loc entries must not have duplicate dates and services resp. locations and comments
Related: Service tmp entry, Boarding_Loc
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_tmp_service_or_location_duplicate
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-01-15
Backlogged: No
  • Cargo


  • SMW


  • Categories:  
  • form:

This is similar to query check_tmp_2_BL_TR_S_same_tm.

Log

  • 2022-03-09 - confirmed that this will also catch when there are two different boarding loc entries with the same dttm
  • 2021-09-02 - removed "item" from listing since we don't allow duplicates even if the item is different, and removed the exclusion of ER records from check
  • 2021-05-04 - changed query to catch a scenario I had not thought of earlier
  • 2021-01-15 - check implemented

Related articles

Related articles: