Notifications
Clear all
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
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
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!
Posted : August 17, 2015 6:24 am
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.
Posted : August 17, 2015 6:37 am
Topic starter
Thanks! I'll see if this will get me what I'm needing.
Posted : August 17, 2015 7:31 am
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
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
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
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
