PSPAGENAME_VW

(SQL View)
Index Back

SELECT MENUNAME , BARNAME , B.ITEMNAME , A.ITEMNAME FROM PSPNLGROUP A , PSMENUITEM B WHERE A.PNLGRPNAME = B.PNLGRPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
2 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
3 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
4 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name