Notifications
Clear all
Topic starter
Does anyone have a report that will show us who has had controlled substances written for them? Not just on a med list, but scripts signed within a specific time period. We'd need to be able to narrow down by provider, and provide a date range.
Or, if you've implemented an integrated PDMP, is there an option within what you're using that shows those that did not have a PDMP pulled prior to the script being signed?
This would be useful to run in support of IA_PSPA_6
7/9/19 *Additional Information* We use CPS, are not yet doing EPCS (though if you have an option that works when that happens, I'd still love to see it), and do not link chronic pain med users to a problem specific problem.
Thanks for your input so far!
Posted : July 1, 2019 7:37 am
While this may not be exact, we use the attached report.
Background - We assign our chronic narcotic pain patients with a problem code, and I run monthly reviews of patients with this ICD-10 code.
Then, to find patient we may want to assign to this group - which has a PA to review, etc.. - we run the attached monthly to find patients who within prior 100 days has gotten a prescription for something we normally watch.
So, take a look and run the attached. It was written for EMR.
M201 Pts Medications Prescribed
Hopefully this may get you started.
Posted : July 3, 2019 5:13 am
I have been asking for a report like this for quite some time and haven't had any luck. And I don't want it associated with a diagnosis code so the above option won't really help.
I have a way to see how many controlled substances were ePrescribed or denied through EPCS via surescripts (although not the best reporting capabilities) but that does not tell me the whole story because we have some that are still printed and given to patient (our state isn't mandated until 2020) therefore I don't actually have an accurate number. If I am just searching for a specific drug, I am good in the PRESCRIB table by using the SDID from the MEDICATE table but I can't seem to find a way to determine if it is controlled or not without individually looking at each medication. I wish there was a column in the PRESCRIB table that would mark if the prescription was controlled. Perhaps there is and I am missing it? If I could have that then we could both have the query we are looking for.
We have implemented integrated PDMP but it only brings up per patient, not an overall doctors prescription of controlled substances history. We use Qvera's PDPM so it does record an observation term into the DB so you could technically search when the obs was last recorded and if the prescription was filled after but this will be tricky since your timestamp of the obs recorded and the prescription being done will be probably at the same time when the clinical list changes are signed.
Posted : July 9, 2019 7:54 am
This SQL statement should get you part of the way there. Good luck!
DECLARE @S DATE
DECLARE @E DATE
SET @S = '6/1/2019'
SET @E = '6/30/2019'
SELECT P.PatientId, P.First, P.Last, P.Birthdate, M.DESCRIPTION AS MedName, M.INSTRUCTIONS AS MedInstructions, RX.CLINICALDATE AS RXDate, RX.QUANTITY AS RXQty, RX.REFILLS AS RXRefills, RX.RXTYPE, RX.PHARMACY,
CASE
WHEN EPCS_Error_Code IS NULL THEN 'Successful'
ELSE 'E-Prescribing Error'
END AS eRXStatus
FROM MEDICATE M
INNER JOIN PRESCRIB RX ON M.MID = RX.MID
INNER JOIN PatientProfile P ON M.PID = P.PId
INNER JOIN MEDINFO I ON M.NDCLABPROD + M.NDCPACKAGE = I.NDCNUM
WHERE I.CLASSCODE IN (2)
AND RX.CLINICALDATE >= @S
AND RX.CLINICALDATE <= @E
AND RX.CHANGE IN (2,6)
Posted : July 9, 2019 9:07 am
