19Schema Changes for Oracle Customer Hub (UCM) Version 8.2

Schema Changes for Oracle Customer Hub (UCM) Version 8.2

This chapter contains information about table column changes in the schema for Oracle Customer Hub (UCM) version 8.2. It contains the following topic:

• Schema Changes for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014

• Modified Tables for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014.

• New Tables for Oracle Customer Hub (UCM) Version 8.2

• Modified Tables for Oracle Customer Hub (UCM) Version 8.2

• Modified Tables for Oracle Customer Hub (UCM) Version 8.2

Schema Changes for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014

The following topics list schema changes made as part of Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014.

• New Tables for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014

• Modified Tables for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014

New Tables for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014

The following new tables were added as part of Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014.

• S_CONSMPROF_UPD Table

• S_UCM_CN_SMPROF Table

• S_UCM_CN_SMATTR Table

• S_CIF_SMPROFMAP Table

• S_CIF_SMATTRMAP Table

S_CONSMPROF_UPD Table

The following table shows details for the new S_CONSMPROF_UPD table which is used to configure survivorship attribute settings for Contact Social Media Profile entity records.

Table S_CONSMPROF_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
CON_SM_PROF_ID	Varchar (15)	Required. The child entity row ID.
FLD_VAL_RULE_ID	Varchar (15)	Field value row ID.
EXT_SYS_ID	Varchar (15)	Required. External system ID.
LAST_MOD_TS	UTC Date Time (7)	Last modified date.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_UCM_CN_SMPROF Table

The following table shows details for the new S_UCM_CN_SMPROF source data history (SDH) table which is used to provide support for Social Media Profile data.

Table S_UCM_CN_SMPROF table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Siebel system field.
CONFLICT_ID	Varchar (15)	Siebel system field.
CREATED	UTC Date Time (7)	Siebel system field.
CREATED_BY	Varchar (15)	Siebel system field.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field.
MODIFICATION_NUM	Number (22)	Siebel system field.
BV_LAST_UPD	UTC Date Time (7)	the last update date time of the best version record.
BV_LAST_UPD_BY	Varchar (15)	The last updated user login of the best version record.
EXT_SYST_ID	Varchar (15)	External system ID.
UCM_EXT_ID	Varchar (100)	The UCM external unique identifier.
UCM_EXT_LOGIN	Varchar (30)	External user login.
UCM_EXT_UPD_TS	UTC Date Time (7)	The last updated date of the external system.
UCM_TXN_DESC	Varchar (250)	The UCM transaction description.
UCM_TYPE_CD	Varchar (30)	The status or type of the record.
UCM_UID	Varchar (100)	The UCM unique identifier.
CON_SM_PROF_ID	Varchar (15)	The best version ID. A null value means the child record is unlinked.
UCM_CONTACT_ID	Varchar (15)	The parent UCM contact ID.
CONTACT_ID	Varchar (15)	The BV parent contact ID.
AUTHOR1_ID_VAL	Varchar (255)	The author ID value provided by a data provider or a social integrator.
AUTHOR_LINK_URL	Varchar (500)	The unique URL of the author profile on a social media site.
AUTHOR_NAME	Varchar (100)	The unique user name of the contact on a specific social media site (such as Twitter or Facebook). For example: @user_name. This author name is unique within the social media site.
CHANNEL_CD	Varchar (30)	A social media channel such as Facebook or Twitter which is associated with a contact or person.
SUPPRESS_PROF_FLG	Character(1)	The flag indicates whether social profile attributes for a specific profile or author from a given social media channel are retrieved.

S_UCM_CN_SMATTR Table

The following table shows details for the new S_UCM_CN_SMATTR source data history (SDH) table which is used to provide support for Social Media Attribute data.

