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 NameField TypeColumn TypeDescription
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19