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.
if we can't figure out more, at least each profile has to have one Transfer Ready DtTm tmp entry... |
|
nr of entries
AJTT
What if the pt ends up transferred to a higher level of care[edit] It might seem that a patient who was transfer ready but then moves to a higher level of care should be excluded, since they did not actually get transferred to a lower level of care. However, when the patient was deemed transfer ready, additional time in the ward was "wasted time" - if we could have sent them elsewhere we would have. If the patient later crashes, that doesn't make it not-wasted time - they could have crashed anywhere. So the interpretation that a pt moving to a higher level of care after transfer ready is not wasted time is not right. We discussed this repeatedly at task and steering meetings. The only way this makes sense is if it is done by intent. ' |
ER entries
AJTT
|
Log
- 2021-01-28 - defined
Related articles
Related articles: |