|
|
| (56 intermediate revisions by 14 users not shown) |
| Line 1: |
Line 1: |
| Transfer_Tracker.mdb is a repository of patients currently under collection on our wards or discharged from collected ward within the last 7 weeks. The amount of time for which data is retained is limited since this is patient information and we can't keep it indefinitely without a good reason. | | Transfer_Tracker.mdb was a program to track patients across wards. Broke summer 2016, decided to abandon summer 2017. See article history for more information. |
| | |
| It is used by data collectors in the Regional to cross check transfer locations, discharge dates/times of clients between hospitals in the city.
| |
| | |
| You can find the transfer tracker.mdb at
| |
| :: [[Regional Server]]\Output\Transfer_Tracker.mdb
| |
| | |
| It gets its content from the backup files.
| |
| *Data is ''automatically'' updated from the laptop backup files on the Regional Server. This is done '''each night at 03:30 hrs'''.
| |
| **The batch file that does this automatically resides on a old computer on the desk of [[Tina Tenbergen]].
| |
| *You can also update transfer tracker.mdb ''manually'' to the most current data including today by pressing the ''update button'' and the top of the screen when you open this mdb. When you open the program, it displays the data that was in the most recent data backup from the last time someone has clicked the "update" button it, and the date of that update in the top left corner.
| |
| | |
| == Design decisions / Implementation log ==
| |
| === automatic deleting of records without discharge dates ===
| |
| * not working right now for records without discharge dates Ttenbergen 10:44, 2013 September 16 (CDT)
| |
| | |
| === self-updating directory listing ===
| |
| * 2012-09-27 changed update code to run for directories in .../data, not a hard coded list
| |
| | |
| === adding admit date and time ===
| |
| Added admit-from and admit date to the tool. -- [[User:Ttenbergen|Ttenbergen]] 11:10, 2012 September 20 (CDT)
| |
| | |
| === reducing amount of data retained ===
| |
| * Can we get away with retaining less than 7 weeks of discharges? [[User:Ttenbergen|Ttenbergen]] 10:03, 2012 September 10 (CDT)
| |
| ** discussed this at [[Team Meeting September 19, 2012]]; due to long vacations times without backup collectors need this amount of data to be able to catch up when they return. Will keep as is.-- [[User:Ttenbergen|Ttenbergen]] 11:07, 2012 September 20 (CDT)
| |
| | |
| === added not-yet-discharged patients and increased timeframe of available patients to 7 weeks ===
| |
| 16:06, 8 December 2011 (CST)
| |
| * listed patients who have not yet been discharged
| |
| * increased list of patients available to delete pts with discharge dates more than 7 weeks old to better accommodate vacations
| |
| | |
| == automatic update failure ==
| |
| April 4.13 - [[Marie Laporte]] noted tracker.mdb not being automatically updated. Tina found that program that automates this and resides on an old computer on her desk had crashed. Fixed April 8.13.[[User:TOstryzniuk|Trish Ostryzniuk]] 15:32, 2013 April 8 (EDT)
| |
| | |
| *The scheduled task now runs off of [[User:TOstryzniuk|Trish]]'s computer.
| |
|
| |
|
| [[Category: IT Instructions]] | | [[Category: IT Instructions]] |
| [[Category: Data Backup Dependencies]]
| |
| [[Category:Scheduled Tasks]]
| |
Transfer_Tracker.mdb was a program to track patients across wards. Broke summer 2016, decided to abandon summer 2017. See article history for more information.