PSTREEMGRNAV_VW

index back

SELECT DISTINCT A.MENUNAME , A.BARNAME , A.ITEMNAME MenuItem , A.ITEMLABEL MenuItemLabel ,A.PNLGRPNAME Component ,B.PNLNAME PanelName , %Substring(B.ITEMNAME,1,18) PageName , B.ITEMLABEL PageLabel FROM PSMENUITEM A , PSPNLGROUP B WHERE A.ITEMTYPE = 5 AND B.HIDDEN = 0 AND B.PNLGRPNAME = A.PNLGRPNAME AND A.MARKET = B.MARKET

PeopleSoft Field NameField TypeColumn TypeDescription
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLItem Name
ITEMLABELCharacter(30)VARCHAR2(30) NOT NULLMenu Item Label
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
PAGE_NAMECharacter(18)VARCHAR2(18) NOT NULLPage Name
PAGELABELCharacter(30)VARCHAR2(30) NOT NULLPage Label
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19