SCC_NUR_MBAR_VW

(SQL View)
Index Back

nur menu bar view

View of the Peopletools menu bar rows

SELECT MENUNAME ,BARNAME ,MARKET ,BARLABEL FROM PSMENUITEM WHERE MARKET <> ' ' GROUP BY MENUNAME ,BARNAME ,MARKET ,BARLABEL

# 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 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

4 BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label