PNLGRPNAMEFPMPNLGRP_VW(SQL View) |
Index Back |
|---|---|
Panel Group Definition View |
| SELECT P.PNLGRPNAME , P.MARKET , M.MENUNAME , M.ITEMLABEL FROM PSPNLGRPDEFN P , PSMENUITEM M WHERE P.PNLGRPNAME = M.PNLGRPNAME AND P.MARKET = M.MARKET AND P.SEARCHRECNAME IN ('EMPLMT_SRCH_FRA', 'EMPLMT_SRCH_GBL', 'PERS_SRCH_FRA', 'PERS_SRCH_GBL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 4 | ITEMLABEL | Character(30) | VARCHAR2(30) NOT NULL | Menu Item Label |