PSPERMNAVCLS_VW - Perm. Used as Nav. Homepage

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