PSNAVMEMBER_VW - Navigator Homepage Membership

PSNAVMEMBER_VW	index back
Navigator Homepage Membership

This SQL view lists all of the user profiles using this Permissions List as a Navigator Homepage Permissions List

SELECT A.DEFAULTNAVHP , A.OPRID ,A.OPRDEFNDESC FROM PSOPRDEFN A WHERE A.DEFAULTNAVHP <> ' '

PeopleSoft Field Name Field Type Column Type Description

CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

DESCR Character(30) VARCHAR2(30) NOT NULL Description

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).
OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description