OPRIDREQUESTOR_IDJRNL_AF_RID_VW(SQL View) |
Index Back |
|---|---|
Jrnl Requester Prompt For AFJournal Requester Prompt For AF Setting the OPRID field as the first key will force the component processor to auto filter out the data per the current sign-in user ID. |
| SELECT DISTINCT J.OPRID , J.REQUESTOR_ID , K.OPRDEFNDESC FROM PS_JRNL_AF_SRCH_VW J , PSOPRDEFN K WHERE J.REQUESTOR_ID=K.OPRID |
| # | 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 | REQUESTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 3 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |