Wow, I could tell you put a lot of time and effort in this one. I appreciate you sharing it.
Tony Markovina
Hi Ron,
Would you mind sending me a copy alos.
Thanks I appreciate it.
Christine Bowser
Clinical Practice Applications Manager
Diagnostic Clinic
Hi Christine,
On it's way!
we create a reporting database from our EMR every night that users can use as read-only when the main EMR is down. we also use this database for reporting as to not slow down the main database during the day.
Linda,
Thank you for sending me the steps on Uploading a file...
Pretty cool, and relatively easy.
For anyone else that wants this report, here it is:
jjordet said:
we create a reporting database from our EMR every night that users can use as read-only when the main EMR is down. we also use this database for reporting as to not slow down the main database during the day.
Our group did this a few years ago after a lengthy outage, and it has paid for itself many times over.
rec1978 said:
Guys,
I have one, that I created for Centricity EMR 9.5...it should work for CPS, also.
I will send it to whomever would like it.
Thanks,
Ron
I was wondering if you could send me a copy as well. Thanks
Meagan Fornkahl, Asst EMR Coord
Cross Trails Medical Center
Meagan,
This link should take you to it: https://centricityusers.com/wp-conten.....mation.rpt
Thanks,
Ron
Thank you for sharing Ron.
Quick question for you, do you have this set up to run every evening? Thanks again for the information.
Yes, we do. I don't believe we run it on Saturday night/Sunday morning, but every other day...yes.
Does anyone have anything simliar for CPS 10? What has been posted only works for Oracle version of EMR.
rec1978 said:
Linda,
Thank you for sending me the steps on Uploading a file...
Pretty cool, and relatively easy.
For anyone else that wants this report, here it is:
I am getting error when I run this report in my demo CPS.
The table 'RELBUSS' could not be found.
Any idea?
This was only meant for oracle, not SQL. The RELBUSS table does not exist in CPS.
Does anyone have one that will work on Centricity 9.5, running SQL?