Transfer Tracker.mdb

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.

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.

Transfer tracker now has a column indicating whether the patient had VAP in their TMP data at the location.

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)
• made query duplicateCleaner to clean it out, cleaned out, redeployed on server - Ttenbergen 11:06, 2013 September 16 (CDT)
• would be good to fix the query that imports to not add the duplicates. Might go away with centralized data so leaving for now. For now will just clean out occasionally Ttenbergen 11:21, 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. -- 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

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.Trish Ostryzniuk 15:32, 2013 April 8 (EDT)

• The scheduled task now runs off of Trish's computer.