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 NameField TypeColumn TypeDescription
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
SEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19