PSTREECMPLVLVW (SQL View)	Index Back
Tree Struct Component Prompt Prompt view used by Tree Structure Definition component

PSTREECMPLVLVW

(SQL View)

Tree Struct Component Prompt

Prompt view used by Tree Structure Definition component

SELECT DISTINCT %Substring(PNLNAME,1,18) ,PNLGRPNAME FROM PSPNLGROUP WHERE HIDDEN <> 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEVEL_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Level Panel/Page name

2 LEVEL_PNLGRPNAME Character(50) VARCHAR2(50) NOT NULL Level Component Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEVEL_PNLNAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Level Panel/Page name
2	LEVEL_PNLGRPNAME	Character(50)	VARCHAR2(50) NOT NULL	Level Component Name