PSPRCSMEMBER_VW

(SQL View)
 Index Back

Proc. Profile Perm. Membership

This SQL view lists all of the user profiles using this Permissions List as a Process Profile Permissions List

SELECT A.PRCSPRFLCLS , A.OPRID ,A.OPRDEFNDESC FROM PSOPRDEFN A WHERE A.PRCSPRFLCLS <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description