UPG_BO_REL_TMP

(SQL Table)
Index Back

UPG_CDM BO_REL_TEMP

UPG_BO_REL_TMP - Used in CDM Upgrade AE Program as a Temp Table.

# 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.