Query check transfer ready tmp for each Boarding Loc

From CCMDB Wiki
Revision as of 19:58, 2021 January 28 by Ttenbergen (talk | contribs)
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.

  • I implemented this query on Steph's computer, and none of the profiles have more than one Transfer Ready DtTm tmp entry. From how I read the article, there should be one per Boarding Loc - is that not how collectors are understanding this? Ttenbergen 18:58, 2021 January 28 (CST)
  • SMW


  • Cargo


  • Categories

Log

  • 2021-01-28 - defined

Related articles

Related articles: