PSTREEPAGEVW (SQL View)	Index Back
Tree Structure List of Pages View that lists all visible pages that can be used by the Tree Manager Structure Maintenance component

PSTREEPAGEVW

(SQL View)

Tree Structure List of Pages

View that lists all visible pages that can be used by the Tree Manager Structure Maintenance component

SELECT DISTINCT PNLNAME ,PNLGRPNAME FROM PSPNLGROUP WHERE HIDDEN <> 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
2	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name