USERIDPNLGRPNAMEMENUNAMEPrompt Table: PSMENUDEFN
BARNAMEBARITEMNAMESCC_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 |