index back

Old Role User Table

As part of the upgrade to 8.1 user profile data model, the roleuser field is being set to the oprid field. So previous rolexlatopr.roleuser values may be lost. This table contains the previous values of these potentially lost roleusers. It is intended to be used by application upgrade scripts to set roleuser values in app tables to oprid. For example, if an app table, say APP_RU_TBL, contains the field ROLEUSER, the following upgrade script should be run: UPDATE PS_APP_RU_TBL SET ROLEUSER = (SELECT OPRID FROM PS_ROLEXLATOPR_OLD WHERE ROLEUSER = PS_APP_RU_TBL.ROLEUSER) WHERE ROLEUSER IN (SELECT ROLEUSER FROM PS_ROLEXLATOPR_OLD) This table may be dropped after all upgrade is complete.

PeopleSoft Field Name Field Type Column Type Description
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20