Notifications
Clear all
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
You should be able to get a data dictionary from your VAR or Athena.
Posted : April 3, 2019 8:51 am
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
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
Topic starter
Thank you all very much for the input!
Posted : April 4, 2019 12:39 am
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
