# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
REL_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Relationship Type ID
|
2 |
BO_ID_1 |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID 1
|
3 |
ROLE_TYPE_ID_1 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
4 |
BO_ID_2 |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID 2
|
5 |
ROLE_TYPE_ID_2 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
|
6 |
START_DT |
Date(10) |
DATE |
Start date field to store start date value.
|
7 |
END_DT |
Date(10) |
DATE |
This field stores the end date values.
|
8 |
BO_REL_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Relationship ID of a Business Object
|
9 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|