| Top of ENR | Index | Table of Contents | Feedback | |
This special topic is a brief summary of the logic used to derive Student Course Attempt statuses.
The status of a Student's Course Attempt, as seen in ENRF3000, is derived either dynamically when a change is made to the student's enrolment or when the job ENRJ5100 - Student Course Attempt Update is run. ENRJ5100 should be run nightly (at least) to update statuses that change because a critical date has been reached. The following table briefly describes the logic of these derivations. Text in italics refers to database tables and columns.
Status |
Code |
Description |
Derivation |
| Unconfirmed |
UNCONFIRM |
Course to which the student has been admitted (pre-enrolled or offered a place), but has not yet confirmed their intention to accept the place and enrol. |
The Student_course_attempt. student_confirmed_ind is ‘N’ |
| Discontinued |
DISCONTIN |
Course from which the student has been withdrawn. |
The Student_course_attempt. discontinued_dt is set and is less than or equal to the Current Date and Time. |
| Lapsed |
LAPSED |
Continuing (returning) student has failed to confirm their unit enrolment within the designated time frame, hence the Student Course Attempt has lapsed due to inactivity. This can be set in ENRF3000 or via a batch process that can set this date based on a System Enrolment Calendar Configuration Date Alias existing in the Parameter Academic Period. |
The Student_course_attempt. lapsed_dt is set and no student_unit_attempt. unit_attempt_status is ‘ENROLLED’ and the Start Date (ci.start_dt) of the associated Teaching Period is less than or equal to the Current Date and Time. |
| Intermission |
INTERMIT |
Course from which the student is currently intermitted (has leave of absence). Once the intermission has expired, the status will revert to INACTIVE or ENROLLED. |
The Current Date and Time is greater than or equal to Student_course_intermission. start_dt and less than or equal to student_course_intermission. end_dt. |
| Completed |
COMPLETED |
Course in which the student has satisfied the completion requirements and has no currently enrolled Student Unit Attempts. |
The Student_course_attempt. course_rqrmnt_complete_ind is ‘Y’ and no student_unit_attempt. unit_attempt_status is ‘ENROLLED’ and the Start Date (ci.start_dt) of the associated Teaching Period is less than or equal to the Current Date and Time. |
| Enrolled |
ENROLLED |
A Course Attempt in which the student has enrolled Student Unit Attempts, or a Course Attempt that has no currently enrolled Unit Attempts but the Current Date is prior to the latest enrolment period enrolment form Due Date. |
At least one student_unit_attempt. unit_attempt_status is ‘ENROLLED’ and the Start Date (ci.start_dt) of the associated Teaching Period is less than or equal to the Current Date and Time OR no student_unit_attempt. unit_attempt_status is ‘ENROLLED’ and the Start Date (ci.start_dt) of the associated Teaching Period is less than or equal to the Current Date and Time, but either the student_crs_atmpt_enr. enr_form_due_dt for latest Enrolment Period is greater than the Current Date and Time or s_enr_cal_conf. enr_form_due_dt_alias for latest Student Course Attempt Enrolment Period is greater than the Current Date. |
| Inactive |
INACTIVE |
Student Course Attempt has no currently enrolled Student Unit Attempts. |
None of the above statuses apply. |
Last Modified on 3 March, 2004