Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Adding Custom Extensions to the Data Model >

EIM Table Mapping Wizard

---

The EIM Table Mapping Wizard is accessed by right-clicking on a table entry in the Table list applet. The EIM menu item is only enabled with the non-standalone customer table. You can select an interface table and specify a prefix for the interface table columns that are generated by the wizard and that create a complete hierarchy of EIM Table Mapping objects needed to import and export data to and from the selected table. See Figure 75.

The EIM Table Mapping Wizard does not map foreign key columns if they point to a parent table column that does not have user key attributes. Because you cannot add user key attributes, this means that the EIM Table Mapping Wizard does not work with either standalone tables or foreign keys to custom tables.

In order to invoke the EIM Table Mapping Wizard for those Siebel base tables that do not have the foreign key as part of the user key, you need to create a temporary column with the following properties:

Field	Value
Inactive	Y
User Key Sequence	<> NULL (for example, set it to 0)
FK (Foreign Key)	Set (FK) Foreign Key table as itself

By creating this temporary column, when you launch the EIM Mapping Wizard, it will list standard EIM interface tables that are already mapped to this table as the target or destination tables. The wizard will also list EIM tables that are mapped to tables to which this table has a foreign key. However, the foreign key must be part of the "Traditional U1 Index" user key of this table.

NOTE:  After the EIM Mapping Wizard finishes, you should delete this temporary column.

Figure 75. EIM Mapping

To map a new table to an EIM interface table using the EIM Table Mapping Wizard

Lock the project.
Select Table object type in the Object Explorer.
Select an entry in the Object List Editor.

Choose from the list a base table that will be mapped to an EIM Table. It will be the primary table into which data from the existing Interface table will be imported.

This wizard is only available to tables of type Data (Public) and Data (Intersection), and Data (Extension), and Data (Extension-Siebel).

Right-click and select EIM Mapping Table from the menu.

The Interface Mapping dialog box is displayed with the Base Table name field populated with the selection you made in the Object List Editor.

In the "Edit the Column name prefix" field, enter a distinguishing prefix.

If a prefix does not already exist for the selected EIM table, the new prefix will be added to specified EIM Interface Table Columns related to the target table. If a prefix already exists, the existing prefix will be used.

In the "Select an interface table" field, select from the picklist.

The picklist for selecting the EIM Interface Table that will be mapped is constrained to show those standard interface tables that are mapped to tables to which the new custom table has a foreign key.

When selecting an existing base table, the wizard will only let you select the interface tables that have the base table defined as a target table.

The list is sorted by EIM table name. In the list you see candidate interface tables.

However, you will be given the option to select a different EIM table from the list. The picklist for choosing an EIM table will show the name of the table. In the picklist, interface tables with EXIST='Y' means that these EIM tables already have the base table mapped. If you extend existing Siebel tables, please consider these tables as the ideal candidates for EIM mapping.

If the EIM table you picked is not locked, you cannot proceed. You must lock the EIM table before starting the wizard.

Click Next on the Interface Table Mapping dialog box.

The Summary dialog box appears with a summary of the choices you have made.

Click Finish on the Summary dialog box to accept the choices you made and generate the EIM Interface Table object.

Based on this information, the wizard creates new EIM table mapping objects and adds several child objects to an existing EIM interface table object:

EIM Interface Table Column
EIM Table Mapping
Attribute Mapping
EIM Explicit Primary Mapping
Foreign Key Mapping
Foreign Key Mapping Column

EIM Object Specifications

The specifications for EIM objects are as follows:

EIM Interface Table (Table 17)

Table 17. EIM Interface Table Object Specifications

Specification	Value
Target Table	Selected by the developer
EIM Delete Proc Column	T_DELETED_ROW_ID
EIM Export Proc Column	T_EXPORTED_ROW_ID
EIM Merge Proc Column	T_MERGED_ROW_ID

EIM Interface Table Columns (Table 18)

Table 18. System Columns on the EIM Interface Table

Name	Physical Type	Length	Type	EIM Processing Column
CONFLICT_ID	Varchar	15	System	FALSE
CREATED	Date Time	7	System	FALSE
CREATED_BY	Varchar	15	System	FALSE
IF_ROW_BATCH_NUM	Number	22	System	FALSE
IF_ROW_MERGE_ID	Varchar	15	System	FALSE
IF_ROW_STAT	Varchar	30	System	FALSE
IF_ROW_STAT_NUM	Number	22	System	FALSE
LAST_UPD	Date Time	7	System	FALSE
LAST_UPD_BY	Varchar	15	System	FALSE
MODIFICATION_NUM	Number	22	System	FALSE
ROW_ID	Varchar	15	System	FALSE

Generic EIM Interface Table Columns for EIM processing

For each EIM Table Interface the following three columns are created to facilitate processing. Customers cannot change their values, which are shown in Table 19.

Table 19. Generic EIM Interface Table Columns for EIM Processing

Name	Physical Type	Length	Type	User Name	EIM Processing Column
T_DELETED_ROW_ID	Varchar	15	Data (Private)	Deleted ROW_ID from base table	TRUE
T_EXPORTED_ROW_ID	Varchar	15	Data (Private)	Exported ROW_ID from target table	TRUE
T_MERGED_ROW_ID	Varchar	15	Data (Private)	Merged into ROW_ID from target table	TRUE

EIM Interface Table Columns for processing a mapping to a particular table

There are four of these columns for each EIM Table Mapping object, with the following properties (Table 20):

Table 20. EIM Interface Table Columns for Processing a Particular Mapping

Column	Value
Name	Derived from the name of the target table: "T_"+ [EIM Table Mapping Name without the "CX_"]+ "_"+ [Process-specific suffix]
Physical Type	Depends on the process to which the column is related
Length	Depends on the process to which the column is related
Type	Depends on the process to which the column is related
User Name	Name of the EIM Table Mapping object for which the column is being created
EIM Processing Column	TRUE

For example, if the target table selected by the user is CX_SEC_LEV, an EIM Table Mapping object is created. The following four column objects are generated, with the corresponding default properties (Table 21):

Table 21. EIM Interface Table Columns for Processing a Mapping to CX_SEC_LEV

Name	Physical Type	Length	Type	User Name	EIM Processing Column
T_SEC_LEV_EXS	Character	1	IFMGR: Exists	CX_SEC_LEV	TRUE
T_SEC_LEV_RID	Varchar	15	IFMGR: ROW_ID	CX_SEC_LEV	TRUE
T_SEC_LEV_STA	Number	22	IFMGR: Status	CX_SEC_LEV	TRUE
T_SEC_LEV_UNQ	Character	1	IFMGR: Unique	CX_SEC_LEV	TRUE

EIM Interface Table Columns for foreign key processing

A column is created for each foreign key on the relevant EIM Table Mapping object (that is, the target table). These columns have the following properties (Table 22):

Table 22. EIM Interface Table Columns for Foreign Key Processing

Column	Value
Name	Derived from the target table name and the corresponding foreign key column on the target table in the following format: [Target Table name (with the "CX" prefix replaced by "T")]+[Target table foreign key column]
Type	Set to IFMGR: Fkey
Physical Type	Physical type of foreign key column on Target Table (typically Varchar)
Length	Length of foreign key column on Target Table (typically 15)
User Name	[Target Table (or EIM Table Mapping) name]+"."+[Foreign key column name]

For example, if CX_SEC_LEV contains foreign key columns called OPTY_ID and ACCNT_ID to the S_OPTY and S_ORG_EXT tables, respectively, the following EIM Table Columns are generated (Table 23):

Table 23. EIM Interface Table Columns for Processing Foreign Keys in CX_SEC_LEV

Name	Physical Type	Length	Type	User Name
T_SEC_LEV_OPTY_ID	Varchar	15	IFMGR: Fkey	CX_SEC_LEV.OPTY_ID
T_SEC_LEV_ACCNT_ID	Varchar	15	IFMGR: Fkey	CX_SEC_LEV.ACCNT_ID

EIM Interface Table Columns for foreign keys

A separate foreign key column will be created for each U1 user key column on the foreign key tables. The columns have the following properties (Table 24):

Table 24. EIM Interface Table Columns for Foreign Keys

Column	Value
Name	[First four letters of foreign key table name without the "S_" prefix, trimmed to remove any trailing "_"characters] + "_"+[foreign key column name on target table]
Physical Type	Physical type of the user key column on the target table (typically Varchar)
Length	Length of these columns will correspond to the length of user key columns upon which they are based (typically 15)
Type	Data (Public)

