RSEC_CF_MENU_VW

(SQL View)
 Index Back

View of config search menu's

View of config search menu's used for application security.

SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , C.ITEMNAME , B.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C , PS_RB_FILTER_DEFN D WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET AND C.PNLGRPNAME = D.PNLGRPNAME AND C.MARKET = D.MARKET AND C.PNLNAME = D.PNLNAME AND D.RSEC_APP_SCRTY_FLG = 'Y'

  • Related Language Record: RSEC_DMN_LNG_VW

    • # 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 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    4 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description