SCCPS_MBAR_VW (SQL View)	Index Back
Pop Select menu bar view View of the Peopletools menu bar rows translated to the pop select field names to support prompting.

SCCPS_MBAR_VW

(SQL View)

Pop Select menu bar view

View of the Peopletools menu bar rows translated to the pop select field names to support prompting.

SELECT MENUNAME ,BARNAME ,MARKET ,BARLABEL FROM PSMENUITEM WHERE MARKET <> ' ' GROUP BY MENUNAME ,BARNAME ,MARKET ,BARLABEL

# 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: PSMENUDEFN

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.

3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
Default Value: GBL

4 BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label

#	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: PSMENUDEFN
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.
3	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market Default Value: GBL
4	BARLABEL	Character(10)	VARCHAR2(10) NOT NULL	Menu Bar Label