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.created/activated.

ThereCompleted canPlans only- when a student completes all the classed under that plan, the plan is marked completed.

Future - Student plan records may be onemade activefor future grade spans. If the student has a future plan atalready created, then the student will be auto-enrolled in the next set of classes without any givenneed time.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