PSPERMROWCLS_VW - Permlist used for Data Perm.

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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

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