Query s tmp check Boarding Loc and TransferReadyDtTm pairs

From CCMDB Wiki
Data Integrity Checks
Summary: Validates that combinations of Transfer Ready DtTm tmp entry and Boarding Loc with the same integer always appear as pairs as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc.
Related: Boarding Loc, Transfer Ready DtTm tmp entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query s_tmp_check_Boarding_Loc_and_TransferReadyDtTm_pairs
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-04-07
Backlogged: No
  • Cargo

  • SMW

  • Categories: 
  • form:


  • 2022-10-26 - query wasn't triggering right, fixed triggering on tmp box since this is not minimal dataset
  • 2021-04-07 - initial implementation

Related articles

Related articles: