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

PSTREECMPDTLVW

(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 DTL_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Panel/Page name

2 DTL_PNLGRPNAME Character(50) VARCHAR2(50) NOT NULL Component Name used to maintain detail values in tree

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DTL_PNLNAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Detail Panel/Page name
2	DTL_PNLGRPNAME	Character(50)	VARCHAR2(50) NOT NULL	Component Name used to maintain detail values in tree