Notifications
Clear all
Topic starter
How do I go about exporting lab results for specific set of patients?
We are currently on CPS 11. I am attempting to a sql query, but it is returning items such as BP and BMI. The export will need to be done 1-2 times a month.
We do have the Qvera/QIE. We currently export lab requests.
Thank you.
John Kingery
Outside In
Posted : February 28, 2014 2:40 am
Perhaps a little background would help? Why are you exporting, how do you want/need to deliver the data, what format should the data be in?
We have Crystal Report Writer here, and I use that to build reports (extract data) based on rules.
I think you would want to select OBS records from group 'Chemistry'. But, perhaps other groups also.
Posted : February 28, 2014 3:19 am
Topic starter
joeg1962 said:
Perhaps a little background would help? Why are you exporting, how do you want/need to deliver the data, what format should the data be in?
We have Crystal Report Writer here, and I use that to build reports (extract data) based on rules.
I think you would want to select OBS records from group 'Chemistry'. But, perhaps other groups also.
We are an FQHC with a relationship with a behavioral heatlh organization. That organization needs this information to import into their EHR Accentia and also into a SAMHSA reporting database. Right now exporting to an excel spreadsheet for now would work and send via secure e-mail. The ideal would be sending it in HL7 format.
I did use the group 'Chemistry' which appears to have worked. I will be doing more investigation to verify.
Thanks. John
Posted : February 28, 2014 3:42 am
