Notifications
Clear all
Topic starter
Hello,
I'm running CPS 12.04 (SQL). GE tells me that it is not possible through them to archive data, but the technician did say he thought that some users had found a way to do this. Our database it 200G and I'll bet we only need about 45% of the records for the current active patients.
Does anyone have any experience with this?
Thanks for your help.
Kevin
Posted : December 22, 2014 5:52 am
I received this info from GE and found it to be very helpful:
Chapter 7 of the system planning guide gives instructions: Sorry the pdf is too large to send but can be found on (the GE portal)website and does have screen shots. This can be done to speed up loading of larger charts but CANNOT be done when users are in the system
CHAPTER 7
Using the ArchiveObs tool
ArchiveObs is a Centricity Chart tool you can use to improve performance
when accessing patient charts with large amounts of observation data. The
tool limits the amount of observation data pulled from the server to the client
when opening a patient chart.
“Archiving” in this context means that certain observations do not
automatically load as part of the chart load process. Although they may not
load with the chart, archived observations can be accessed at any time for
searching and reporting purposes.
How ArchiveObs tool works
ArchiveObs tool searches the database for patient charts with observations
exceeding the maximum you set (default is 3000 observations).
When the tool encounters a chart exceeding the limit, it reduces the number
of observations pulled across to the client (nLimit default is 1000), while
making sure that a critical percentage of each observation heading is
represented.
The tool calculates the percentage by dividing the nLimit parameter by the
total number of observations. For example, if a patient has 5000 total
observations and the nLimit = 1000, the percentage is 20 percent (1000/5000).
This means that 20 percent of the most recent observations for each
observation heading are kept, and 80 percent of the observations for each
heading are marked as archived.
By default, the archiving tool maintains a minimum of six observations for
each heading as part of the chart load. The tool does not archive any
unsigned observations.
Using ArchiveObs
The ArchiveObs tool is a stored procedure in the application database called
ARCHIVE_OBS. To run it with the default parameters, in SQL Server
Management Studio, connect to your database server, click New Query, and
run this command:
execute archive_obs;
How ArchiveObs tool works 137
Using ArchiveObs 137
Tool parameters 138
System Planning and Requirements for Centricity Practice Solution
138
There is no undo function; however, you can undo the archiving by running the
following:
update obs archive=null;
Tool parameters
Although the default tool parameters are adequate for most purposes, you
can change them as follows:
Example
In this example, the archive for each patient is triggered by 2000 observations
(instead of the default 3000), and the tool reduces the number of observations
loaded to 500.
execute archive_obs@nMaxOBS=>2000, @nLimit=>500;
Posted : December 22, 2014 6:51 am
Topic starter
thanks mjorrhch. Is it possible to see what the current settings are? Since I've upgraded from 9.0, 9.5, 10, to 12. I haven't applied the archiving tool, so I assume it has not been set.
Posted : December 24, 2014 5:27 pm
The obs archiving tool may speed up the loading of a chart, but does not remove any data or shrink the DB size. GE was not listening to our message of "just because you can keep information forever doesn't mean you should keep it," but I think our argument for patient privacy may have gotten through. If enough people put in enhancement requests with all of their reasons for purging data, maybe they'll include purging functionality.
Posted : January 2, 2015 10:07 am
The Archive_Obs tool just sets a flag field in the database to mark this observation as "do not load in to the patient's flowsheet". Just a chart speed up as Julie said. If there was a way to archive data it wouldn't be a good idea as you would have to be able to pull a patient's chart back in if there was a legal issue that came up and you needed records. With a patient's chart covering so many tables, it would be a really messy process to pull out the data and be able to bring it back in. That being said - GE MIGHT be able to move patients from one database to another if they were in a specific location of care. I know they can merge databases. But you would be talking $ and I don't know the licensing implications as well as maintaining two installs.
Posted : January 15, 2015 1:17 pm
Has anyone used the Archive Obs Tool and have a noticeable performance increase?
Posted : January 27, 2015 3:20 pm
David, you will agree that per Federal and State laws that a Healthcare entity is only liable for "X" number of years. While these laws may be outdated in this electronic age, they are still the laws.
I concur with Julie, there needs to be a way to purse the data for patients that are past the required years.
GE knows the relationship of all the tables, therefore they have the expertise to make this function available at NO COST.
Posted : January 31, 2015 8:35 pm
Is anyone currently using the ArchiveObs tool? We used to run it on a regular basis and for whatever reason we stopped. We actually put a "Do Not Use" n the title of the script. No one seems to remember why though. Recently we have had to run it on 3 charts so I was hoping to set it up as a nightly job.
Just curios though if anyone has run into any issues running it nightly?
Thanks
Laurie
Posted : November 10, 2015 3:12 am
