Student Plan Table

The student plan record keeps track of what plans have been assigned to the student over time.  Student Plan records specify the program of study and keep track of the start date, end date, and status of the plan.

Status of the Plan

Active Plans - There can only be one active student plan at any given time.

Suspended Plans - Students may change plans before they are completed, in this case the plan is suspended and a new student plan record created/activated.

Completed Plans - when a student completes all the classed under that plan, the plan is marked completed.

Future - Student plan records may be made for future grade spans. If the student has a future plan already created, then the student will be auto-enrolled in the next set of classes without any need for user involvement.

Units

The plan is a series of classes, and each class has a number of units assigned to the class.  the units from the related completed enrollment records are summed to determine how many units have been completed under this plan.

Adherence

As the student is completing the enrollment records on schedule, then the student is in compliance with the plan. If the student is not completing the enrollment records, then the plan adherence is "below plan."  If the student is completing the plan, and adding extra classes, or is completing the plan early, the Adherence is above "plan."

Plan GPA

Add GPA field to the plan, Calculating the GPA for all classes associated with the plan