This process extracts information from the database, and can update the database. |
||
Subsystem |
Enrolment |
|
Purpose |
To extract data containing relevant information for inclusion on a confirmation of enrolment notice |
|
Normally Run By |
An enrolments specialist via Job Scheduler |
|
Anticipated Frequency |
At regular intervals during enrolment periods; on an ad-hoc basis for individual students |
|
Parameter Sample |
||
View Details & Data Source |
||
Related/Dependent Jobs |
|
Extract Process |
This job uses the generic 'extract table' structure to store extracted data which can be used for the production of confirmation of enrolment notices. A program which uses the extracted data (and data from other Callista tables if required) to produce confirmation notices can be custom built by the institution. The program accesses the extracted data via views specifically created for the confirmation of enrolment extract process. Extract Creation Processes describes this methodology.Technical detail regarding confirmation of enrolment extracts is provided in release Technical Documentation. Details of the data available in Confirmation of Enrolment views is available in Confirmation of Enrolment Extract - View DetailsRecords can be selected for batches of students or for a single student . Primary record selection is dependent on which of certain parameters are used. Records are extracted only for student course attempts with units which incur load in the target load calendar. The process:
Where a person ID is specified as a job run parameter, only records for that student are selected. Similarly, other parameters can be used to refine the set of student course attempts for which confirmation of enrolment extract records are created. Record Extraction The extract process creates a record in the S_EXTRACT table which identifies the particular extract job run. It creates corresponding records of student course attempts for which confirmation of enrolment extract records have been created, in the S_EXTRACT_RECORD table. Records are not normally created where a confirmation of enrolment record has been extracted in a previous run, however, parameters allow this job to be run to produce a replacement notice or to reissue a notice if enrolment circumstances change. |
Update Process |
For each student course attempt for which confirmation of enrolment records are extracted, the process can register an outgoing correspondence item, with a specific confirmation of enrolment correspondence type ( CORF2320). If required, a parameter allows confirmation of enrolment extract records to be produced without the recording of correspondence items. |
Run Details |
Method ENRJ8500 runs only in batch mode, through the Job Control & Scheduling subsystem.Place in cycle This job would typically be run during and immediately after the enrolment period for the target students. Viewing the extracted data Data is usually processed by the institution's custom built confirmation of enrolment creation and printing job. Data can be viewed in the S_EXTRACT and S_EXTRACT_RECORD tables, or in a more useable form in the views ENR_CNFRMTN_EXTRACT_V and ENR_CNFRMTN_RECORD_V, using an ad-hoc query tool. |
Selection of parameters for this job depends on the particular circumstances in which it is being run.
NOTES: The % symbol indicates that the parameter is not considered for processing. |
||
Load Calendar Instance |
mandatory - student course attempts are selected for inclusion in the extract on the basis of having a unit attempt which incurs load in the specified load calendar. Record selection describes this further.Note that selection of an aggregate load calendar is equivalent to selecting all of its subordinate load calendars. |
|
Enrolment Category |
optional - restricts record selection to student course attempts with the specified enrolment category. Default is all enrolment categories. |
|
Student Type |
mandatory - restricts record selection to specific commencement types of students. One of:
must be selected. Default is ALL. |
|
Responsible Org Unit |
optional - the code of a single organisational unit (OU) can be selected or entered. Limits record selection to those for student course attempts in a course version with the specified responsible OU or one of its subordinate OUs. The default is all organisational units. |
|
Location |
optional - the code of a single open location can be selected. Limits record selection to those for student course attempts with the specified course location. The default is all locations. |
|
Attendance Mode |
optional - the code of a single attendance mode can be selected. Limits the selection of records to those for student course attempts with the specified (nominated) attendance mode. The default is all attendance modes. |
|
Attendance Type |
optional - the code of a single attendance type can be selected. Limits the selection of records to those for student course attempts with the specified (nominated) attendance type. The default is all attendance types. |
|
Course Type |
optional - the code of a single course type can be selected or entered. Limits the selection of records to those for student course attempts in course versions of the specified course type. The default is all course types. |
|
Course |
optional - the code of a single course can be entered. Limits the selection of records to those for student course attempts in that course. The default is all courses. |
|
Person ID |
optional - permits a confirmation of enrolment notice to be produced for a single student. This might be the case where it is required to reissue a confirmation of enrolment notice. Other optional parameters are not normally used where person ID is specified although Course may be specified for a student with more than one current course attempt. |
|
Person ID Group |
optional - permits an ID group to be specified. Extract records are produced only for students whose ID number is a member of the ID group. This parameter would typically be used where it is required to produce confirmation of enrolment notices for a disparate group of students or for a group of student ID numbers produced by a query tool. The default is no ID groups, meaning that only other specified parameters are considered. |
|
Override Sent Check |
mandatory - must be set to either YES or NO. The default is NO. A correspondence item can be created for each student course attempt extracted by this job. Setting this parameter to NO causes correspondence items to be checked. If a confirmation of enrolment notice has already been sent for a course attempt, that course attempt is not included in the extract. If this parameter is set to YES, the correspondence check is not performed and all selected course attempts are included in the extract. |
|
Register Correspondence |
mandatory - one of:
must be selected. the default is YES. To use this feature, a suitable correspondence type (e.g. ENROL-CONF) should exist (see CORF2110) and be linked to the output from this job. |
|
Consider Re-Issues |
mandatory - this parameter is only considered where Override Sent Check is set to NO (i.e. no record is created if confirmation of enrolment has already been sent). Setting this parameter to YES allows for reissuing a confirmation notice to those students whose course attempt details have changed since the original notice was issued. For example, where a student has added an additional unit or unit set to their course attempt after the first notice was issued. Setting this parameter to NO means that student course attempts which already have a confirmation of enrolment correspondence item are not reconsidered for reissue of a confirmation notice even if their course attempt enrolment has changed. |
Last Modified on 21 September 1999.