I am using external database enrollment method for enrolling students/teachers to their respective courses. A table "enrollment_sync_moodle" is used which contains the list of students/teachers who are enrolled, if an entry from this table is removed, respective participant is also removed from the course on moodle. Now the issue is, I want to finally (permanently) enroll the table entries/participants at the end of each semester, so that new semester could start fresh with 0 entries in "enrollment_sync_moodle". I have searched a lot but I'm unable to find any solution to this problem.
Is there any way to freeze the table entries/make the entries till now permanent. I don't want participants to get unenrolled if their entries are removed at the end of each semester.
I am using Moodle 3.3.3. Kindly help.
Thanks in advance,