Foreign Key Mapping Columns for Foreign Key Mappings

The following table describes the properties that EIM sets for each foreign key mapping column. EIM creates a separate foreign key mapping column for each user key column in the user key that is defined for the parent foreign key mapping object in the first table in Foreign Key Mapping Properties of Foreign Key Columns on the Target Table.

Column	Value
Name	Name of the foreign key mapping column.
Interface Data Column	EIM interface table column that EIM maps to the user key column on the target table. EIM creates this EIM interface table column according to the specifications in the table in EIM Interface Table Columns for Foreign Keys.
User Key Attribute	Name of the user key column that is part of the user key defined in the first table in Foreign Key Mapping Properties of Foreign Key Columns on the Target Table.

The following table describes the foreign key mapping, using the CX_SEC_LEV table as an example.

Name	Interface Data Column	User Key Attribute
OPTY_BU_ID	OPTY_BU_ID	BU_ID
OPTY_NAME	OPTY_NAME	NAME
OPTY_PR_DEPT_OU_ID	OPTY_PR_DEPT_OU_ID	PR_DEPT_OU_ID
ORG_BU_ID	ORG_BU_ID	BU_ID
ORG_NAME	ORG_NAME	NAME
ORG_LOC	ORG_LOC	LOC