Skip to main content

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.