SCC_SM_MENUITEM(SQL View) |
Index Back |
|---|---|
used by external search match |
| SELECT M.MENUNAME , M.BARNAME , M.PNLGRPNAME , G.MARKET , G.PNLNAME FROM PSMENUITEM M INNER JOIN PSPNLGROUP G ON M.PNLGRPNAME = G.PNLGRPNAME WHERE G.PNLGRPNAME IN ('SCC_BIO_DEMO','ADM_PROSPECT_PROG','ADM_APPL_ENTRY1','QUICK_ADMIT','PERSONAL_DATA') AND G.SUBITEMNUM IN ( SELECT MIN(G1.SUBITEMNUM) FROM PSPNLGROUP G1 WHERE G1.PNLGRPNAME = G.PNLGRPNAME AND G1.MARKET = G.MARKET AND G1.HIDDEN = 0) |
| # | 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 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 5 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |