...
- For each student with an active plan (map_plan.object_status = 1), SSP will compare the courses in external_student_transcript_course (formatted_course) for each term (distinct term_code from external_student_transcript_course) with the planned courses (map_plan_course.formatted_course) for equivalent terms (map_plan_course.term_code) starting with the oldest Plan term through the calculation cutoff term. If not cutoff term is defined, the current term will be used. A match will have matching criteria (configurable) for both the plan and transcripted courses. By default the formatted_course and term_code are used for matching. Additionally, the course title and course hours can be used to provide a more precise match. The result of the calculation is a database update in an SSP operational table to store the planning status and reasons for being off plan (if exist). The external_person_planning_status table will remain for implementers choosing to provide the calculation through the data integration.
Process
...
Diagram
Database Tables
Definitions
...
| Insert excerpt | ||||
|---|---|---|---|---|
|
Anomaly Codes