EOPM_REFWLIB_VW

(SQL View)
 Index Back

EOPM Class reference by menu


SELECT DISTINCT A.MENUNAME , A.BARNAME , A.BARITEMNAME , ' ' , ' ' , A.CLASSID FROM PSAUTHITEM A WHERE A.MENUNAME LIKE 'WEBLIB%' UNION SELECT ' ' , ' ' , ' ' , ' ' , EOPM_ORIGINNAME , CLASSID FROM PS_EOPM_PERMORIGIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

2 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
3 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
4 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
5 EOPM_ORIGINNAME Character(30) VARCHAR2(30) NOT NULL origininal name of permission lists, roles or menus that were cloned or renmaed
6 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).