OPR_PO_RQSTR(SQL Table) |
Index Back |
|---|---|
Requestors Opr Authorized For |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | REQUESTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: REQUESTOR_VW |
| 3 | ADD_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Add Authority
Y/N Table Edit Default Value: Y |
| 4 | UPDATE_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Update Authority
Y/N Table Edit Default Value: Y |
| 5 | CLOSE_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Authority
Y/N Table Edit Default Value: Y |
| 6 | DELETE_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Delete Authority
Y/N Table Edit Default Value: N |
| 7 | CLOSE_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Close Authority
Y/N Table Edit Default Value: N |
| 8 | REOPEN_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Reopen Authority
Y/N Table Edit Default Value: N |