Notifications
Clear all
Topic starter
Hi All,
I am trying to create a report that would effectively display the activity log for a particular task and DTS. This report would need to include a distinguishing characteristic for the patient involved in that message (whether it is the patientID, the external ID or PID doesn't matter, I just need something). My struggle is there is no documentation (that I can find) regarding the L3 tables and how they link together or if pulling data out of the HL7 message itself is even possible. Does anyone know of documentation on these tables? The 9.5 guide I have for Crystal expressly states it won't cover the linklogic tables as they are "not used in reporting".
Basically why I am looking for this is we are working on an interface and we have some "missing" messages (messages we thought we exported but apparently never crossed to the other system). The biggest issue of all is it is about 3000 messages in an export over 100,000 (historical load) so manually finding them will not work and, some how, they did not create error events. I am hoping I can eliminate those that did cross from this report (via patient ID of some type) to pin point the missing so we can then determine why.
Thanks
Mike
Posted : July 2, 2014 12:11 am
There is a downloadable Data Dictionary that has all the l3 tables documented on GE's site. It unzips to a folder structure that is basically a web site.
It is on this page:
https://engage.gehealthcare.com/community/en/emr/documentation#emr95
Posted : July 2, 2014 8:12 am
Topic starter
Thank you very much, that was a big help. To this day I still have difficulty navigating the GE user support portal.
Posted : July 2, 2014 10:41 pm
I agree that it isn't the most well organized, user-friendly web site 🙂
Posted : July 2, 2014 11:22 pm
