# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
2 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
|
3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
4 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
6 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
7 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
8 |
ALL_SETID |
Character(1) |
VARCHAR2(1) NOT NULL |
All Item SetIDs
|
9 |
ALL_EIP_CTL_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
All EIP_CTL_IDs
|
10 |
EIP_CTL_ID_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
|
11 |
EIP_CTL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
|
12 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
13 |
RTE_FROM_VAL_1 |
Number(5,0) |
INTEGER NOT NULL |
RTE_FROM_VAL_1
|
14 |
RTE_TO_VAL_1 |
Number(5,0) |
INTEGER NOT NULL |
RTE_TO_VAL_1
|
15 |
RTE_FROM_VAL_2 |
Number(5,0) |
INTEGER NOT NULL |
RTE_FROM_VAL_2
|
16 |
RTE_TO_VAL_2 |
Number(5,0) |
INTEGER NOT NULL |
RTE_TO_VAL_2
|
17 |
AE_APPL_ABORT |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Application Abort Indicator
|
18 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|