Notifications
Clear all
Topic starter
I am wondering if anyone knows the SQL script to remove a medication from the Rx Renewal tab. There is a medication that is controlled. I am unable to resolve due to it being a electronic request. There is no way to deny it due to not being set up for EPCS at this time. Provider has of course responded by other means, but I am looking to remove this medication form her Rx Renewal list.
Thank you in advance!
Posted : December 12, 2019 9:41 am
SELECT * FROM ERXRefillRequest E
JOIN PatientProfile P ON P.PID = E.PID
WHERE P.PatientId = ''
BEGIN TRAN
DELETE E
FROM ERXRefillRequest E
JOIN PatientProfile P ON P.PID = E.PID
WHERE P.PatientId = ''
--COMMIT OR ROLLBACK
Posted : December 13, 2019 6:06 am