Table S_UCM_CN_SMATTR table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Siebel system field.
CONFLICT_ID	Varchar (15)	Siebel system field.
CREATED	UTC Date Time (7)	Siebel system field.
CREATED_BY	Varchar (15)	Siebel system field.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field.
MODIFICATION_NUM	Number (22)	Siebel system field.
BV_LAST_UPD	UTC Date Time (7)	The last update date time of the best version record.
BV_LAST_UPD_BY	Varchar (15)	The last updated user login of the best version record.
EXT_SYST_ID	Varchar (15)	External system ID.
UCM_EXT_ID	Varchar (100)	The UCM external unique identifier.
UCM_EXT_LOGIN	Varchar (30)	External user login.
UCM_EXT_UPD_TS	UTC Date Time (7)	The last updated date of the external system.
UCM_TXN_DESC	Varchar (250)	The UCM transaction description.
UCM_TYPE_CD	Varchar (30)	The status or type of the record.
UCM_UID	Varchar (100)	The UCM unique identifier.
CON_SM_ATTR_ID	Varchar (15)	The best version ID. A null value means the child record is unlinked.
UCM_CON_SM_PROF_ID	Varchar (15)	The parent UCM contact social media profile ID.
CON_SM_PROF_ID	Varchar (15)	The BV parent contact social media profile ID.
NAME	Varchar (100)	Attribute name of the profile recieved from a source system, such as: Follower, Tweets, Friends, Likes, Age, DoB, and so on.
SOURCE_CD	Varchar (30)	The source (data provider) through which the profile data, such as: Buzzient, Visible, Actionly, Hotsuite, and so on.
VALUE	Varchar (500)	Value for an attribute. For example, Name = Pradeep, Followers = 59, Friends = 150, and Likes = 2.

S_CIF_SMPROFMAP Table

The following table shows details for the new S_CIF_SMPROFMAP cross reference table which is used to provide support for Social Media Profile Cross Reference data.

Table S_CIF_SMPROFMAP table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Siebel system field.
CON_SMPROF_ID	Varchar 15)	Social Media Profile Best Version Record ID
CIF_EXT_SYST_ID	Varchar (15)	External System ID.
EXT_CON_SMPROF_ID1	Varchar (100)	First Cross Reference ID.
EXT_CON_SMPROF_ID2	Varchar (100)	Place holder for second cross reference ID.
EXT_CON_SMPROF_ID3	Varchar (100)	Place holder for third cross reference ID.
COMMENTS	Varchar (250)	Comments.
CONFLICT_ID	Varchar (15)	Siebel system field.
CREATED	UTC Date Time (7)	Siebel system field.
CREATED_BY	Varchar (15)	Siebel system field.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field.
MODIFICATION_NUM	Number (22)	Siebel system field.

S_CIF_SMATTRMAP Table

The following table shows details for the new S_CIF_SMATTRMAP cross reference table which is used to provide support for Social Media Profile Attribute Cross Reference data.

Table S_CIF_SMATTRMAP table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Siebel system field.
CON_SMATTR_ID	Varchar 15)	Social Media Profile Attribute Best Version Record ID.
CIF_EXT_SYST_ID	Varchar (15)	External System ID.
EXT_CON_SMATTR_ID1	Varchar (100)	First Cross Reference ID.
EXT_CON_SMATTR_ID2	Varchar (100)	Place holder for second cross reference ID.
EXT_CON_SMATTR_ID3	Varchar (100)	Place holder for third cross reference ID.
COMMENTS	Varchar (250)	Comments.
CONFLICT_ID	Varchar (15)	Siebel system field.
CREATED	UTC Date Time (7)	Siebel system field.
CREATED_BY	Varchar (15)	Siebel system field.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field.
MODIFICATION_NUM	Number (22)	Siebel system field.

Modified Tables for Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014

The following table was modified as part of Oracle Customer Hub (UCM) for Siebel Innovation Pack 2014.

S_CON_SM_PROF Table

The following table shows details of the S_CON_SM_PROF table which is used for Contact Social Media Profile entity records.

Table S_CON_SM_PROF table

Column Name	Data Type	Comments
START_DT	UTC Date Time (7)	Not required for child survivorship, but it is recommended you use this field if you are using the End Date field.
END_DT	UTC Date Time (7)	Used for survivorship to indicate an obsolete Contact Social Media Profile.

