Recall and Appointment table

[timtoo]

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

[jordansparks]

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.