Purpose

Performs bulk Verification checks on Person Scholarships

SubSystem

Scholarships

This job is run to assess the eligibility criteria of applications in bulk. The eligibility criteria that may be tested by this process includes:

• Citizenship
• Age
• Sex
• Admission Score
• Equity Score
• Course records (COURSE APPLICATION/ ENROLMENT/ RECORD)

An application will be updated with a System Application Status of INELIGIBLE if the responses to the eligibility criteria exist but fail to meet the requirements of the parameters set in the job.

An administrator can update the applicants’ data and re-run the job at different times, with different parameters, and as required when further information becomes available.

The job will output to the S_LOG_ENTRY table any scholarship applications that it updates to INELIGIBLE.

The TEXT field in such records contains the following message: 'Application has been updated to an Application Status of INELIGIBLE.'

Whereas for unsuccessful updates the TEXT contains the following: 'Error occurred while attempting to update scholarship application outcome status to the system status of INELIGIBLE.'

Details of records updated are recorded in the s_log_entry table with a s_log_type of SCH-ELIG.

The key field in the s_log_entry record includes the following details:

Applicant ID|Check element  (i.e. CITIZENSHIP, AGE, SEX, ADMISSION SCORE, EQUITY SCORE, COURSE APPLICATION/ ENROLMENT/ RECORD)|Person ID|Sex|Age|Citizenship|Admission Score|Total eligibility score|scholarship code|scholarship version number|scholarship calendar type|scholarship cal sequence number|scholarship outcome status before update.

The log entry ( RUN_LOG.LOG_ENTRY), as viewed in JBSF530, contains a process summary.

For example:
Total Scholarship Application processed: 10
Total Scholarship Application successfully processed: 10
Total Scholarship Application in error: 0

This job is accessed from the main menu.

The Bulk Check of Scholarship ApplicationEligibility block contains:

Parameters Tab:

• Applicant ID:
• Scholarship Code:
• Scholarship Application Status:
• Scholarship Period:

• Check eligibility for:
  • Citizenship check box
  • Age check box
  • Sex check box
  • Admission Score check box
  • Equity Score check box
  • Course:

Rules/Notes:

The first four parameters define the set of scholarship applications to be assessed.
The remaining parameters define what the applicants will be checked for.
e.g if the Sex check box is selected, then the relevant scholarship applicants will be checked that they are the required sex, as defined in the scholarship requirements.

At least one of the eligibility elements must be selected.

Before this job is run, a default Scholarship Application Outcome Status must be mapped to a system scholarship application outcome status of INELIGIBLE and the status (in SCHF0365) must not be closed.

This job can only show periods in which the selected scholarship is offered.

Course poplist values from which to choose are:

• Course Application Exists
  
• Course Enrolment Exists
• Course Records Exists.