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

Clinical Kit Referring Providers

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

9 Posts

4 Users

0 Reactions

119 Views

RSS

acastillo

(@acastillo)

Posts: 45

Trusted Member

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

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

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

acastillo

(@acastillo)

Posts: 45

Trusted Member

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

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

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

acastillo

(@acastillo)

Posts: 45

Trusted Member

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

aroberts

(@aroberts)

Posts: 176

Reputable Member

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

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

Those fields are listed in the BUSINESS table. Link SERVPROV to BUSINESS on BUSID.

Posted : January 20, 2020 1:49 am

jpeterson

(@jpeterson)

Posts: 2

New Member

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

acastillo

(@acastillo)

Posts: 45

Trusted Member

Topic starter

Thank you all! I was able to complete this report!

Posted : January 21, 2020 3:03 am

Share:

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