PSPERMNAVCLS_VW

(SQL View)
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 PeopleSoft Field Type Database Column Type Description
1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number