Query check tmp Transfer Ready not before Boarding Loc

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Validates that the DtTm for a Transfer_Ready_DtTm_tmp entry is not before its matching Boarding Loc entry
Related: Boarding Loc, Transfer_Ready_DtTm_tmp entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_tmp_Transfer_Ready_not_before_Boarding_Loc
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: 2021-08-04
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

This check is a subset of query check_transfer_DtTm_during_admission, and we don't need both, since both ran at pre-send checker time, and include all records except deleted ones. Retiring this check.

Log

  • 2021-10-05 - retiring check
  • 2021-08-06 - tweaked to only consider undeleted records.
  • 2021-08-04 - implemented

Related articles

Related articles: