Notifications
Clear all
Topic starter
We are using Centricity EMR 9.8 (stand alone) and are curious how other users are getting data out of the system. We can use the inquiry function to get a list of patients that meet a certain set of criteria, but that's all it is - a list of patients. We'd like to be able to quantify the information as well as graph it, if possible. At one point in our Centricity history we had a program called OBS Loader that let you pull the data values of Observation Terms and export them to Excel, but that program stopped functioning at EMR 9.5. Any help or insight is appreciated. Thanks!
Posted : April 18, 2016 10:09 am
Your best bet is to download the data dictionary (you need two versions: the 2005 PDF explains the tables but isn't up to date; the current data dictionary is up to date but not as user friendly). Then get a book on SQL. The inquiry function is very basic -- anything beyond that requires SQL. Fortunately GE's database structure is not that hard to navigate and the documentation is good.
Posted : April 18, 2016 11:03 am
The single best interface to the data is via Crystal Reports. The learning curve is not that steep and there are lots of resources to help. The biggest hurdle is understanding the data structure. I agree with the above comments concerning the 2005 Data Dictionary, the graphic presentation of table relationships is a big help. The current Centricity Practice Solution 12.,0 data dictionary is complete but more difficult to navigate. A major advantage of Crystal is that you can import the reports directly into Centricity and run them from Chart Reports. I would present a course at CHUG if there were interest and have thought about doing this in the past. Crystal has incredible flexibility and I have not yet been presented with a data extraction request that couldn't be accomplished. For a small group, a WebEx might work. Contact me if you would like to pursue this, [email protected].
Posted : April 18, 2016 11:36 am
I agree with 'jfitzmd' that Crystal Reports is an excellent tool to pull data from Centricity. It will take a little time to get used to the major tables - Person, Document, Obs, Appt - but once you get those set it will be easy to add on next tables.
And the original 2005 document was so much better than the current for understanding the relationships. And the 2005 document pdf would probably be sufficient to get you started/
If you have specific issues, questions, then this board and the contributors should be able to assist. Or, you may want to see if you can arrange for some one-on-one training from a vendor or individual on the forum. If you have a specific requirement, sometimes working step-by-step through it will complete the request and show you a real-life approach to obtaining the data.
Good luck.
~Joe
Posted : April 20, 2016 4:08 am
