Hi there,
I find that values in DateDue and DatePrevious in recall table very confusing. And the database schema documentation is not helping me either.
Very often values in DateDue and DatePrevious are '0001-01-01' after running Recall report. If DateDue is calulated bsed on last appointment it should always have valid date as far as I understand.
Is there any documentation that explains the logic on how dates are set in these fields?
Awadh
DateDue and DatePrevious columns in recall table
Re: DateDue and DatePrevious columns in recall table
https://www.opendental.com/OpenDentalDo ... xml#recall
DateDue:
DateDue:
DateDueCalc:It will usually be the same as DateDueCalc unless user has changed it.
Someone from OD will probably have to chime in as to what exactly those triggers are, but based on the above, '0001-01-01' can reasonably be expected as a value in those reports. You could always filter out that date.It can be blank (0001-01-01) if no appropriate triggers.
Re: DateDue and DatePrevious columns in recall table
DatePrevious is calculated from the most recent ProcDate amongst all trigger procedures with a status of Complete (C), Existing Current Provider (EC), or Existing Other Provider (EO) for the given patient and recall type. It defaults to the minimum date (0001-01-01) if the patient has no trigger procedures in one of those states.
As dcrider mentioned, the DateDue is usually the same as DateDueCalc unless a user has overridden it on the Edit Recall window. DateDuleCalc is the DatePrevious + the RecallInterval, but it will also be set to 0001-01-01 if DatePrevious is 0001-01-01.
The Edit Recall manual page where the Due Date can be set: https://www.opendental.com/manual/recall.html
The Edit Recall Type manual page where Trigger Procedures are set: https://www.opendental.com/manual/recalltypes.html
As dcrider mentioned, the DateDue is usually the same as DateDueCalc unless a user has overridden it on the Edit Recall window. DateDuleCalc is the DatePrevious + the RecallInterval, but it will also be set to 0001-01-01 if DatePrevious is 0001-01-01.
The Edit Recall manual page where the Due Date can be set: https://www.opendental.com/manual/recall.html
The Edit Recall Type manual page where Trigger Procedures are set: https://www.opendental.com/manual/recalltypes.html
Re: DateDue and DatePrevious columns in recall table
Thank you for the reply Dcridera and Joe, Much appreciated.
All triggers seem to look OK to me. Anyway, i now have a pointer and will keep looking into it closely.
Additional question: When will a patient drop out of the recall list.
If I have sent a text as part of recall to a patient and patient has subsequently made an appointment. I would have thought OD will not show that patient in the recall list anymore. But I can still see that patient in the recall list.
Awadh
All triggers seem to look OK to me. Anyway, i now have a pointer and will keep looking into it closely.
Additional question: When will a patient drop out of the recall list.
If I have sent a text as part of recall to a patient and patient has subsequently made an appointment. I would have thought OD will not show that patient in the recall list anymore. But I can still see that patient in the recall list.
Awadh
Re: DateDue and DatePrevious columns in recall table
Does the appointment have one of the trigger procedures for the recall on it? The patient should be removed from the recall list when a trigger procedure is scheduled.