Query check transfer ready tmp for each Boarding Loc: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) (Pam was right, the instructions had been clarified after discussion with Julie and Allan, and the query had not been updated yet.) |
||
Line 10: | Line 10: | ||
}} | }} | ||
The count of | The count of [[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. | |||
{{Discuss| | |||
{{Discuss| Does the above statement mean that for patients with several moves between medicine units (including ER) there could be several undated transfer ready entries with check boxes/comments but no dates/times? This seems prone to inadvertent entry errors? Could this be clarified? Thank you }} | * Does the above statement mean that for patients with several moves between medicine units (including ER) there could be several undated transfer ready entries with check boxes/comments but no dates/times? This seems prone to inadvertent entry errors? Could this be clarified? Thank you (Pam) | ||
** Yes, that's what it means. It's not ideal and we are discussing alternatives, but for now that's it. [[User:Ttenbergen|Ttenbergen]] 15:23, 2021 February 9 (CST)}} | |||
== Log == | == Log == |
Revision as of 16:23, 2021 February 9
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 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: |