Query check tmp 2 BL TR S same tm

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: There can't be two Transfer Ready DtTm entries with the same date and time
Related: Transfer Ready DtTm
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: Query check_tmp_2_BL_TR_S_same_tm
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-08-04
Backlogged: No

  • Cargo

  • SMW

  • Categories: 

This is almost but not quite the same as query check_tmp_service_or_location_duplicate.


2021-08-05 - updated query check_tmp_2_BL_TR_S_same_tm to only list completes and incompletes (ie not deleteds).

2021-08-04 - implemented

Related articles

Related articles: