My Oracle Support Banner

What is the Best Approach For Deleting or Changing Common Attribute Framework, or CAF, Values in Common Attributes? (Doc ID 2360195.1)

Last updated on AUGUST 03, 2018

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Some criteria has recently changed, and functional users have requested that the CAF values that are no longer applicable be inactivated with an effective date so as to make them unselectable by admissions staff from this point onward. No such functionality appears available at the level of the CAF Value Setup, which appears to present only the option to add or delete Ad Hoc values via the '-' and '+' buttons. There is concern about proceeding to delete CAF Values or rename CAF Values where the original CAF values remain present (e.g. on applicant evaluations).

Is the appropriate level for this kind of change at the Record Context level, where there is an option to change the status of individual Attributes to Active or Inactive? We are testing with replacing the original Common Attribute with a new Common Attribute similar to the original, but minus the undesired CAF Values, adding the new Common Attribute with Active row to the Record Context attributes, changing the original to Inactive, and incrementing the attribute sequence of the new Common Attribute by one. It appears to work without negatively impacting the original CAF values on past records (e.g. applicant evaluations).

What is the best approach for deleting or changing CAF values so as to avoid orphaning of data?

Also, the approach of of defining a new field with translate values, and excluding undesired values going forward appears more flexible than the first approach, whereby a new attribute must be created for each iteration.  This takes care of value removal from the list of selectable values. When asked to add new values for selection, is the solution to simply add additional translate values to the field?
 

Solution

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
Goal
Solution


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