Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Data Extraction from Centricity EMR 9.8

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

89 Views

RSS

kgrasso

(@kgrasso)

Posts: 3

Active Member

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

StephenAdamsMD

(@stephenadamsmd)

Posts: 23

Eminent Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0