Transfer Tracker.mdb: Difference between revisions

Line 1:

~~:: '''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.

~~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 at

You can find the transfer tracker.mdb 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.

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'''.

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.

**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 ==

Line 25:

Line 26:

* 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

==Crash notes==

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)

[[Category: IT Instructions]]

@@ Line 1: / Line 1: @@
-:: '''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.
-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 at
+You can find the transfer tracker.mdb 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.
+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'''.
-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.
+**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 ==
@@ Line 25: / Line 26: @@
 * 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
+==Crash notes==
+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)
 [[Category: IT Instructions]]