Query check CCI TISS matching BoardingLoc time: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Data Integrity Check | DIC_summary = If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry | DIC_related_c..."
 
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 6: Line 6:
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check_CCI_TISS_matching_BoardingLoc_time''
| DIC_coding = query ''check_CCI_TISS_matching_BoardingLoc_time''
| DIC_status = ready to implement
| DIC_status = implemented
| DIC_implementation_date =  
| DIC_implementation_date = 2021-09-15
}}
}}
{{Todo
| who = Tina
| todo_added = 2021-09-01
| todo_action = 2021-09-02
| question = 
* implement
}}


== Log ==
== Log ==
* 2021-09-01 - check defined
* 2021-09-20 - to exclude deleted and sent records
* 2021-09-15 - implemented


== Related articles ==
== Related articles ==
Line 26: Line 19:
[[Category:CCI]]
[[Category:CCI]]
[[Category:CCI Px check‎]]
[[Category:CCI Px check‎]]
[[Category:TISS28 checks]]
[[Category:TISS28 check]]
[[Category:TISS28 timing checks]]

Latest revision as of 22:51, 17 February 2022

Data Integrity Checks
Summary: If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry
Related: CCI Picklist, Boarding Loc
Firmness: hard check
Timing: incomplete
App: CCMDB.accdb
Coding: query check_CCI_TISS_matching_BoardingLoc_time
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-09-15
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Log

  • 2021-09-20 - to exclude deleted and sent records
  • 2021-09-15 - implemented

Related articles

Related articles: