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

Report to find new Rx's for controlled substances

MU, CQR, PQRS, etc.

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

154 Views

RSS

Lauriaberger

(@lauriaberger)

Posts: 7

Active Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

aroberts

(@aroberts)

Posts: 176

Reputable Member

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

chaddix

(@chaddix)

Posts: 177

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 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