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.
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
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