Purpose

This function enables the QTAC Offer files to be loaded into Callista.

QTAC provide two sets for data files, one set for Commonwealth Supported Places and one set for full Fee Paying Offers.

The process will:

• Validate the files format.
• Validate selected element values.
• Check for Existing ID's before loading new Persons.
• Insert or Update existing address data with new element values.
• Create Admission Application, Admission Course Application and Admission Course Application Instance records. The Offer Status will be set to Offered and the Offer Response Status to the System default for Pending, if possible. (Note: ACAI Offer Status is set to the institutes default Offer value.)
• If an ACAI for the offered course exists in Callista SMS with a current deferment the deferral will be lifted and the ACAI set to offered with a pending offer response. If a deferral for the offer course exists which is not current a new ACAI will be created for the course in the current period.
• Create Student Course Attempt records and Pre-enrol students where specified by job run parameters.
• Insert or update Person statistics.
• Insert an alternative Person ID.
• Insert Secondary Education details.
• Load all data as outlined in the processing section.
• Write failed data load errors to the Error log within Callista SMS.

The data uploaded relates to the data displayed in the Direct Admission form (ADMF3000) and its associated Sub-Form areas. Some data added is dependent on referential data in other tables.

See the TAC Process for further details on Tertiary Admission Centre information.

This job is accessed via the menu.

The Process QTAC Offer Files Load block contains:

Parameters Tab

• Enrolment File Name
• Fact File Name
• File Type
• Offer Round
• Academic Period (LOV)
• Admission Period (LOV)
• Standard Address Type (LOV)
• Non-standard Address Type (LOV)
• Alternate Person ID Type (LOV)

More Tab

• Override Admission Category (LOV)
• Student Status (LOV)
• Pre-enrol check box
• Offer Letter Required check box

Rules/Notes:

Validations include:

• A mandatory field is not null.
• An Admission Course Application Instance exists for this person and Course Offering option, that is not deferred.
• A Student Course Attempt record already exists for this student and Course Offering option.
• Student Status is not valid for selected Override Admission Category.
• Override Admission Category is mapped to the Admission Period.

The user can define up to 60 characters in the Enrolment File Name and Fact File Name fields.

All fields are mandatory except the Override Admission Category field which is optional.

Enter data in all mandatory fields. If any mandatory field is left null, warning messages will display before the user can contine.

Rules/Notes:

If a Student Course Attempt has a Fee Category defined and/or a Student Status that exists at the current date, then no change is made to the Fee Category value and/or Student Status when the Pre-enrolment process occurs. In these cases, depending on whether the pre-enrolment process occurs via ADMF3240 or ENRJ3100, a warning message is displayed in ADMF3240 or written to the S-LOG-ENTRY for ENRJ3100.

If no records are in the file, this job should return completed with zero rows processed, recorded in the audit log.