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 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