Schema Changes for Oracle Customer Hub (UCM) Version 8.2

The following topics list schema changes made as part of Oracle Customer Hub (UCM) version 8.2 (for Siebel CRM 8.1.1.10).

• New Tables for Oracle Customer Hub (UCM) Version 8.2

• Modified Tables for Oracle Customer Hub (UCM) Version 8.2

New Tables for Oracle Customer Hub (UCM) Version 8.2

The following new tables were added as part of Oracle Customer Hub (UCM) version 8.2 (for Siebel CRM 8.1.1.7 Quick Fix 07AN).

• S_CIF_ADDR_MAP Table

• S_CIF_CON_NM_MP Table

• S_CIF_CM_ADR_MP Table

• S_FLD_VAL_RULE Table

• S_FLD_CONF_LVL Table

• S_COMM_ADDR_UPD Table

• S_CON_NAME_UPD Table

• S_CON_IDNTY_UPD Table

• S_ASSET_UPD Table

• S_ADDR_PER_UPD Table

• S_PARTY_REL_UPD Table

• S_CIF_SMATTRMAP Table

S_CIF_ADDR_MAP Table

The following table shows details for the new S_CIF_ADDR_MAP table which is used for Address cross references.

Table S_CIF_ADDR_MAP table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Siebel system field.
ADDR_ID	Varchar (15)	Address best version record ID. The foreign key table is S_ADDR_PER.
CIF_EXT_SYST_ID	Varchar (15)	External system ID. The foreign key table is S_CIF_EXT_SYST.
EXT_ADDR_ID1	Varchar (100)	The first cross reference ID.
EXT_ADDR_ID2	Varchar (100)	Place holder for second cross reference ID.
EXT_ADDR_ID3	Varchar (100)	Place holder for third cross reference ID.
PAR_OBJTYPE_CD	Varchar (30)	Parent object type: Account, or Contact. The bounded LOV is :UCM_OBJECT_TYPE_CD.
COMMENTS	Varchar (250)	Comments.
CONFLICT_ID	Varchar (15)	Siebel system field.
CREATED	UTC Date Time (7)	Siebel system field.
CREATED_BY	Varchar (15)	Siebel system field.The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Siebel system field.

S_CIF_CON_NM_MP Table

The following table show details of the new S_CIF_CON_NM_MP table which is used for Name cross references.

Table S_CIF_CON_NM_MP table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
CON_NAME_ID	Varchar (15)	Required. The name of the best version record ID. The foreign key table is S_CONTACT_NAME.
CIF_EXT_SYST_ID	Varchar (15)	Required. The external system ID. The foreign key table is S_CIF_EXT_SYST.
EXT_CON_NAME_ID1	Varchar (100)	Required. The first cross reference ID.
EXT_CON_NAME_ID2	Varchar (100)	Place holder for second cross reference ID.
EXT_CON_NAME_ID3	Varchar (100)	Place holder for third cross reference ID.
COMMENTS	Varchar (250)	Comments.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Required. Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Siebel system field.

S_CIF_CM_ADR_MP Table

The following table shows details of the new S_CIF_CM_ADR_MP which is used for Communication Address (Email and Phone) cross references.

Table S_CIF_CM_ADR_MP table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
PER_COMM_ADDR_ID	Varchar (15)	Required. The communication address best version record ID. The foreign key table is S_PER_COMM_ADDR.
COMM_MEDIUM_CD	Varchar (30)	Required. Comm Medium Code. Comm Medium Code refers to the code for the communication media channel. Examples are email, ICQ, phone, and so on.
CIF_EXT_SYST_ID	Varchar (15)	Required. The external system ID. The foreign key table is S_CIF_EXT_SYST.
EXT_COMM_ADDR_ID1	Varchar (100)	Required. The first cross reference ID.
EXT_COMM_ADDR_ID2	Varchar (100)	The second cross reference ID.
EXT_COMM_ADDR_ID3	Varchar (100)	The third cross reference ID.
COMMENTS	Varchar (250)	Comments.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_FLD_VAL_RULE Table

