Query check transfer ready tmp for each Boarding Loc: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
Line 11: | Line 11: | ||
The count of non-ER [[Boarding Loc]] should be the same as the count of [[Transfer Ready DtTm tmp entry]]. | The count of non-ER [[Boarding Loc]] should be the same as the count of [[Transfer Ready DtTm tmp entry]]. | ||
{{Discuss| The above statement could be interpreted that a Transfer Ready DtTm is not collected for the ER boarding location and needs further clarification. ie. Is this consistent with the collection instruction from the [[Transfer Ready DtTm tmp entry]] article that states: ''For each Boarding Loc entry (incl the original ER one, if present), enter the following:'' }} | |||
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. | 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. |
Revision as of 08:36, 2021 February 5
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.
The above statement could be interpreted that a Transfer Ready DtTm is not collected for the ER boarding location and needs further clarification. ie. Is this consistent with the collection instruction from the Transfer Ready DtTm tmp entry article that states: For each Boarding Loc entry (incl the original ER one, if present), enter the following: |
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: |