OPRIDCB_USER_SEC_VW(SQL View) |
Index Back |
|---|---|
Secured users for Claimback |
| SELECT DISTINCT A.OPRID , A.OPRDEFNDESC , D.MENUNAME , D.BARNAME , D.BARITEMNAME , D.PNLITEMNAME , E.PAGEACCESSDESCR , D.DISPLAYONLY FROM PSOPRDEFN A , PSROLECLASS B , PSROLEUSER C , PSAUTHITEM D , PSPGEACCESSDESC E WHERE B.ROLENAME = C.ROLENAME AND A.OPRID = C.ROLEUSER AND B.CLASSID = D.CLASSID AND D.MENUNAME = 'CB_CONTRACT' AND D.AUTHORIZEDACTIONS = E.AUTHORIZEDACTIONS AND D.BARNAME = 'USE' AND D.BARITEMNAME = 'CB_CONTRACT' AND E.PAGEACCESSDESCR LIKE '%Update%' AND D.PNLITEMNAME = 'CB_HDR' |
| # | 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 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see 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 | PAGEACCESSDESCR | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 8 | DISPLAYONLY | Number(1,0) | SMALLINT NOT NULL | Display Only |