Hi,
In PAT call on 24th April (Bahmni PAT call 24th April 2019), the following approaches were spoken about:
-
Adding a new column called ‘parent_appointment_id’ to ‘patient_appointment’ table. With this approach, we can get all past occurrences of an appointment, even when its recurrence pattern has been changed. It also becomes easier to cancel a set of appointments.
-
Appointment Number: A unique appointment number for a specific set of ‘recurring appointments’. With this approach, we are not making the model clear enough for a developer to understand the logic out of the box, as we are overloading the appointment number with a responsibility it is not responsible for.
We would like to suggest the 1st approach, as it is independent and does not club with the logic of Appointment number generation. Giving the liberty to the system to use Appointment Number for just identifying an appointment.