Notifications
Clear all
Topic starter
hi all-
has anyone developed a system for tracking active BUP/suboxone prescriptions per clinician.
if a clinician has a 30 prescription limit, how can it be tracked to ensure the clinician is not over the DEA allowed limit?
thanks
Judy Davidoff, MD
jdavidoff@chasebrexton.org
Posted : November 22, 2017 3:16 am
This could be accomplished through a sql query or a report. Below is sql query for this, you may have to adjust it but this should suit your needs.
select u.LASTNAME + ', ' + u.FIRSTNAME as Provider, COUNT(p.PTID) as AmountPrescribed from PRESCRIB p
INNER JOIN USR u on u.PVID = p.USRID
INNER JOIN MEDICATE m on p.MID = m.MID
where p.DB_CREATE_DATE >= DATEADD(month, -1, GETDATE()) AND m.DDID in ('-160209','160209','160210','176428','176429')
GROUP BY u.LASTNAME, u.FIRSTNAME
Just update the DDID fields and you should be good to go.
Thanks,
Jonathan
Posted : November 23, 2017 4:35 am
