PSPERMOPRCLS_VW

index back

Process Profile Permlist used

This SQL view provides a list of all Permission Lists in use as a Primary Permissions List. It is used by the Purge_Permlist page to prevent the deletion of a Permissions List if it is currently in use as a Primary Permissions List.
SELECT DISTINCT OPRCLASS , COUNT(*) FROM PSOPRDEFN WHERE OPRCLASS <> ' ' GROUP BY OPRCLASS

PeopleSoft Field Name Field Type Column Type Description
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19