Notifications
Clear all
Topic starter
Hello All,
I would like to know if there is a way to export the service providers (referring) that are in the EMR. I look in clinical kit export and did not see anything that would produce this export. Any suggestions?
Thank you in advance!
Posted : January 16, 2020 8:00 am
Not sure what your end use is, but a Crystal Report could be used to get a report of all service providers listed in your EMR directory. I think I have one if needed.
Posted : January 16, 2020 8:05 am
Topic starter
Ok, we are moving to EPIC. I was hoping there was a clinical kit :[ crystal reports are not my friend.
Posted : January 16, 2020 8:08 am
I doubt that the Centricity .ckt would be useful in EPIC anyway. A Crystal Report could be used to create a flat file that could then be imported into EPIC (probably). You would need to identify the format that EPIC requires first and then build the report to meet that specification.
Posted : January 16, 2020 8:13 am
Topic starter
I only need a list of the provider's name and contact information. I can pull the Last/First name and Specialty in the report but I hit a wall. Any suggestions on tables to pull in the address and phone numbers?
Posted : January 16, 2020 9:13 am
Not sure if you have access to SQL but I would do it this way in SQL it it were me:
select distinct p.provlastname, p.provfirstname, p.keyword, p.specialty, o.Name, o.ListName, o.Address1, o.Address2, o.City, o.State, o.Zip, o.Phone1, o.Phone3
FROM [centricityps].[dbo].[SERVPROV] p, [centricityps].[dbo].[SERVPROVORG] o
where p.BUSID = o.SERVPROVORGID
Then copy with headers and clean the file to be imported into Epic. Good luck with your transition!
Posted : January 17, 2020 12:18 am
Those fields are listed in the BUSINESS table. Link SERVPROV to BUSINESS on BUSID.
Posted : January 20, 2020 1:49 am
For Data Conversions to another EHR SQL Crystal Reports which you can then export to Excel, or direct Queries via SQL will be your best bet.
Some users may have a Crystal Report already packaged up in a .ckt (which could then appear in the Chart Reports area), some groups may have a SQL Query they run directly, and some groups may have a .bin file that can be imported into Reports (PM Side) and exported.
My personal method would be a report via SQL if it's a one time thing, as that's the path of least resistance. I tend to only go through the trouble of creating a .ckt or .bin if it's a report that a customer will need to self service on a regular basis.
The SQL posted by aroberts above should do what you need.
Posted : January 21, 2020 12:48 am
Topic starter
Thank you all! I was able to complete this report!
Posted : January 21, 2020 3:03 am
