SCC_COMPMENUSEC

(SQL View)
Index Back

Menu Item


SELECT DISTINCT A.OPRID , E.PNLGRPNAME , D.MENUNAME , D.BARNAME , D.BARITEMNAME , D.PNLITEMNAME , E.SUBITEMNUM , D.DISPLAYONLY , D.AUTHORIZEDACTIONS FROM PSOPRDEFN A , PSROLECLASS B , PSROLEUSER C , PSAUTHITEM D , PS_SCC_COMPMENUBAR E WHERE B.ROLENAME = C.ROLENAME AND A.OPRID = C.ROLEUSER AND B.CLASSID = D.CLASSID AND D.MENUNAME = E.MENUNAME AND D.BARNAME = E.BARNAME AND D.BARITEMNAME = E.BARITEMNAME AND D.PNLITEMNAME = E.PNLITEMNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

4 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
5 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
6 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
7 SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number
8 DISPLAYONLY Number(1,0) SMALLINT NOT NULL Display Only
9 AUTHORIZEDACTIONS Number(10,0) DECIMAL(10) NOT NULL Authorized Actions for Panels