Purpose

This form allows an administrator to view and edit Tertiary Education details entered by an applicant in the Applicant Portal

Anticipated Frequency

As required

Structure

Blocks

Applicant

Buttons

Find Applicant (ADMF5010)

Person Tertiary Education (ADMF32B0)

This form allows an administrator to view and edit Tertiary Education details entered by an applicant in the Applicant Portal. This function will be called in context of an applicant from the View Applicant Summary function or from the menu.

The screen allows the administrator to view and modify Tertiary Education records for the applicant. Only records that have an institution-defined Transfer Status mapped to a system transfer status of PENDING, ERROR, or NO-TRNSFR can be modified. A record that has a status of TRANSFERRD has a valid corresponding record in Callista Admissions and cannot be edited in this screen. A record that has a status of NOT-APPLIC indicates that the applicant has not yet submitted the application to which the Tertiary Education applies.

The transfer status of the record can be modified by the administrator, provided the status of the record has a system status of PENDING, ERROR, or NO-TRNSFR. The transfer status may be changed to any of these statuses; not to a system status of TRANSFERRD, NOT-APPLIC, NO-STEP or PRE-EXIST.

The log of messages received when attempting to transfer each record is displayed. An icon is displayed against each type of message to indicate whether the message represents an error, warning, or information.

A button exists on the form that navigates the user to the corresponding SMS Admissions form (ADMF32B0) in context of the person. This button will only be enabled if a corresponding person record exists for the applicant in SMS.

The Applicant block contains:

• Applicant ID
• Sex
• Date of Birth
• Applicant Transfer Status (LOV)

Buttons

• Find Applicant (ADMF5010)
• Person Tertiary Education (ADMF32B0)

The Tertiary Education block contains:

• Country Code (LOV)
• Description
• First Year of Enrolment
• Last Year of Enrolment
• Transfer Status (LOV)
• Institution Code (LOV)
• Institution Name
• Qualification
• Level of Completion (LOV)
• English Institution check box

The Transfer Log block contains:

• Result Type Display (Pop)
• Creation Date
• Message Number
• Message Text

Icons

• E = ERROR (Display )
• W = WARNING (Display )
• I = INFORMATION (Display )

Rules/Notes:

The Applicant Block

• The Find Applicant button is only enabled in Query mode.
• The Person Tertiary Education button is disabled when no Person ID or when no records exist in form Record Prior Tertiary Education (ADMF32B0)

The Tertiary Education Block

• The English Institution check box only applies for Overseas Countries, i.e. where Country Code is not Australia

Validations include:

• None of the applicant’s details can be modified when the System Transfer Status is TRANSFERRD, NOT-APPLIC or PRE-EXIST
• Only one of Institution or other institution not listed can be entered
• First Year Enrolled must be less than or equal to Last Year Enrolled (when both entered)
• Institution must be self serve available
• Institution must be an overseas institution when Country Code is not Australia
• The Level of Completion must be open
• The Level of Completion must be available to Applicant Portal
• Transfer Status must be open
• Cannot change the Applicant Portal Transfer Status to the System Transfer Statuses of TRANSFERRD, NOT-APPLIC, NO-STEP or PRE-EXIST

Applicant ID:

APA.APPLICANT_ID

Text (with Find Applicant button)

Number 9999999990

APA.SURNAME ||’, ‘|| APA.TITLE ||’ ‘|| NVL(APA.PREFERRED_GIVEN_NAME, APA.FIRST_NAME)

Text

Varchar2(100)

Populate after query When there is no Title and NVL(APA.PREFERRED_GIVEN_NAME, APA.FIRST_NAME), then the comma is not shown. e.g. if only the Applicants Surname of ‘Smith’ is recorded, then only this should display.

Sex:

APA.SEX

Poplist

Varchar2(10)

Date of Birth:

APA.BIRTH_DT

Text

Date DD/MM/YYYY

Applicant Transfer Status:

APA.AP_TRANSFER_STATUS

Text (with LOV)

Varchar2(10)

Country Code

APTAV.COUNTRY_CD

Text (with LOV)

Varchar2(10)

APCNCV.DESCRIPTION

Display Field

Varchar2(60)

First Year of Enrolment

APTAV.FIRST_YR_ENROLLED

Text

Varchar2(10)

Last Year of Enrolment

APTAV.LAST_YR_ENROLLED

Text

Varchar2(10)

Transfer Status

APTAV.AP_TRANSFER_STATUS

Text (with LOV)

Varchar2(10)

Institution Code:

APTAV.INSTITUTION_CD

Text (with LOV)

Varchar2(10)

INS.NAME

Text

Varchar2(90)

Institution Name:

APTAV.OTHER_INSTITUTION

Text

Varchar2(100)

Qualification:

APTAV.QUALIFICATION_NAME

Text

Varchar2(100)

Level of Completion:

APTAV.LEVEL_OF_COMPLETION

Text (with LOV)

Varchar2(14)

English Instruction

APTAV.ENGLISH_INSTRUCTION_IND

Check box

Varchar2(1)

Only displays when the APTAV.COUNTRY_CD = APCNCV.COUNTRY_CD AND APCNCV.DESCRIPTION ‘ AUSTRALIA’

Creation Date

APTRV.CREATION_DT

Text

Date DD/MM/YYYY HH24:MI:SS

Message Number

APTRV.MESSAGE_NUMBER

Text

Number 99990

Message Text

APTRV.MESSAGE_TEXT

Text

Varchar2(200)

Result Type Display

Poplist

Varchar2(25)