Created TransferReady query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
Created_TransferReady query provides Transfer Ready dates from [[Transfer Ready DtTm field]] or [[Transfer Ready DtTm tmp entry | Created_TransferReady query provides all possible Transfer Ready dates from [[Transfer Ready DtTm field]] or [[Transfer Ready DtTm tmp entry]]. | ||
It is used by [[Sub populate_created_transferDelay()]] to generate transfer delays in [[Created transferDelay table]]. | It is used by [[Sub populate_created_transferDelay()]] to generate transfer delays in [[Created transferDelay table]]. | ||
| Line 6: | Line 6: | ||
== Log == | == Log == | ||
* 2022-09-21 - changed the query to use ALL available transfer ready dttms from old and new, in a union query. This was decided because Julie pointed out that the two methods were used inconsistently during the [[PatientFollow Project]] transition, and because the way we use this to calculate delays will work even if there are additional dates, it just might over-estimate the wasted days. | |||
* 2022-06-28 - updated to use [[query created_PatientFollow]] to pull old [[Transfer Ready DtTm field]] until change to [[Transfer Ready DtTm tmp entry]] | * 2022-06-28 - updated to use [[query created_PatientFollow]] to pull old [[Transfer Ready DtTm field]] until change to [[Transfer Ready DtTm tmp entry]] | ||
Revision as of 17:11, 2022 September 21
Created_TransferReady query provides all possible Transfer Ready dates from Transfer Ready DtTm field or Transfer Ready DtTm tmp entry.
It is used by Sub populate_created_transferDelay() to generate transfer delays in Created transferDelay table.
The results are used for Transfer Delay (Critical Care) and Transfer Delay (Medicine).
Log
- 2022-09-21 - changed the query to use ALL available transfer ready dttms from old and new, in a union query. This was decided because Julie pointed out that the two methods were used inconsistently during the PatientFollow Project transition, and because the way we use this to calculate delays will work even if there are additional dates, it just might over-estimate the wasted days.
- 2022-06-28 - updated to use query created_PatientFollow to pull old Transfer Ready DtTm field until change to Transfer Ready DtTm tmp entry