Enrollments Table
DependentRelevant Tables
Topics
Program{{@90#bkmrk-this-is-the-list-of-}}
{{@90#bkmrk-curriculum-generall-}}
{{@90#bkmrk-the-term-course-is-n}}
{{@90#bkmrk-in-summary%2C-enrollme}}
{{@90#bkmrk-a-student-term-recor}}
{{@185#bkmrk-moodle-course-id-is-}}
{{@185#bkmrk-sections-are-used-to}}
Enrollments Table Overview
The softwareenrollment allowsrecord is key to tracking the schoolcourses toa planstudent outtakes, when they take them, and what classes each student will take on an individual basis usinggrade the Programreceived of Study Module. Each and every student has a specially selected plan of what classes to take, andin the school may define unlimited number of plans.course. The plansenrollment record is created and managed in the SIS, but controls all the information needed to automate the enrollment of the student in the correct Moodle course. The enrollment record also contains the correct information to be displayed on the student transcripts.
Data Relationships

Enrollment records are created by mapping information from the schooltemplate administrator by creating templatesrecords associated towith eachthe programassigned (plan).
AThey planare may span multiple grade years, but may only benot linked to one grade span, and may not be longer in duration than the grade span.
Templates
Template records are a set of records that specify which class a student should plan to take in which term. Groups of templates are linked to a program (plan). When the student is assigned a plan, the templates are used to create the enrollmenttemplate records.
Student Plan
A student plan is a record that links the student to a selected program of study. The record tracked the completion of the plan, or series of classed taken according to the plan. There is only one active student plan at any given time. Enrollment records are madealso fornot an active student plan.
If a plan is assignedlinked to athe newplan, student,they itare isinstead likelylinked thatto the student will start the plan half-way through the plan. Enrollment records will only be created for current and future terms, they will not be created for past terms in the plan that the student did not actually complete.record.
Student Terms
Workflow
StudentTo term records are created for the entire grade span of the student. There is a student term record for every school term the student attends in that grade span.
Enrollment Records
Enrollment records relate the student to the class, to the specific curricula (Moodle Course), to a specific student term the class will be taken in, and predict the grade level of the students in that term.
As the curriculum is completed,mark the enrollment recordcomplete, isthe updateduser withfetched the grade from Moodlethe andassociated Moode course, then markedsets complete.the status to complete in the enrollment status field. The student's dis enrollment from the Moodle course is then triggered.
All completed enrollment records appear on the student's transcript.
One enrollment record is made for each template record linked to the selected program plan and linked to the student and the student term.
Future classes
One enrollment record is made for each class the student is takes at the school. Enrollment records are also created for future enrollments to represent the classes the student will have to take to complete the selected plan. Because Plans can not cross over grade spans, there will always be enough student terms records to be associated with the enrollment records. Enrollment records can not be made unless the student term records have already been created.
Worklflow to Automate Creating Enrollment
Record Creation Process
When a student is assigned a plan, the enrollment records are created from information in the template records associated templateto records.the assigned plan. By creating all future as well as current term enrollments, the student can be auto-enrolled in Moodle courses without further user action. The user selects the student’s plan, and then the enrollment records are created.
This approach allows the user to easily see what classes the student has left to take in order to complete the program by looking at all incomplete enrollments. Student progress towards graduation is very difficult to assess with most traditional Student Information Systems.
For the current term, the students are auto-enrolled in Moodle. Students are not enrolled in Moodle courses for any future terms.
Conditions to Create Enrollment Records
Enrollment records can only be created if there are student term records and a student plan assigned. Student term records are created for all terms until the student exits the grade span. To create the enrollments, a plan has to be selected for the student.
Action Items Jan 2024
In the Enrollment table, deprecate link to Section - this has been replaced with SIS group
In the Enrollment table, deprecate Curriculum Option, Class Option, Preference and Set
Add link to SIS Group table, one group per enrollment, groups can be linked to multiple enrollments