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: | 2021-02-04 |
Backlogged: | true |
The count of Boarding Loc should be the same as the count of Transfer Ready DtTm tmp entry. This means there could be several undated transfer ready entries with check boxes/comments but no dates/times.
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.
Once query check_transfer_ready_tmp_one_per_Boarding_Loc is implemented, this one can go away since it checks a subset of that. |
|
Log
- 2021-02-04 - implemented after clarification of Transfer Ready DtTm tmp entry
- 2021-01-28 - defined
Related articles
Related articles: |