Create Student Term Records
Student Term Records
From the student table, we know the following fields:
- Student first term - calculated by looking up the school term based on the start date
- Enrollment year terms - the number of terms the student will attend in their first year
- Grade level - the students current grade level
- Grade span - the planning horizon for that student based on their grade level
Updating
For every change to the field, student first term in the student record, update the student term records.
Student Term Name
Concatenate: Term Name, StudentInitials, Student Code, “GL” grade level number:
Example from Kassidy’s Record: Spring 2023 KKB14 GL3
Update the record name every time the record is saved with a change to the associated term, associated student fields, or grade level field.