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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19