Transaction Status

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.

P (Pre-registered)

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

C (Current)

IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'C" and none = 'R'

Status for a course that is now in session

H (History)

IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'H'

Status for a course that has been graded and updated to the student's academic summaries

W (Wait listed)

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

D (Dropped)

IF any STUDENT_CRS_HIST.TRANSACTION_STS = 'D'

Status for a course for which the student has registered but dropped by the designated date

R (Reserved)

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.

i_example.jpg

 

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.

Student Information Tab (Student Information Window)

The Part Time/Full Time Record Status is from the Student Term Summary table, which is updated by the Recalculate Academic Record process.