BARITEMNAMEPV_AUTHORIZE_VW(SQL View) |
Index Back |
|---|---|
PERMISSION LIST AUTHORIZATIONPERMISSION EPPV1000 LIST AUTHORIZATION |
| SELECT DISTINCT A.ROLEUSER ,B.BARITEMNAME ,B.DISPLAYONLY ,B.AUTHORIZEDACTIONS FROM PSROLEUSER A , PSROLECLASS E , PSROLEDEFN C ,PSAUTHITEM B WHERE A.ROLENAME = C.ROLENAME AND C.ROLENAME = E.ROLENAME AND E.CLASSID = B.CLASSID AND B.MENUNAME = 'PV_MOB_MENU' AND B.BARITEMNAME IN ('PV_MOB_855_CMP','PV_MOB_855_MNG','PV_MOB_CHNGRQST_FL','PV_MOB_CHNGTRAK_FL', 'PV_MOB_RCV_TSF2_FL','PV_MOB_RCV_TSFR_FL', 'PV_MOB_RECV_POW_FL','PV_MOB_RECV_UPD_FL','PV_MOB_RTV_UPD_FL', 'PV_MOB_PREF_FL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BARITEMNAME |
Character(30) | VARCHAR2(30) NOT NULL | Bar Item Name |
| 3 | DISPLAYONLY | Number(1,0) | SMALLINT NOT NULL | Display Only |
| 4 | AUTHORIZEDACTIONS | Number(10,0) | DECIMAL(10) NOT NULL | Authorized Actions for Panels |