| # |
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 |
TRANSACTION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction ID
|
| 3 |
CONFIG_CRITERIA_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Configurable Criteria Code
|
| 4 |
CRITERIA_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
A value for criteria code that will be used to match people with Service Orders or Call Center Cases.
|
| 5 |
FROM_CRIT_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
From Criteria Value
|
| 6 |
TO_CRIT_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
To Criteria Value
|
| 7 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 8 |
TERRITORY_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Territory ID
|
| 9 |
ASSIGN_WEIGHT |
Number(2,0) |
SMALLINT NOT NULL |
Assignment Weight
|