Student Plan Table
Note: student plan and student program are used to mean the exact same 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.
The “Student Program” table keeps the history of what program(plan) the student was completing over the years of study. Every time the current program field in the student record is changed, a record is created in the “student program” table. The “student program” record stores the program(plan) name as well as the planned start and end dates of the program. The student program table acts like a log file of changes made to the ”current program” field in the student record.
The student programs table stores the association between the plan and the student, basically, which plan was assigned to which student and when. Students will have multiple plans over the course of their time at our school, as they will progress through multiple grade spans.
The student programs table also stores the start and end dates of the plan. For example, if the student was assigned the plan half-way through the term, the exact date the student was assigned the plan is recorded. Based on the start date, PEMS looks up the correct term and automatically associate sthat term into the student program record in the program_start_term field. This table also stores additional information as to how the student is executing their 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