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