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