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.

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.

Bugs

Please let me know if there are problems or the program doesn't work as expected. Ttenbergen

Requested Changes

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)

adding admit date and time

• A collector has suggested adding Admit date and time to transfer trackerTrish Ostryzniuk 15:03, 2012 September 7 (CDT)
  • Technically relatively easy. For what purpose do we want this? Again, we are storing patient data here, and making it visible to all collectors, even those who never dealt with that patient, so I'd like to reduce it to what is needed for collection. Ttenbergen 10:03, 2012 September 10 (CDT)
  • I get patients who are transfered to other facilities and sometimes,especially with those going from HSC to STB I can't tell if they went directly to the OR or a surgical ward or to the cardiac care intensive care or to CCU and then the OR and then the cardiac care intensive care all in one day.Admission dates and times on the transfer tracker would clear this up for me.It would be much easier to check the transfer tracker than email and wait for response. (Gail Hall)
    • Template:DiscussionTrish, can you "OK" adding admit times to the transfer tracker? If so I'll make the change. Ttenbergen (talk) 17:39, 2012 September 18 (CDT)
      • Yes OKAY.........if it will help with use, please add.-Trish Ostryzniuk (talk) 18:32, 2012 September 18 (CDT)

self-updating directory listing

note for Tina only

use self-updating directory listing to import rather than a static list (this doesn't affect functionality while things work, it just makes the program a bit more resilient. Right now there is an error if any site can't be found, and if a new site is added and the hard-code is not amended the site just won't import) Ttenbergen 11:33, 1 March 2011 (CST)