Recall list tracking

For users or potential users.
Post Reply
noestervemb
Posts: 59
Joined: Sat Jul 09, 2016 7:45 am

Recall list tracking

Post by noestervemb » Mon Mar 20, 2017 10:06 am

I just had my front desk call a ton of patients on the reclal list to clean it up. Is there a query or way to actually see how many people scheduled without keeping track manually? To see how effective we are at reactivationg.

Dr. O

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Recall list tracking

Post by jsalmon » Mon Mar 20, 2017 10:40 am

I'm only aware of using the Appointments report for seeing how many users used the Web Sched online scheduler to make their appointment. This doesn't give you a break down of "you sent X reminders and Y patients acted on them" though. You would have to manually keep track of the X as of right now which doesn't sound fun.
http://www.opendental.com/manual/reportappts.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
JasonL
Posts: 28
Joined: Wed Jun 10, 2015 1:57 pm

Q

Post by JasonL » Mon Mar 20, 2017 11:31 am

We do have two queries on our Query Examples page that my prove useful to you:
* Query Examples: http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
* Query #456 "Make list and count of patients with scheduled recalls, and what recall procs are in apts"
* Query #513 "Recall Reminders Sent in a specified date range"

If you would like to have a custom query written you can fill out our Query Request form here: http://opendentalsoft.com:1942/ODQueryR ... tForm.aspx

Hope this helps! :-)
Jason Long
Open Dental Web Technology Coordinator
www.opendental.com

rhaber123
Posts: 415
Joined: Fri Dec 11, 2009 12:09 pm

Re: Recall list tracking

Post by rhaber123 » Tue Mar 21, 2017 10:44 pm

I do not write queries but if someone can write this query: " on a certain date, a list of appointments made in the future"
The audit trail of each appointment can be used to create the query.
***Query 850 cover a different subject, but has this info that might be useful for someone who knows how to write a query

SET @FromDate='2017-03-14', @ToDate='2017-03-15';
SELECT A.Patient,
A.TreatingDentist,
DATE_FORMAT(A.FutureApptDate,'%m/%d/%Y') AS 'FutureApptDate',
etc............

Post Reply