EIM Interface Table Columns for Foreign Keys

The following table describes the properties of EIM interface table columns for foreign keys. EIM creates a separate foreign key column for each U1 user key column on the foreign key tables.

Column	Value
Name	Derived using the following format: PART ONE_NAME OF THE FOREIGN KEY COLUMN IN THE TARGET TABLE where: PART ONE is the first four letters of the foreign key table name without the S_ prefix, and trimmed to remove any trailing underscore (_) characters.
Physical Type	Physical type of the user key column on the target table, which is typically Varchar.
Length	Corresponds to the length of user key columns that the column references, which is typically 15.
Type	Data (Public)

The following table describes properties of interface table columns for foreign keys using CX_SEC_LEV as an example. EIM creates the corresponding EIM columns depending on the base column type.

Name	Physical Type	Type
OPTY_BU_ID	Varchar	Data (Public)
OPTY_NAME	Varchar	Data (Public)
OPTY_PR_DEPT_OU_ID	Varchar	Data (Public)
ORG_BU_ID	Varchar	Data (Public)
ORG_NAME	Varchar	Data (Public)
ORG_LOC	Varchar	Data (Public)