PSPERMROWCLS_VW

index back

Permlist used for Data Perm.

This SQL view provides a list of all Permission Lists in use as a Data 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 Data Permissions Permissions List.
SELECT DISTINCT ROWSECCLASS , COUNT(*) FROM PSOPRDEFN WHERE ROWSECCLASS <> ' ' GROUP BY ROWSECCLASS

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