Notifications
Clear all
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
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'
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
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
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
