This column is used to describe the stage of a registered course for a student, and the statuses on registered courses impact the Transaction Status on the associated summary tables.
IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'P' and none = 'R' or 'C' |
Status for a course for which the student has been registered but has not yet begun |
|
IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'C" and none = 'R' |
Status for a course that is now in session |
|
IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'H' |
Status for a course that has been graded and updated to the student's academic summaries |
|
IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'W' |
Status for a course for which the student has attempted to register but has not been accepted because it is full |
|
IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'D' |
Status for a course for which the student has registered but dropped by the designated date |
|
IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'R' |
Status for a course for which the student has registered and not yet paid (if it is a Must Pay course) or for which the student has registered via the campus portal (JICS) Course Schedules portlet and is in a group requiring Advisor approval; the course remains in Reserved Status until the student's advisor approves the registration |
While the transaction status is physically stored on the Student Course History table, the codes are used to separate the table into individual segments.
|
|
A program that uses only current registrations would access only those rows on the Student Course History table with a status code of 'C'. You may change transaction status codes manually for each student during pre-registration or online registration. |
There are two main Summary tables:
· STUDENT_TERM_SUM table is updated by the Part-Time/Full-Time process. It contains part-time/full-time information for each year/term combination in which a student is registered.
· STUD_TERM_SUM_DIV table is updated by Recalculate Academic Record process and by the Part-Time/Full-Time process. It contains GPA information, part-time/full-time information for each year/term/division combination in which a student is registered. In addition, the table stores a snapshot of limited degree and advisor information.
The Part Time/Full Time Record Status is from the Student Term Summary table, which is updated by the Recalculate Academic Record process.