Foreign Key Mapping Column

A foreign key mapping column identifies a part of the user key. It identifies an attribute column that Siebel CRM uses to locate rows in the table that the foreign key references. The combination of user key columns uniquely identifies rows in this table. Siebel Enterprise Integration Manager (EIM) uses this object type. For more information, see Siebel Enterprise Integration Manager Administration Guide.

Caution: You must not modify this object type. Any modifications can adversely affect performance.

This object type occurs in the following location in the object hierarchy:

• Siebel Objects > EIM Interface Table > EIM Table Mapping > Foreign Key Mapping > Foreign Key Mapping Column

The following table describes properties that Siebel CRM uses with a foreign key mapping column.

Property	Description
Interface Table Data Column Name (S)	Specifies the name of the column in the interface table that supplies the data.
Name (S)	Specifies the name of the user key column.
Self Ref Mapping Column Name (S)	Specifies the name of the column.
Self Reference Join (S)	If TRUE, then Siebel CRM allows a join operation between the self-reference mapping column and the foreign key mapping column.
User Key Attribute Name (S)	Specifies the name of the attribute column.