# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
DISCOBJECTID1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Disconnected Object ID 1
|
2 |
DISCOBJECTID2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Disconnected Object ID 2
|
3 |
DISCOBJECTID3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Disconnected Object ID 3
|
4 |
SEQUENCENO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence Number
|
5 |
DBID |
Character(32) |
VARCHAR2(32) NOT NULL |
DBID
|
6 |
PTNEXTVALUE |
Number(9,0) |
DECIMAL(9) NOT NULL |
PeopleTools Next Value
|
7 |
PTMAXVALUE |
Number(9,0) |
DECIMAL(9) NOT NULL |
PeopleTools Max Value
|
8 |
ACTIVEFLAG |
Number(1,0) |
SMALLINT NOT NULL |
Index Active
|
9 |
ISCOMPLETED |
Number(1,0) |
SMALLINT NOT NULL |
IS Completed
|