SETIDASSN_OPRIDACT_ASSNOPR_VW(SQL View) |
Index Back |
|---|---|
Assigned Operator View |
| SELECT DISTINCT A.SETID , A.OPRID , B.OPRDEFNDESC FROM PSOPRDEFN B , PSOPRALIAS A WHERE A.OPRID = B.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ASSN_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels. |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |