SCCPS_TOOL_MENUPrompt Table: SCCPS_MENU_VW
SCCPS_TOOL_BARNAMEPrompt Table: SCCPS_MBAR_VW
SCCPS_TOOL_ITEMDefault Value: GBL
SCCPS_MITEM_VW(SQL View) |
Index Back |
|---|---|
Pop Select Menu Item ViewView of the Peopletools menu item rows translated to the pop select field names to support prompting. |
| SELECT MENUNAME ,BARNAME ,ITEMNAME ,MARKET ,ITEMLABEL FROM PSMENUITEM WHERE MARKET <> ' ' GROUP BY MENUNAME ,BARNAME ,ITEMNAME,MARKET ,ITEMLABEL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCCPS_TOOL_MENU |
Character(30) | VARCHAR2(30) NOT NULL |
Pop Select tool menu name field. Used for transfering to the tool's edit page.
Prompt Table: SCCPS_MENU_VW |
| 2 | SCCPS_TOOL_BARNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Pop Select tool bar name field. Used for transfering to the tool's edit page.
Prompt Table: SCCPS_MBAR_VW |
| 3 | SCCPS_TOOL_ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Pop Select tool item name field. Used for transfering to the tool's edit page. |
| 4 | MARKET | Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
| 5 | ITEMLABEL | Character(30) | VARCHAR2(30) NOT NULL | Menu Item Label |