SCCPS_TOOL_MENUPrompt Table: SCCPS_MENU_VW
SCCPS_TOOL_BARNAMEPrompt Table: SCCPS_MBAR_VW
SCCPS_TOOL_ITEMSCCPS_TOOL_PAGESCCPS_MPAGE_VW(SQL View) |
Index Back |
|---|---|
Pop Select Page ViewView of the Peopletools menu page rows translated to the pop select field names to support prompting. |
| SELECT A.MENUNAME ,A.BARNAME ,A.ITEMNAME ,C.PNLNAME ,A.MARKET ,D.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C , PSPNLDEFN D WHERE A.MARKET <> ' ' AND A.PNLGRPNAME = B.PNLGRPNAME AND B.PNLGRPNAME = C.PNLGRPNAME AND C.PNLNAME = D.PNLNAME GROUP BY A.MENUNAME ,A.BARNAME ,A.ITEMNAME,C.PNLNAME,A.MARKET ,D.DESCR |
| # | 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 | SCCPS_TOOL_PAGE |
Character(30) | VARCHAR2(30) NOT NULL | Pop Select tool page name field. Used for transfering to the tool's edit page. |
| 5 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |