Query check transfer ready tmp for each Boarding Loc
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 |
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: |