The following table shows details for the new S_FLD_VAL_RULE table which contains field value rule definitions for all entities.

Table S_FLD_VAL_RULE table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
SEQ_NUM	Number (22)	The sequence number to set priority as required.
NAME	Varchar (100)	Rule name.
RULE_SET_ID	Varchar (30)	Not required. The foreign key table is S_UCM_RULE_SET.
COMP_FIELD_NAME	Varchar (75)	Field name for the comparison value of Type in a business address.
COMP_FIELD_VALUE	Varchar (140)	The values of the comparison column Business Personal.
COMP_RULE_CD	Varchar (75)	The comparison rule used for Source, Recent, Master, and External records.
STATUS_CD	Varchar (75)	Status. Values are active or inactive.
BUS_SERVICE_NAME	Varchar (75)	The external rule business service.
METHOD_NAME	Varchar (75)	The external rule business service method.
RULE_MODULE_NAME	Varchar (150)	The external rule module.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar(15)	Required. Siebel system field.
CREATED	UTC date time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_FLD_CONF_LVL Table

The following table shows details for the new S_FLD_CONF_LVL table which is used to set the child field rule confidence level in subscribed systems.

Table S_FLD_CONF_LVL table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
FLD_VAL_RULE_ID	Varchar (15)	Required. Field value row ID. The foreign key table is S_FLD_VAL_RULE.
EXT_SYS_ID	Varchar (15)	Required. The external system ID. The foreign key table is S_CIF_EXT_SYS.
CONFIDENCE_LVL	Number (22)	Confidence level expressed in a percentage.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Required. Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Siebel system field.

S_COMM_ADDR_UPD Table

The following table shows details for the new S_COMM_ADDR_UPD table which is used to configure survivorship attribute settings for the email and alternate phone entities.

Table S_COMM_ADDR_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
COMM_ID	Varchar (15)	Required. The entity row ID for the email and alternate phone fields. The foreign key table is S_PER_COMM_ADDR.
FLD_VAL_RULE_ID	Varchar (15)	Field value row ID. The foreign key table is S_FKD_VAL_RULE.
EXT_SYS_ID	Varchar (15)	The external system ID. The foreign key table is S_CIF_EXT_SYS.
LAST_MOD_TS	UTC Date Time (7)	Last modified date time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_CON_NAME_UPD Table

The following table shows details for the new S_CON_NAME_UPD table which is used to configure survivorship attribute settings for records associated with the name entity.

Table S_CON_NAME_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
NAME_ID	Varchar (15)	Required. The entity row ID for the name field. The foreign key table is S_CONTACT_NAME.
FLD_VAL_RULE_ID	Varchar (15)	The field value row ID. The foreign key table is S_FLD_VAL_RULE.
EXT_SYS_ID	Varchar (15)	The external system ID. The foreign key table is S_CIF_EXT_SYS.
LAST_MOD_TS	UTC Date Time (7)	The last modified date and time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_CON_IDNTY_UPD Table

The following table shows details for the new S_CON_IDNTY_UPD table which is used to configure survivorship attribute settings for identification entity records.

Table S_CON_IDNTY_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
IDENT_ID	Varchar (15)	Required. The entity row ID for the name field. The foreign key table is S_CON_IDNTY_DOC.
FLD_VAL_RULE_ID	Varchar (15)	Field value row ID. The foreign key table is S_FLD_VAL_RULE.
EXT_SYS_ID	Varchar (15)	External system ID. The foreign key table is S_CIF_EXT_SYS.
LAST_MOD_TS	UTC Date Time (7)	The last modified date and time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_ASSET_UPD Table

The following table shows details for the new S_ASSET_UPD table which is used to configure survivorship attribute settings for Financial Account entity records.

