Transfer Tracker.mdb
- Transfer tracker now uses 24hr format. This comment can be deleted mid-december, by then all should have read it. Ttenbergen 19:12, 2012 December 5 (EST)
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.
You can find the transfer tracker at
- Regional Server\Output\Transfer_Tracker.mdb
It gets its content from the backup files. Data is updated from the backup files each night, and you can update it to the most current data including today by pressing the update button.
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
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. -- Ttenbergen 11:10, 2012 September 20 (CDT)
reducing amount of data retained
- Can we get away with retaining less than 7 weeks of discharges? 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.-- 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