Continuing with the CX_SEC_LEV example (Table 25):

Table 25. EIM Interface Table Columns for CX_SEC_LEV Foreign Keys

Name	Physical Type	Length	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)

NOTE:  Depending on the base column type, corresponding EIM columns are generated accordingly.

EIM Interface Table Column for each attribute on the target table

Attribute columns on the target table are those of type Data (Public) that have a null Foreign Key Table property. These EIM interface table columns will have the following properties (Table 26):

Table 26. EIM Interface Table Columns for Each Attribute on the Target Table

Column	Value
Name	[Prefix entered—for example, CON or ACCNT]+"_"+[name of the corresponding column in the target table]
Physical Type	Data (Public)
Length	Length of corresponding column in the target table
User Name	Name of corresponding column in the target table

For example, if you enter a prefix of SECL and have the following attribute columns in CX_SEC_LEV: NAME (Varchar 100), DESC_TEXT (Varchar 250), and AUTO_UPDATE (Char 1), the following EIM interface table columns are generated (Table 27):

Table 27. EIM Interface Table Columns for Each Attribute on CX_SEC_LEV

Name	Physical Type	Length	Type	User Name
SECL_NAME	Varchar	100	Data (Public)	Security Level Name
SECL_DESC_TEXT	Varchar	250	Data (Public)	Security Level Description
SECL_AUTO_UPDATE	Char	1	Data (Public)	Auto Update Flag

EIM Table Mapping objects based on the target table

The name and destination columns will be set to the name of the target table. The processing column properties will correspond to those that have been automatically generated. For example (Table 28):

Table 28. EIM Table Mapping Objects Based on the Target Table

Column	Value
Name	CX_SEC_LEV
Destination Table	CS_SEC_LEV
EIM Exists Proc Column	T_SEC_LEV_EXS
EIM Row Id Proc Column	T_SEC_LEV_RID
EIM Status Proc Column	T_SEC_LEV_STA
EIM Unique Proc Column	T_SEC_LEV_UNQ

Attribute Mapping objects for each EIM interface column generated

These should have the following property values (Table 29):

Table 29. Attribute Mapping Objects for Each EIM Interface Column

Object	Value
Name	Attribute column on target table
Interface Table Data Column	Name of corresponding EIM interface table column generated (Table 27)
Base Table Attribute Column	Name of attribute column on target table

Foreign Key Mapping for each foreign key column on the Target Table

A separate Foreign Key Mapping object is created for each foreign key mapping column on the target table. The following properties are set for each (Table 30):

Table 30. Foreign Key Mapping for Each Foreign Key Column on the Target Table

Object	Value
Name	Name of the user key column
Foreign Key Column	Name of the user key column
User Key	Name of the U1 user key of the foreign key table
EIM Foreign Key Proc Column	Corresponding EIM interface table column for foreign key processing: "T_"+[Target table name without "CX_" prefix] +"_"+[user key column name]

Continuing with the CX_SEC_LEV example (Table 31):

Table 31. Foreign Key Mapping for Each Foreign Key Column on CX_SEC_LEV

Name	Foreign Key Column	User Key	EIM Foreign Key Proc Column
OPTY_ID	OPTY_ID	S_OPTY_U1	T_SEC_LEV_OPTY_ID
ACCNT_ID	ACCNT_ID	S_ORG_EXT_U1	T_SEC_LEV_ACCNT_ID

Foreign Key Mapping Columns for each Foreign Key Mapping object

A separate Foreign Key Mapping Column object is created for each user key column in the user key specified for the parent Foreign Key Mapping object (Table 30). The following properties are set for each foreign key mapping column (Table 32):

Table 32. Foreign Key Mapping Columns for Each Foreign Key Mapping Object

Column	Value
Name	EIM interface table column to which the user key column on the target table should be mapped. This EIM interface table column is generated according to the specifications in Table 24.
Interface Data Column	EIM interface table column to which the user key column on the target table should be mapped. This EIM interface table column is generated according to the specifications in Table 24.
User Key Attribute	Name of the corresponding user key column that belongs to the user key specified in Table 30.

Continuing with the CX_SEC_LEV example (Table 33):

Table 33. Foreign Key Mapping Columns for CX_SEC_LEV

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

Bookshelf Home | Contents | Index | Search | PDF