RBP_USERS_VW

(SQL View)
Index Back

PIM Users

This view is used to the get the person id for a PIM user.

SELECT A.OPRID FROM PSOPRALIAS A WHERE A.OPRALIASTYPE = 'PER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID