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

Prescribing Method Report

Trading Post

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

122 Views

RSS

Teresa

(@teresa)

Posts: 27

Eminent Member

Topic starter

CPS 10

I have a few doctors that are failing the MU eRx measure, although they tell me that they are sending all eligible prescriptions via eRx. I would like to run a report by provider & date range that would show me all the prescriptions generated by said provider and return the prescribing method...ie: Print, Fax, Telephone, & Electronic. Does anyone have a report similar to this to share?

Posted : July 17, 2012 7:45 am

kwolfe

(@kwolfe)

Posts: 63

Trusted Member

I use a SQL query like this, haven't gone as far as making a report.

Something I noticed... the MU eRx report uses the medication's class code from Centricity's database to determine if it is a controlled substance. The MU measure states the determination should be based on the guidelines for prescribing Schedule II-V substances in effect on or before Jan 13, 2010 - I don't know how current Centricity is and it also does not include local restrictions. In our area pharmacies deny electronic prescriptions for some drugs (Tramadol) even though they are not restricted nationally. So our MU eRx denominator includes prescriptions that were really impossible for us to send electronically. I don't know how to deal with this yet but fortunately our percentage is high enough to pass now.

SELECT DISTINCT u.LASTNAME as 'Authorized by', u2.LASTNAME as 'Signed by', PatientProfile.PatientId, PatientProfile.Last, PatientProfile.First, PRESCRIB.CLINICALDATE,
MEDICATE.DESCRIPTION as MEDICATION,
      case PRESCRIB.RXTYPE
        when 'W' then 'Handwritten'
        when 'H' then 'Historical'
        when 'F' then 'Fax to pharmacy'
        when 'A' then 'Re-fax'
        when 'D' then 'Pharmacy'
        when 'Q' then 'Print and fax to pharmacy'
        when 'P' then 'Print'
        when 'R' then 'Reprint'
        when 'M' then 'Mail to patient'
        when 'L' then 'Mail to pharmacy'
        when 'S' then 'Samples given'
        when 'T' then 'Telephone'
        when 'E' then 'Electronic'
        end as 'Method',
      ISNULL(MEDINFO.CLASSCODE,'') As 'Class'

FROM MEDICATE
INNER JOIN PRESCRIB ON MEDICATE.MID=PRESCRIB.MID
INNER JOIN PatientProfile ON PRESCRIB.PID=PatientProfile.PId
INNER JOIN USR u ON PRESCRIB.PVID=u.PVID
INNER JOIN USR u2 ON PRESCRIB.PUBUSER=u2.PVID
INNER JOIN MEDINFO ON MEDICATE.DDID=MEDINFO.DDID

WHERE (PRESCRIB.CHANGE = 1 OR PRESCRIB.CHANGE = 2.0)
AND (MEDICATE.DDID IS NOT NULL) and MEDICATE.DDID <> 0
AND (MEDICATE.KDC IS NOT NULL) and MEDICATE.KDC > 0
AND MEDINFO.LEGEND <> 'O'

AND u.LASTNAME = 'Kachar DO'
AND (PRESCRIB.CLINICALDATE >= '02/01/2012' AND PRESCRIB.CLINICALDATE < '03/02/2012')

ORDER BY u.LASTNAME, Class, Method

Posted : July 17, 2012 9:15 am

Teresa

(@teresa)

Posts: 27

Eminent Member

Topic starter

Hey, thanks for sharing....

We ran this script but it returned zero results. Is there something that needs to be adjusted? We changed the date range. I now see the field u.LASTNAME = 'Kachar DO', could this be the issue? If so, will we replace the name with one of our own providers? Then change this field again and run this script for every provider thereafter?

AND u.LASTNAME = 'Kachar DO'
AND (PRESCRIB.CLINICALDATE >= '02/01/2012' AND PRESCRIB.CLINICALDATE < '03/02/2012')

Posted : July 23, 2012 3:40 am

kwolfe

(@kwolfe)

Posts: 63

Trusted Member

Yes, or you may remove that line to have all providers come up.

Also the MU report excludes prescriptions with a class code but they are returned in this query to see the whole list for comparison. The results are sorted by provider, then the medication's class, then the method. (so the ones excluded from the MU report have a number in the Class column are below the ones that aren't).

When doing detective work I tend to do queries like this and copy & paste the results into Excel if I have to save or print. It's not ideal for reporting but I haven't learned Crystal yet so it works out for things I don't have to run much.

Posted : July 23, 2012 5:39 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