Skip to main content

Student Fields


Remaining Years

The remaining years field indicates how many years the student has left before leaving the school's highest grade level. This information is useful for financial forecasting.   Remaining years is continually updated everytime the student completes a year.

PEMS find the maximum value of grade level in the system = highest_grade_level.  Note: the calculation below does not include the academic year in progress.

  • remaining_years = highest_grade_level - current_grade_level

Graduation Date

The graduation date is the end date of the last academic year the student will attend the school   

  • remaining_years = highest_grade_level - current_grade_level
  • sequence of last academic year = sequence of current academic year + remaining_years
  • graduation date = end date of last academic year (as found by the sequence above)

Note: In subsequent versions, there will be a manual override on remaining year and graduation date.


Student First Term

The student first term is a field in the student table that  has the name of the school term the student first attended the school. There is no parent/child relationship between terms and students because students are linked to student terms, which are linked to school terms. So this field is just a text field.

  • Based on the student's start date, PEMS finds corresponding school term, and enters the name of the term in the Student First Term field.
    • The start date of the school term is equal to or before the student start date
    • AND the end date of the term is equal to or after the start_date

The start term is constantly recacluated untill the student start date passes.


Enrollment Year Terms

Students transfer in and out of schools at various times and frequently in the middle of school terms.  Many student's do not complete all the terms in their first year enrolled in the term. Based on the student's start date, PEMS calculates how many terms the student attends in their first year attending the school.

  • Based on student's start date, PEMS finds the corresponding school term (student's first term)
  • There is a term label record associated to this first school term, the sequence of the related term label record = "sequence of term label of start term"
  • total number of term label records that are marked active&required  = "required terms"
  • enrollment year terms = "required terms" - "sequence of term label of start term" + 1

The enrollment year terms are constantly recacluated untill the student start date passes.


Total Remaining Terms 

The total remaining terms can not be caculated unless the number of terms in the enrollment year has been calculated.

  • Total remaining terms = (enrollment year terms) + (remaining academic years) x (required terms)

The Total remaining terms are constantly recacluated untill the student start date passes.  After the start date passes, a different foumula is used to calcluate the total remaining terms. The number of completed terms are subtracted from the total remaining terms

  • Count of student term records that have statusfield of complete = "number of completed terms"
  • Total remaining terms = total remaining terms = "number of completed terms"

This value is updated everytime there is change to the completed terms. In this way, if a student attends an optional term, like a summer term, the terms will be subtracted from the remaning term.  A student who goes to summer school will complete earlier that one who takes summer off.

Back to top