PSPERMNAVCLS_VW

index back

Perm. Used as Nav. Homepage

This SQL view provides a list of all Permission Lists in use as a Navigator Homepage 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 Navigator Homepage Permissions List.
SELECT DISTINCT DEFAULTNAVHP , COUNT(*) FROM PSOPRDEFN WHERE DEFAULTNAVHP <> ' ' GROUP BY DEFAULTNAVHP

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