Table S_ASSET_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
ASSET_ID	Varchar (15)	Required. The entity row ID for the financial account entity. The foreign key table is S_ASSET.
FLD_VAL_RULE_ID	Varchar (15)	Field value row ID. The foreign key table is S_FLD_VAL_RULE.
PAR_CON_ID	Varchar (15)	The parent row ID for the Contact table. The foreign key table is S_CONTACT.
PAR_ACCNT_ID	Varchar (15)	The parent row ID for the Account table. The foreign key table is S_ORG_EXT.
PAR_ORGGRP_ID	Varchar (15)	The row ID of the Household table. The foreign key table is S_ORG_GROUP.
LAST_MOD_TS	UTC Date Time (7)	The last modified date and time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_ADDR_PER_UPD Table

The following table shows details for the new S_ADDR_PER_UPD table which is used to configure survivorship attribute settings for Address entity records.

Table S_ADDR_PER_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
ADDR_ID	Varchar (15)	Required. The row ID of the Address object. The foreign key table is S_ADDR_PER.
FLD_VAL_RULE_ID	Varchar (15)	The field value row ID. The foreign key table is S_FLD_VAL_RULE.
PAR_CON_ID	Varchar (15)	The parent row ID for the Contact table. The foreign key table is S_CONTACT.
PAR_ACCNT_ID	Varchar (15)	The parent row ID for the Account table. The foreign key table is S_ORG_EXT.
PAR_ORGGRP_ID	Varchar (15)	The row ID of the Household table. The foreign key table is S_ORG_GROUP.
PAR_ASSET_ID	Varchar (15)	The parent row ID of the FINCORP Account table. The foreign key table is S_ASSET.
EXT_SYS_ID	Varchar (15)	The external system ID. The foreign key table is S_CIF_EXT_SYS.
LAST_MOD_TS	UTC Date Time (7)	The last modified date and time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_PARTY_REL_UPD Table

The following table shows details for the new S_PARTY_REL_UPD table which is used to configure survivorship attribute settings for address entity records.

Table S_PARTY_REL_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
ADDR_ID	Varchar (15)	Required. The row ID of the Address object. The foreign key table is S_ADDR_PER.
FLD_VAL_RULE_ID	Varchar (15)	The field value row ID. The foreign key table is S_FLD_VAL_RULE.
PAR_CON_ID	Varchar (15)	The parent row ID for the Contact table. The foreign key table is S_CONTACT.
PAR_ACCNT_ID	Varchar (15)	The parent row ID for the Account table. The foreign key table is S_ORG_EXT.
PAR_ORGGRP_ID	Varchar (15)	The row ID of the Household table. The foreign key table is S_ORG_GROUP.
PAR_ASSET_ID	Varchar (15)	The parent row ID of the FINCORP Account table. The foreign key table is S_ASSET.
EXT_SYS_ID	Varchar (15)	The external system ID. The foreign key table is S_CIF_EXT_SYS.
LAST_MOD_TS	UTC Date Time (7)	The last modified date and time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

S_PARTY_REL_UPD Table

The following table shows details for the new S_PARTY_REL_UPD table which is used to configure survivorship attribute data for affiliation entity records.

Table S_PARTY_REL_UPD table details

Column Name	Data Type	Comments
ROW_ID	Varchar (15)	Required. Siebel system field.
AFFLTN_ID	Varchar (15)	Required. Entity row ID for Affiliation. The foreign key table is S_PARTY_REL.
FLD_VAL_RULE_ID	Varchar (15)	The field value row ID. The foreign key table is S_FLD_VAL_RULE.
EXT_SYS_ID	Varchar (15)	The external system ID. The foreign key table is S_CIF_EXT_SYS.
LAST_MOD_TS	UTC Date Time (7)	Last modified date and time.
DESC_TXT	Varchar (250)	Description.
CONFLICT_ID	Varchar (15)	Required. Siebel system field.
CREATED	UTC Date Time (7)	Required. Siebel system field.
CREATED_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
DB_LAST_UPD	UTC Date Time (7)	Required. Siebel system field.
DB_LAST_UPD_SRC	Varchar (50)	Siebel system field.
LAST_UPD	UTC Date Time (7)	Siebel system field.
LAST_UPD_BY	Varchar (15)	Required. Siebel system field. The foreign key table is S_USER.
MODIFICATION_NUM	Number (22)	Required. Siebel system field.

Modified Tables for Oracle Customer Hub (UCM) Version 8.2

The following tables were modified as part of Oracle Customer Hub (UCM) version 8.2 (for Siebel CRM 8.1.1.7 Quick Fix 07AN).

• S_UCM_ASSET Table

• S_CIF_AST_MAP Table

• S_CONTACT_NAME Table

• S_CONTACT_IDNTY_DOC Table

• S_CONTACT_UCMX Table

• S_CONTACT Table

• S_DYN_HRCHY Table

• S_PARTY_UCMX Table

• S_UCM_ADDR_PER Table

• S_UCM_ATGP_RULE Table

• S_UCM_CONTACT Table

• S_UCM_CON_CHILD Table

• S_UCM_HRCHY Table

• S_UCM_HRCHY_REL Table

• S_UCM_ORG_EXT Table

• S_UCM_ORGGRP Table

• S_UCM_RULE_SET Table

S_UCM_ASSET Table

The following table shows details of the S_UCM_ASSET table which is used for Financial Account Source Data and History (SDH).

Table S_UCM_ASSET table

Column Name	Data Type	Comments
ACCNT_CATEGORY_CD	Varchar (30)	The account category of a financial account. Example values include Asset, and Liability.
PAR_UCM_ACCNT_ID	Varchar (15)	Parent Oracle Customer Hub (UCM) Account ID. The foreign key table is S_UCM_ORG_EXT.
TRANSACTION_ID	Varchar	Oracle Customer Hub (UCM) asset for the S_ASSET table.

S_CIF_AST_MAP Table

The following table shows details of the S_CIF_AST_MAP table which is used for Financial Account cross references.

Table S_CIF_AST_MAP table

Column Name	Data Type	Comments
ACCNT_CATEGORY_CD	Varchar (30)	The account category of a financial account. Example values include Asset, and Liability.

S_CONTACT_NAME Table

The following table shows details of the S_CONTACT_NAME table.

Table S_CONTACT_NAME Table

Column Name	Data Type	Comments
CONTACT_ID	Varchar	Required. The foreign key table is S_CONTACT.
ROW_ID	Varchar	Required.
TYPE_CD	Varchar	Required. Values include Legal, Maiden, Diploma, and so on.
FST_NAME	Varchar	Person’s first name.
LAST_NAME	Varchar	Person’s last name.
MID_NAME	Varchar	Person’s middle name.
SECOND_LAST_NAME	Varchar	Optional. Second last name. Used for contacts with two last names.
FULL_NAME	Varchar	Required. Concatenation of first, middle, last, and second last name.
ALIAS_NAME	Varchar	Optional. Alternate name used by person.
NICK_NAME	Varchar	Optional. Person’s nickname.
PER_TITLE	Varchar	Personal Title. Values include Mr., Mrs., Dr., and so on.
PER_TITLE_SUFFIX	Varchar	Personal title suffix. Values include Esq., CPA, PhD, and so on.
PREF_FST_NAME	Varchar	Preferred first name.
HONORARY_TITLE	Varchar	Job title.
ROYAL_PREFIX	Varchar	Royal prefix. Rarely used, but it is required for royal contacts.
ROYAL_SUFFIX	Varchar	Royal suffix. Rarely used, but it is required for royal contacts.
EFF_START_DT	Date	Required. Effective start date. The default value is created date, but this value can be overwritten.
EFF_END_DT	Date	Effective end date.
CNTRY_FORMAT_MASK	Varchar	Country name format.

S_CONTACT_IDNTY_DOC Table

The following table shows details of the S_CONTACT_IDNTY_DOC table.

Table S_CONTACT_IDNTY_DOC table

Column Name	Data Type	Comments
ROW_ID	Varchar	Required.
CONTACT_ID	Varchar	Required. Contact ID. The foreign key table is S_CONTACT.
ISS_COUNTRY_CD	Varchar	Country code.
ISS_STATE_CD	Varchar	State code.
TYPE_CD	Varchar	Required. National ID type, such as passport, driver’s license, and so on.
IDENTITY_DOC_NUM	Varchar	Required. National ID. By default, this is not encrypted.
EFF_START_DT	Date	Required. Effective start date. The default value is created date, but this value can be overwritten.
EFF_END_DT	Date	Effective end date.

S_CONTACT_UCMX Table

The following table shows details of the S_CONTACT_UCMX table.

Table S_CONTACT_UCMX table

Column Name	Data Type	Comments
PR_NAME_ID	Varchar	Primary name ID. The foreign key table is S_CONTACT_NAME.
PR_IDENTITY_ID	Varchar	Primary Student ID. The foreign key table is S_CON_IDNTY_DOC.
CLASS_YEAR	Number	Graduation year. Current projected graduation year or latest graduation year for alumni.

S_CONTACT Table

The following table shows details of the S_CONTACT table.

Table S_CONTACT table

Column Name	Data Type	Comments
MARITAL_STAT_DT	Date	Date the married status was changed.
PLACE_OF_DEATH	Varchar	Place of constituent’s death.
DEATH_CERT_NUM	Varchar	Death certificate number.
VETERAN_FLG	Character	Required. Veteran benefits designation. Indicates whether a person is eligible for veteran’s benefits or is a veteran.

S_DYN_HRCHY Table

The following table shows details of the S_DYN_HRCHY table.

Table S_DYN_HRCHY table

Column Name	Data Type	Comments
LOCKED_FLG	Character	Dynamic hierarchy table.

S_PARTY_UCMX Table

The following table shows details of the S_PARTY_UCMX table.

Table S_PARTY_UCMX table

Column Name	Data Type	Comments
RVW_STATUS_CD	Varchar	Party-privacy related attributes and other Oracle Customer Hub (UCM) attributes which apply to accounts, contacts and household entities.

S_UCM_ADDR_PER Table

The following table shows details of the S_UCM_ADDR_PER table.

Table S_UCM_ADDR_PER table

Column Name	Data Type	Comments
REL_TYPE_CD	Varchar	Relationship between a contact and an address.
PAR_CON_ADDR_ID	Varchar	Foreign key for the best version address. The foreign key table is S_CON_ADDR.
TRANSACTION_ID	Varchar	Transaction ID.

S_UCM_ATGP_RULE Table

The following table shows details of the S_UCM_ATGP_RULE table.

Table S_UCM_ATGP_RULE table

Column Name	Data Type	Comments
RULE_MODULE_NAME	Varchar	Attribute group rule for Oracle Customer Hub (UCM) evaluation.
BUS_SERVICE_NAME	Varchar
METHOD_NAME	Varchar

S_UCM_CONTACT Table

The following table shows details of the S_UCM_CONTACT table.

Table S_UCM_CONTACT table

Column Name	Data Type	Comments
MARITAL_STAT_DT	Date	Date marital status was changed.
DEATH_DT	Date	Date of constituent’s death.
CLASS_YEAR	Number	Current projected graduation year or latest graduation year for alumni.
PLACE_OF_DEATH	Varchar	Place of constituent’s death.
DEATH_CERT_NUM	Varchar	Death certificate number
VETERAN_FLG	Character	Required. Veteran benefits designation. Indicates whether a person is eligible for veteran's benefits or is a veteran.
ETHNICITY_CD	Varchar	Ethnicity code.
TRANSACTION_ID	Varchar	Transaction ID.
PR_COUNTRY	Varchar	Primary country of contact.
PRIM_STATE_CD	Varchar	Primary state of contact.
IMPORT_TASK_NUM	Varchar	Task number of the import operation.
IMPORT_TASK_ID	Varchar	Task ID of the import operation.
IMP_TASK_BATCH_NUM	Varchar	Batch number of the import operation.
VALID_FLG	Character	Indicates whether the record is valid.
IMP_BAT_UNIQUE_REF	Varchar	Unique reference number of batch import operation.
OPERATION_CD	Varchar	Operation code.
ERROR_CODE	Varchar	Error code.
ERROR_MSG_TEXT	Varchar	Text of any error messages generated.

S_UCM_CON_CHILD Table

The following table shows details of the S_UCM_CON_CHILD table.

Table S_UCM_CON_CHILD table

Column Name	Data Type	Comments
PR_CHILD_FLG	Character	Indicates whether records are primary. The Primary flag is used to resolve the primary IDs in the S_CONTACT table after the records are propagated to the master records.

S_UCM_HRCHY Table

The following table shows details of the S_UCM_HRCHY table.

Table S_UCM_HRCHY table

Column Name	Data Type	Comments
UCM_UID	Varchar	Transaction staging table for Oracle Customer Hub (UCM) with integration of Oracle Hyperion Data Relationship Management.
NAME	Varchar
BV_LAST_UPD	UTC Date Time
BV_LAST_UPD_BY	Varchar
DYN_HRCHY_ID	Varchar
UCM_TYPE_CD	Varchar
DEFAULT_FLG	Character
UCM_TXN_DESC	Varchar
TRANSACTION_ID	Varchar
ERROR_CD	Varchar
ERROR_DESC	Varchar

S_UCM_HRCHY_REL Table

The following table shows details of the S_UCM_HRCHY_REL table.

Table S_UCM_HRCHY_REL table

Column Name	Data Type	Comments
PAR_ROW_ID	Varchar	Transaction staging table for Oracle Customer Hub (UCM) integration with Oracle Hyperion Data Relationship Management.
UCM_UID	Varchar
PARTY_ID	Varchar
PAR_PARTY_ID	Varchar
UCM_TYPE_CD	Varchar
DYN_HRCHY_REL_ID	Varchar
UCM_TXN_DESC	Varchar
TRANSACTION_ID	Varchar
BV_LAST_UPD	UTC Date Time
BV_LAST_UPD_BY	Varchar
ERROR_CD	Varchar
ERROR_DESC	Varchar

S_UCM_ORG_EXT Table

The following table shows details of the S_UCM_ORG_EXT table.

Table S_UCM_ORG_EXT table

Column Name	Data Type	Comments
PAR_PARTY_REL_ID	Varchar	Foreign key for the best version affiliation. Best version affiliation will be inserted in S_PARTY_PER instead of S_ORG_EXT.
AFFL_STATUS_DESC	Varchar	The status of an affiliation. The values include: Active, Inactive, or Error.
AFFL_STATUS_DESC	Varchar	A description that enhances the status information, for example, Inactive-withdrawal, inactive-terminated, and so on.
AFFL_RANK	Number	A five-digit number used by institutions to rank an affiliation.
REL_TYPE_CD	Varchar	Type of contact-account affiliation. The relationship between a contact and an account. The values can be: Student, Staff, Faculty, and Alumni.
REL_SUB_TYPE_CD	Varchar	Parent relationship code. It has similar values as those in the REL_TYPE_CD table. The hierarchy is maintained in the LOV table.
EFF_START_DT	Date	Effective start date. The default value is Created Date, but it can be overwritten.
EFF_END_DT	Date	Effective end date.
PRIMARY_FLG	Character	Required. Indicates whether the record is primary. When S_UCM_ORG_EXT is used to load child accounts of contacts, this indicator will be used to designate a primary account. The primary designation will be translated as the PR_OU_ID in S_CONTACT table or PR_AFFL_ID.
TRANSACTION_ID	Varchar	Transaction ID.

S_UCM_ORGGRP Table

The following table shows details of the S_UCM_ORGGRP table.

Table S_UCM_ORGGRP table

Column Name	Data Type	Comments
TRANSACTION_ID	Varchar	Stores the household record for the S_ORG_GROUP table.

S_UCM_RULE_SET Table

The following table shows details of the S_UCM_RULE_SET table.

Table S_UCM_RULE_SET table

Column Name	Data Type	Comments
PAR_OBJECT_CD	Varchar (30)	Parent entity object name.
END_DATE_FLD_NAME	Varchar (75)	Field name to pick expiry date or time from.