OPRIDAWDNTFDTL_OPVW(SQL View) |
Index Back |
|---|---|
Award Notif Dtl Operator ViewThis view lists oprids that are authorized to use the award notification detail page. |
| SELECT DISTINCT A.OPRID FROM PSOPRDEFN A , PSAUTHITEM B , PSPNLGROUP C WHERE B.CLASSID = A.OPRCLASS AND B.MENUNAME = 'PACKAGE_AID' AND B.BARNAME = 'USE' AND B.BARITEMNAME = 'AWARD_NOTIF_DETAIL' AND C.PNLGRPNAME = 'AWARD_NOTIF_DETAIL' AND C.PNLNAME = 'AWARD_NOTIF_DETAIL' AND C.HIDDEN = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |