PSDATAMEMBER_VW

index back

Data Permissions Membership

This SQL view lists all of the user profiles using this Permissions List as a Data Security (ROWSECCLASS) Permissions List
SELECT A.ROWSECCLASS , A.OPRID ,A.OPRDEFNDESC FROM PSOPRDEFN A WHERE A.ROWSECCLASS <> ' '

PeopleSoft Field Name Field Type Column Type Description
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19