Notifications
Clear all
Topic starter
I am looking to see if anyone has a report to share, what I am looking a report for a date range of future appointments that have a specific referring physician. If anyone has a report to share I would certainly appreciate it.
If you cannot attach it here you can email it to [email protected].
Thanks in advance!!!
Posted : May 5, 2015 10:32 am
Below are scripts that might be able to help you get what you need.
--This script is for your to look up referring physicians
SELECT *
FROM vSelectPhysician
WHERE (Inactive IS NULL OR Inactive = 0)
--This script is for your to get all future appointments by referring provider, please change the INPUT DOCTOR ID or DOTID HERE to your provider ID in the CPS search screen or DotID in the script above
SELECT *
FROM vPatientAppointments
WHERE ApptStart > GETDATE()
AND (SELECT COUNT(*) FROM PatientProfile WHERE PID = vPatientAppointments.PID AND RefDoctorId = 'INPUT DOCTOR ID or DOTID HERE') > 0 AND ISNULL(Canceled,0) <> 1
ORDER BY ApptStart ASC
Posted : May 5, 2015 11:34 am
