|
|
| (10 intermediate revisions by 3 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.
| |
| | |
| It gets its content from the backup files.
| |
| | |
| Transfer tracker now has a column indicating whether the patient had VAP in their TMP data at the location.
| |
| | |
| You can find the transfer tracker.mdb at
| |
| :: [[Regional Server]]\Output\Transfer_Tracker.mdb
| |
| | |
| == VAP column ==
| |
| There is a column to the very right that lists whether a patient had a VAP as "yes" or blank.
| |
| | |
| ==Suggestions for added items to transfer tracker and how it who help==
| |
| {{discussion}}
| |
| Anything new?
| |
| | |
| It doesn't seem to be working correctly. I don't see the patients I'm looking for and there are no August admissions showing up after I have updated?[[User:GHall|GHall]] 08:08, 2016 August 11 (CDT)
| |
| | |
| === Including additional DXs===
| |
| Fundamentally possible, trying to find out how useful...
| |
| * I know there is a column for tmp VAP "yes" or "blank", but it might be helpful to have the dx, limit to top 4 admit and complications? [[User:Lkaita|Lisa Kaita]] 09:25, 2015 May 1 (CDT)
| |
| ** Please explain, how would that be helpful? Ttenbergen 15:21, 2015 July 16 (CDT){{discussion}}
| |
| | |
| === Including the pathogen for pneumonias ===
| |
| Fundamentally possible, trying to find out how useful...
| |
| * for pneumonia....pathogen if possible? although this should be on the EPR. This would make it easier for other collectors when coding future pneumonias ie. another VAP vs HAP [[User:Lkaita|Lisa Kaita]] 09:25, 2015 May 1 (CDT)
| |
| ** If we got rid of the VAP column and instead added text listing any pneumonias with pathogens, would that do the trick? Ttenbergen 13:05, 2015 June 25 (CDT){{discussion}}
| |
| | |
| == How data gets into Transfer Tracker ==
| |
| *Data is ''automatically'' updated from the laptop backup files on the Regional Server. This is done '''each night at 03:30 hrs'''.
| |
| **This auto-update is done by a scheduled task running on scanner PC in main office - the scheduled task must be run between 1 AM and 5 AM or the VBA must be adjusted.
| |
| *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.
| |
| ===Scheduled Task===
| |
| Is located in Main office on the '''SCANNER PC''' as of: March 12, 2015.
| |
| | |
| == Patient records missing from Transfer Tracker ==
| |
| {{Potential Change}}
| |
| *for various reasons, staff are not always doing news and backup onto the network BEFORE sending or after adding new profiles before they go home at the end of a shift. If new profiles are entered, completed, sent and deleted BEFORE a news and backup is done, then these profiles will not show up in transfer tracker. If new profiles are entering during the shift and you don' t do news and backup BEFOREyou go home, then the information needed by other staff via transfer tracker is not avaiable. Transfer tracker draws from backups that are done on network. Staff backup practice is not consistent, therefore transfer tracker is not always useful. Tina may have some thoughts on process change. [[User:TOstryzniuk|Trish Ostryzniuk]] 12:40, 2015 February 6 (CST)
| |
| | |
| == Purging data from Transfer Tracker ==
| |
| Need to put info from my task here Ttenbergen 13:05, 2015 June 25 (CDT)
| |
| | |
| == Are collectors using the transfer tracker? ==
| |
| {{Discussion}}
| |
| *We have had discussions about putting additional items in transfer tracker. ALL collectors, please indicate below if you use it or not. We don't want to spend time enhancing it if not use. Or, if enhancements added would it be used more?
| |
| | |
| ==Use it==
| |
| Polling staff on current use:{{Discussion}} - are you still using transfer tracker and what do you use it for? -[[User:TOstryzniuk|Trish Ostryzniuk]] 17:29, 2016 April 29 (CDT)
| |
| | |
| * I occasionally use it to co-ordinate transfer times. Judy K 2016, may 2.
| |
| * Gail Hall-I use it often, EPR times at the Concordia are frequently not accurate.
| |
| | |
| ==Do not use it==
| |
| | |
| | |
| == 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. -- [[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
| |
| | |
| == change log ==
| |
| === 2016-04-14 ===
| |
| * made password protection same as our other systems Ttenbergen 18:00, 2016 April 14 (CDT)
| |
| | |
| === 2015-07-15 ===
| |
| * changed the max date subform to re-fresh after the button is pressed
| |
| * confirmed that VAP is already part of the program
| |
| | |
| === 2015-04-30 ===
| |
| * confirmed that import script checks ''all directories in data directory'' except master and test_*, instead of explicit list Ttenbergen 09:56, 2015 April 30 (CDT)
| |
| | |
| *I only use it if the EPR doesn't have correct info.--[[User:Jpeterson|Jpeterson]] 11:01, 2016 May 2 (CDT)
| |
|
| |
|
| [[Category: IT Instructions]] | | [[Category: IT Instructions]] |
| [[Category: Data Backup Dependencies]]
| |
| [[Category: Scheduled Tasks]]
| |
| [[Category: Transfer Ready]]
| |
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.