My Oracle Support Banner

Request to Change Source of SAD_UC_QUALTYPE for IvStarPQR Data (Doc ID 2780709.1)

Last updated on MAY 31, 2021

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The existing delivered UCAS data import populates SAD_UC_QUALTYPE for ivStarPQR from a manually-maintained mapping table at Set Up SACR > Product Related > Recruiting and Admissons > UCAS > Mappings > Exam Levels
The mapped value is a 20-char upper case text field, whereas both SAD_UC_FRMQUAL.SAD_UC_QUALTYPE and SAD_UC_EXAM.SAD_UC_EXAMTEXT are 250-character mixed-case text fields.
With nearly 700 Exam Levels imported from UCAS, our users would rather the import populated SAD_UC_QUALTYPE for ivStarPQR records from the UCAS-supplied description in SAD_UC_EXAM.SAD_UC_EXAMTEXT rather than manually populate SAD_UC_EXAM.SAD_UC_QUALTYPE to attempt to convey similar information.


The issue can be reproduced at will with the following steps:
1. Manually maintain mapping table
2. Import data from a manually maintained table

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.