Open Dental Forum

Hello,

I am developing SMS applications to interact with OD for the recall function. I am trying to retrieve the daily recall list via query from the SMS application. I am aware that in my query I should exclude those future scheduled appointment which has the relevant recall-configured Procedure Codes (correct if I am wrong).

I guess I need to look at Recall and Appointment. My issue is how do I associate these 2 tables? For example, how could I determine this recall that has already the related scheduled appointment? I was looking at the field of ProcDescript in Appointment table…

Thanks in advance!!

Best regards, Tim

We don't actually associate these two tables. So we have no easy way yet of getting a daily recall list. All that the program provides users is a daily confirmation list. One way to do it would be to look at what procedures were attached to the appointment. If there are recall procedures, then it's likely a recall appointment. But you'll get a few false positives.