Query check transfer ready tmp for each Boarding Loc

From CCMDB Wiki
Revision as of 15:25, 2021 February 4 by Ttenbergen (talk | contribs) (The updates to Transfer Ready DtTm tmp entry deal with any questions in here.)
Jump to navigation Jump to search
Data Integrity Checks
Summary: There should be a Transfer Ready DtTm tmp entry for each Boarding Loc entry of a profile
Related: Transfer Ready DtTm tmp entry, Boarding Loc
Firmness: hard
Timing: complete
App: CCMDB.accdb
Coding: query check_transfer_ready_tmp_for_each_Boarding_Loc
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date:
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

The count of non-ER Boarding Loc should be the same as the count of Transfer Ready DtTm tmp entry.

A direct one-on-one match is not possible since there is nothing to identify the undated entries to a specific Boarding Loc, so an identical count will be used as an approximation.

Log

  • 2021-01-28 - defined

Related articles

Related articles: