UPG_CM_USE_TMP1

(SQL Table)
Index Back

UPG_CM_USE_TMP1

UPG_CM_USE_TMP1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
3 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date
4 CM_USE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID
5 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
6 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object
7 BO_REL_POSITION Character(1) VARCHAR2(1) NOT NULL This field describes the position of a Relationship pertaining to a BO. i.e. - To identify a BO in a relationship, BO_REL_ID and BO_REL_POSITION give you the relative position F = First, S = Second.
F=First Position
S=Second Postion
8 BO_CM_USE_TYPE Character(1) VARCHAR2(1) NOT NULL Use type of a Busines Object's Contact Method.
E=Business Object Relationship
R=Business Object Role
U=Contact Method Usage
9 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use
10 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes