BN_MNUPNLGRP_VW

(SQL View)
 Index Back

Panel Group Definition view

This is a view of all PanelGroups under a Menu Item, and is used as a prompt table when defining Simple Benefit Plan.

SELECT DISTINCT M.MENUNAME , P.PNLGRPNAME , P.DESCR FROM PSMENUITEM M , PSPNLGRPDEFN P WHERE P.PNLGRPNAME = M.PNLGRPNAME

  • Related Language Record: BN_MNUPNGRP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description