PSTREECMPNODVW

(SQL View)
 Index Back

Tree Struct Component Pr0mpt

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 NODE_PNLNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Panel/Page name
2 NODE_PNLGRPNAME Character(50) VARCHAR2(50) NOT NULL Node Component Name