PSMENUBAR_VW

(SQL View)
Index Back

Menu Item View


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

  • Parent record: PSMENUDEFN_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: 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