PIM_PREF_USR_VW

(SQL View)
 Index Back

PIM Users in Prefenence

This view shows all the users with PIM Preference defined

SELECT A.PIM_DEFAULT_ID , A.OPRID FROM PS_OPR_DEF_TBL_RB A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIM_PREF_ID Character(10) VARCHAR2(10) NOT NULL Used by PIM Preference
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: PIM_OPRID_VW