PSPERMROLCLS_VW

index back

Permission used in Roles

This SQL view provides a list of all Permission Lists in use in Role Definitions (PSROLECLASS). It is used by the Purge_Permlist page to prevent the deletion of a Permissions List if it is currently in use in one or more Role Definitions
SELECT DISTINCT CLASSID , COUNT(*) FROM PSROLECLASS WHERE CLASSID <> ' ' GROUP BY CLASSID

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