Query check transfer ready tmp for each Boarding Loc: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (The updates to Transfer Ready DtTm tmp entry deal with any questions in here.) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 6: | Line 6: | ||
| DIC_app = CCMDB.accdb | | DIC_app = CCMDB.accdb | ||
| DIC_coding = query ''check_transfer_ready_tmp_for_each_Boarding_Loc'' | | DIC_coding = query ''check_transfer_ready_tmp_for_each_Boarding_Loc'' | ||
| DIC_status = | | DIC_status = implemented | ||
| DIC_implementation_date = | | DIC_implementation_date = 2021-02-04 | ||
}} | }} | ||
Line 15: | Line 15: | ||
== Log == | == Log == | ||
* 2021-02-04 - implemented after clarification of [[Transfer Ready DtTm tmp entry]] | |||
* 2021-01-28 - defined | * 2021-01-28 - defined | ||
Revision as of 15:38, 2021 February 4
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: | implemented |
Implementation Date: | 2021-02-04 |
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-02-04 - implemented after clarification of Transfer Ready DtTm tmp entry
- 2021-01-28 - defined
Related articles
Related articles: |