Top of ADM Index Table of Contents Feedback

ADMF5000 - View Applicant Portal Summary

Purpose

To view a summary of an Applicant's Application Portal details and results of any application transfer processes

Subsystem Admissions
Normally Run By Admissions Specialist

Anticipated Frequency

As required

Structure

Blocks

 Applicant

Other Applicant Details

Applications

Buttons

 Find Applicant ID (ADMF5010)
Activity Log (SSFF4100)
Email Log (ADMF5050)

Applicant Details (ADMF5100)

Person Match (ADMF5600)

Details (after each row - see below)

 

An administrator will normally use this function in conjunction with transfer results extract data, to enquire on individual applicants using Applicant IDs.

This function includes links to other functions to enable administrators to view other information about the applicant, and to drill down in order to view lower level details of exceptions encountered during the application transfer process. Where possible, applicant and application details displayed in these other functions may be modified to enable successful data transfer when the transfer process is next initiated.

This function displays a summary of the following components of an applicant’s details:

  • Applicant Details
  • Other Applicant Details (e.g. Secondary Education, etc), and
  • Admission Applications.

Sections within this function also include the display of an icon to indicate the highest level of exception/alert generated (if any), when validating details during the most recent transfer process. The highest level of exception/alert will be determined by the following hierarchy (highest to lowest):

  • Error
  • Warning
  • Information

This form is accessed via the main menu.

 

The Applicant block contains:

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

Buttons

The Other Applicant Details block contains:

Highest Ranked Transfer Status

  • Secondary Education
  • Tertiary Education
  • Other Qualification

Highest Ranked Transfer Status

  • Work Experience
  • Admission Test
  • Documents

Buttons (Details)

The Applications block contains:

  • Application Number
  • System Application Type
  • Creation/Submission Date
  • Last Transfer Date
  • Application Transfer Status

Access and Equity Details

  • Highest Ranked Transfer Details
  • Pref No.
  • Course Preference Details
  • Preference Transfer Status

Unit Set

  • Transfer Status

Buttons (Details)

Rules/Notes:

Applicant block

The Person Match Exists lamp. This lamp displays in the top right corner when a record exists in the AP_PERSON_MATCH table where the Duplicate Person Status is not NOT-DPLCT. That is, if there are two records, one with a status of POTENTIAL and the other with the status of NOT-DPLCT, then the lamp would display. If both were NOT-DPLCT, then the lamp would not display.

Information, Warning or Error Icons

These icons will indicate the highest level of exception/alert that occurred during the most recent transfer process. The most recent transfer is determined by finding the latest Creation Date (date and time) in the AP_TRANSFER_EXTRACT_V view where the System Extract Type is AP-TRNSFR for the Applicant ID.

The AP_APPLICANT_V (APAV) will return the appropriate icon name in APAV.APA_ALERT_TYPE to display, that is:

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

The Find Applicant ID button (figure of a person) will appear next to the Applicant ID field when the form is in query mode. It is disabled in Insert mode.

The Activity Log button navigates to the Inquire On AP Self Serve Activity Log (SSFF4100) and is enabled when a System AP Self Serve Activity Log record exists for the Applicant ID.

The Email Log button navigates to View Applicant Email Log (ADMF5050) and is enabled when an Email Log record exists for the Applicant ID.

The Applicant Details button navigates to Maintain Applicant Portal Application Details (ADMF5100). The button is disabled in Query mode.

The Person Match button navigates to Maintain Applicant Portal Person Match Details (ADMF5600). The button is disabled when a Person Match record does not exist or in Query mode.

Applications Block

The System Application Type field shows information dependent on what the applicant has selected. For example, if a Non-Award course application, the field would show Unit details.

 

The Highest Ranked Transfer Status for each Other Applicant Detail type and the Access and Equity Highest Ranked Transfer Status are determined as follows:

 
Possible Transfer Status combinations of underlying records: YES = At least one record has this status; NO = No records have this status; % = Records may or may not have this status
Highest Ranked Transfer Status to Display in ADMF5000

TRANSFERRD

NO-TRNSFR

PRE-EXIST

NO-STEP

NOT-APPLIC

PENDING

ERROR

ERROR

%

%

%

%

%

%

YES

PENDING

%

%

%

%

%

YES

NO

TRANSFERRD

YES

%

%

%

%

NO

NO

NOT-APPLIC

NO

%

NO

NO

YES

NO

NO

NO-STEP

NO

%

YES

YES

%

NO

NO

PRE-EXIST

NO

%

YES

NO

%

NO

NO

NO-STEP

NO

%

NO

YES

NO

NO

NO

NO-TRNSFR

NO

YES

NO

NO

NO

NO

NO

(null)

No records exist

 

Field Details

Label Field Source Field Type Format Comments
Applicant ID APAV.APPLICANT_ID Text (with Find Applicant button) Number 9999999999  
  APAV.APPLICANT_NAME Text Varchar2(100) AP_APPLICANT.SURNAME ||’, ‘|| AP_APPLICANT.TITLE ||’ ‘|| NVL(AP.APPLICANT.PREFERRED_GIVEN_NAME, AP_APPLICANT.FIRST_NAME) 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 is displayed
Sex: APAV.SEX Poplist Varchar2(10)  
  APAV.PERSON_MATCH_LAMP Lamp Varchar2(20) Displays when a record exists in the AP_PERSON_MATCH table where the Duplicate Person Status is not NOT-DPLCT
Date of Birth: APAV.BIRTH_DT Text

Date

DD/MM/YYYY

 
Applicant Transfer Status: APAV.APA_TRANSFER_STATUS Text (with LOV) Varchar2(10)  
Person ID: APAV.PERSON_ID Text Number 9999999999 Only the current Person ID can be queried on. That is, both start and end dates are null in the Alternate Person ID table for the applicant id (alternate person id), or current date must be greater than or equal to start date and less than or equal to the end date (or end date is null) where the person id type is APPLCNT_ID
Secondary Education Highest Ranked Transfer Status: APODSV.SCNDRY_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Tertiary Education Highest Ranked Transfer Status: APODSV.TERTIARY_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Other Qualification Highest Ranked Transfer Status: APODSV.OTHERQUAL_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Work Experience Highest Ranked Transfer Status: APODSV.WORKEXP_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Admission Test Highest Ranked Transfer Status: APODSV.ADMTEST_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Documents Highest Ranked Transfer Status: APODSC.DOC_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Application Number APAPLV.APPLICATION_NUMBER Display Field Number 9999999990  

System Application Type

APAPAADV.S_APPLICATION_TYPE

Text

 Varchar2(10)  
Creation/Submission Date APAPLV.SUBMISSION_DT Display Field

Date

DD/MM/YYYY

 Will show Creation Date when NOT-APPLIC and Submission Date when not NOT-APPLIC.
Application Transfer Status APAPLV.APAA_TRANSFER_STS Display Field Varchar2(10)  
Last Transfer Date APAPLV.LAST_TRANSFER_DT Display Field

Date DD/MM/YYYY

  
Access and Equity Details Highest Ranked Transfer Date APAPLV.AEC_HIGH_RANK_TRNSFR_STS Display Field Varchar2(10)  
Pref No APAPLV.PREFERENCE_NUMBER Display Field Number 90  
Course Preference Details APAPCADV.COURSE_PREFERENCE_DETAILS Display Field Varchar2(4000) Unit Details will be added to COURSE_PREFERENCE_DETAILS field in the APAPCADV view
Preference Transfer Status APAPLV.APCA_TRANSFER_STS Display Field Varchar2(10)  
Unit Set Transfer Status APAPLV.APCAUS_TRANSFER_STS Display Field Varchar2(10)  

 

Last Modified on 22-Mar-2007 9:14 AM

History Information

Release Version Project Change to Document
10.0.0.0.0.0 1231 - eAdmissions - Applicant Portal 3 Added Activity and Email Log buttons and descriptions, System Application Type field and description and modified Course Preference details
9.1.0.0.0.0 1221 - eAdmissions - Applicant Portal 2 New form