Notifications
Clear all
Topic starter
I need of a report that will provide a list of all prescriptions written (controlled substances and otherwise) by a specific provider and within a date range.
Does anybody have one and is willing to share?
Thanks!
Posted : December 29, 2014 1:36 pm
You can use this script to get this report, replace the PROVIDER LOGIN HERE AND FROM DATE HERE and TO DATE HERE
SELECT (SELECT DESCRIPTION FROM MEDICATE WHERE MID = PRESCRIB.MID) AS MEDNAME, (SELECT RTRIM(FIRST) + ' ' + RTRIM(LAST) FROM PatientProfile WHERE PID = PRESCRIB.PID) AS PATIENT_NAME, QUANTITY, REFILLS, PRINTINFO, CHANGE, PHARMACY, CLINICALDATE
FROM PRESCRIB
WHERE PVID IN (SELECT PVID FROM USR WHERE LOGINNAME = 'PROVIDER LOGIN NAME')
AND CLINICALDATE BETWEEN 'FROM DATE HERE' AND 'TO DATE HERE'
Posted : December 29, 2014 1:59 pm
