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 |