Clean-Up Unconfirmed Student Course Attempts - ADMJ3850

Subsystem

Admissions

Purpose

This job is run to delete unconfirmed student course attempts that were created by pre-enrolling admission offers

Normally Run By

Admissions Specialist

Anticipated Frequency

Scheduled as a standing request to run nightly in Job Scheduler 

Update Process(es)

Removes unconfirmed course attempts that were inserted by the pre-enrolment process 

Parameter Sample

 

Report Sample

 

Related/Dependent Jobs

Dependent on the 'Enrolment Clean-up' date alias being set. 

 

Update Process

This process deletes unconfirmed student course attempts that were created by the pre-enrolling of admission offers.

The process looks for student course attempts that have a course attempt status of UNCONFIRMED. These records are then checked for an admission course application instance with either:

  • An admission outcome status of REJECTED, WITHDRAWN or VOIDED; or
  • An admission offer response status of REJECTED, LAPSED or DEFERRAL.

If these conditions are met the process deletes for each record:

  • The student course attempt;
  • Any student unit attempt records as well as any histories;
  • Any student course HECS options;
  • Any student unit set attempts; and
  • The student course attempt enrolment record.

When deleting unconfirmed student course attempts, any fee assessments are reversed provided the effective date of the fee assessment was set to a date that is later than the course commencement date. Otherwise ADMJ3850 does not reverse the fee assessment because it uses the course commencement date as the effective date for reversing fee assessments.

If contract and sponsorship details have been established in the Establish Fee Contracts form (ADMF3660) and a predictive fee assessment has been run, the process will:

  • Reverse the fee assessment and insert the transaction amounts to reduce the balance in FINF3610.
  • End date the contract by inserting the start date of the contract, this can be viewed in FINF2900 and ADMF3660.
  • End date sponsorship with the sponsorship start date, this can be viewed in FINF4300.
  • Not delete the student course attempt.
  • Report the student details and the message 'Unconfirmed Student Course Attempt not deleted because of fee assessment details' in ADMR3850.

If a contract has been established, but a predictive fee assessment has not been run, the process will:

  • Delete the contract and the student course attempt.
  • Report the student details and the message 'Unconfirmed Student Course Attempt successfully deleted' in ADMR3850.

The process also checks for the existence of any other course attempt related data prior to deleting. For example: advanced standing that cannot be deleted because it has a granting status other than APPROVED. If this data cannot be deleted, an entry is made in ADMR3850.

 

Run Details

The job is typically scheduled to run as a standing request in the Job Scheduler.

Each night this job runs, it checks to see if the value of the Enrolment Clean-up date alias matches the current date. If the dates mismatch, the job cancels. If the dates match, the update process is performed. The Enrolment Clean-up date alias instance value would normally be near the end of each enrolment period.

For details on setting up the Enrolment Clean-up date alias, refer to the Maintain Enrolment Calendar Configuration form (ENRF01F0).

Note: where the job has cancelled due to the mismatch of dates, a blank report is still produced.

Refer to the Job Control and Scheduling subsystem for details on scheduling and running standing requests.

  

Job Parameters

There are two parameters available for this process:

  • The Previous Log Creation Date parameter allows the job to be run for a previous report.
  • The Report Level parameter allows the user to run the report displaying all messages or exceptions only.

 

Job Output

Depending on parameters selected, the report produced can display all records successfully processed or only display exceptions encountered.