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