SCCPS_TOOL_MENUPrompt Table: SCCPS_MENU_VW
SCCPS_TOOL_BARNAMEPrompt Table: SCCPS_MBAR_VW
SCCPS_TOOL_ITEMSCCPS_TOOL_PAGELANGUAGE_CDSCCPS_MPAGE_LNG(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 ,D.LANGUAGE_CD ,D.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C , PSPNLDEFNLANG 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,D.LANGUAGE_CD, 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |