2. Student Record Intake Functions

2.0 Set Intake Value Defaults - COMPLETED

Set Student current grade level equal to Student start grade.

Set Student promotion equal to "promote".

Set Student status equal to "planned".

Set Student cohort  = linked homeroom record

Creating student logins will be done in a separate step after student record created.

2.1 Enter Student's Grade Span and School

Find the Grade Span with start grade greater than or equal to the Student current start grade level AND Grade Span with end grade after of equal to the Student current: grade span start grade ≤  student start grade ≤ grade span end grade

Associate the Grade Span record found above to the Student record with the Student grade span field.

Find the School record associated to the Grade Span record found above and associate to the Student record with the Student school field.

2.2 Calculate Graduation Date and Remaining Years

Student remaining years =  School Configuration highest_grade_level - Student current start grade level.

note: remaining years does not include the student's enrollment year/current year

Find the Academic year with the sequence value found above, this is the graduating academic year.  There is no field for the graduating academic year.

Find the grad year end date.

The end date of the last School term of the graduating academic year is the Student graduation date.

Use grad year end date, calendar functions will update the year end date based on the school term associated end date when there is a change.

2.3 Find and Enter Student's School Start Term - COMPLETED

Find the School Term with start date before or equal to the Student start date AND School Term with end date after or equal to the Student start date:

school term start date ≤  student start date ≤ school term end date

Associate the School Term  record to the Student record with the School Start term field.

2.4 Calculate Enrollment Year Terms

Find ordinate of the the School Term linked to the Student from the school start term field, found in function 2.3 above.

If the Term Label record linked to the School Term has Term Label flag = official end term, then Student Enrollment year terms = 1. (Then quit logic)

Else:

Find the start year's child School Term record.

Find the ordinate of the School Term linked to the Student.  ("ordinate start")

Based on the related  Term Label flag, flag = official end, find the ordinate of the last school term in the academic start year.

Find the ordinate of the School Term record in the same Academic Year = same as Student school start term and has a linked Term Label record with flag = official end term. ("ordinate end")

Enrollment year terms = end year ordinate - ordinate of school start term + 1

Find remaining terms. Subtract the sequence the student schools start term from the school term record found above, the official end term, then add 1:

remaining terms = ("ordinate end") - ("ordinate start") + 1

This method assumes that there are no interim terms that are optional, that the optional terms are either at the beginning or end of an official academic year. 

There is one use case  where this assumption will fail, the 'intersession' where students can optionally enroll in a short period between terms, usually over the Christmas holiday to make up work that was not completed.

We will not design for intersession, and only allow optional terms to be before or after the standard academic year. This use case is not very common.

"ordinate start" = 24

flag = official end term

2.5 Calculate Remaining Terms in Enrollment Grade Span

When new student record is entered and only once on student intake. 

note: this field is updated in the advancement workflow, but it will use very  different logic than this initial value

Find the remaining academic years in the grade span:  Subtract Student current grade level from Grade Span End grade:

Grade Span End grade - Student current grade

If the value above is zero then set remaining terms = enrollment year terms.

Else:

Step 3

DONE

Find required_terms_year in the School Configuration 

NOTE: NEED TO ADD THIS FIELD TO CONFIGURATION PAGE

Multiply number of required terms times the number of remaining years in the grade span

required_terms_year X (Grade Span End grade - Student current grade)

Add Student Enrollment year terms to above:

Student Enrollment year terms + required_terms_year X (Grade Span End grade - Student current grade)