PSPERMPFLCLS_VW - Permlist used in Proc. Profile

PSPERMPFLCLS_VW	index back
Permlist used in Proc. Profile

This SQL view provides a list of all Permission Lists in use as a Process Profile 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 Process Profile Permissions List.

SELECT DISTINCT PRCSPRFLCLS , COUNT(*) FROM PSOPRDEFN WHERE PRCSPRFLCLS <> ' ' GROUP BY PRCSPRFLCLS

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