RSEC_STAT_MN_VW

(SQL View)
 Index Back

View of component descriptions

View of component descriptions related to a menu.

SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , C.ITEMNAME , B.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET

  • Related Language Record: RSEC_SMN_LNG_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

    Prompt Table: RSEC_MENU_VW1

    3 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: RSEC_MENU_VW2

    4 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name

    Prompt Table: RSEC_MENU_VW1

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description