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

Crystal Report-Database Field Break Down

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

6 Posts

5 Users

0 Reactions

71 Views

RSS

acastillo

(@acastillo)

Posts: 45

Trusted Member

Topic starter

I am new to creating Crystal Reports and wanted to know if anyone has a guide or even a break down of the database fields? Any help would be greatly appreciated!

Thank you!

Posted : April 3, 2019 8:29 am

chicks

(@chicks)

Posts: 31

Eminent Member

You should be able to get a data dictionary from your VAR or Athena.

Posted : April 3, 2019 8:51 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

The data dictionary is the key. In addition to all field definitions, there is complete linkage information. However, there are some things that simply are not intuitively obvious. Get a good reference to Crystal, skim it to get a feel of where the information is, then start writing reports. Good luck.

Posted : April 3, 2019 10:57 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Here is a quick primer:

PERSON.PID is the primary table for all patients, and PID is the key to many other tables.

OBS.PID is the field for the flowsheet data (BP, lab results, etc...), again with PID

OBS.HDID is the key link to OBSHEAD.HDID, giving you the name of the fields

DOCUMENT.PID is the file for encounters (office visits, reports, letters).

PROBLEM.PID will be all the problems for a specific person

MEDICATION.PID will be all the meds for a person

Now, for each table, there are important fields to consider to know if the info is still active (like is the problem no longer an active problem, medication no longer active). And there are many related tables to provide more in-depth info.

Posted : April 4, 2019 12:18 am

acastillo

(@acastillo)

Posts: 45

Trusted Member

Topic starter

Thank you all very much for the input!

Posted : April 4, 2019 12:39 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

You should be able to get it from GE Healthcare Solutions site.....

https://digital.gehealthcare.com/s/

Once logged in, go to:

Documentation>>Centricity EMR>> CEMR Product & Services Information>>CEMR Product Documentation>>Select your C EMR Version. Downloadable zip file

Hope this helps!

Posted : April 4, 2019 2:35 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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