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

Referring Provider Report

General Discussion

Last Post by mvolkert 9 years ago

9 Posts

3 Users

0 Reactions

61 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

Does anyone know of a report or have a custom report that will list referring providers and how many patients they've referred in a given time frame. Thank you!

Posted : August 17, 2015 4:39 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Would a SQL script be useful? I have a stored procedure that we use for reporting on this, but I don't want to post a big script if it's not going to be of use to you.

Posted : August 17, 2015 5:44 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

I think that may come in handy. You can post it here if you'd like or email it to me directly. Thanks!

[email protected]

Posted : August 17, 2015 6:24 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

I apologize that this is almost completely lacking in comments. Let's see how far it gets you and then we can talk details from there.

cus_RPT_ReferralBreakdown

Posted : August 17, 2015 6:37 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

Thanks! I'll see if this will get me what I'm needing.

Posted : August 17, 2015 7:31 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

My IT guy ran the script and said it created a stored procedure and that when he ran that it didn't produce any data. Is there a piece/step we're missing. Thanks!

Posted : August 17, 2015 10:55 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Hmm. It would take some digging to see which piece of the script was causing the problem. There must be some key difference in our workflows. Assuming your orders must have an authorizing provider and a location of service, the only thing I can think of would be to try changing this line:

INNER JOIN SERVPROV s

...to this:

LEFT JOIN SERVPROV s

Apart from that I don't really have any thoughts on why it wouldn't be working. Sorry if I led you down the wrong path.

Posted : August 18, 2015 12:20 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

I could probably make you a crystal report in a few minutes, we do similar things to track our transition of care performance. Are you looking to track how many referral orders (and to what service providers) you send out by provider? Or are you looking at some sort of inbound workflow you may have developed?

Also are you CEMR?

Posted : August 18, 2015 5:39 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

Our scheduling department is wanting to see which providers and clinics our new patients are coming from in order to help with more targeted marketing. Thanks!

Posted : August 24, 2015 8:30 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