Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Application >
Objects You Use with Enterprise Integration Manager
This topic describes properties of objects that Siebel CRM uses with EIM. For more information, see Siebel Enterprise Integration Manager Administration Guide. Properties of the EIM Interface Table
Table 98 describes properties of the EIM interface table.
Table 98. Properties of the EIM Interface Table
|
|
Target Table |
Chosen 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 |
System Columns of the EIM Interface Table
Table 99 lists system columns of the EIM interface table.
Table 99. System Columns of the EIM InterfaceTable
|
|
|
|
|
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 |
EIM Interface Table Columns to Facilitate EIM Processing
Table 100 describes the generic EIM interface table columns to facilitate EIM processing for each EIM table interface. You cannot change the values of these columns.
Table 100. EIM Interface Table Columns to Facilitate EIM Processing
|
|
|
|
|
|
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 Defined Table
Table 101 describes EIM interface table columns for processing a mapping to a defined table.
Table 101. EIM Interface Table Columns for Processing a Mapping to a Defined Table
|
|
Name |
Derived from the name of the target table using the following format: T_PART ONE_PROCESS SUFFIX
where: PART ONE is the EIM Table Mapping Name without the CX_ prefix
|
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 |
Table 102 describes an example of the columns that Siebel Tools generates and the default properties. For example, if the target table is CX_SEC_LEV, then Siebel Tools creates an EIM table mapping.
Table 102. Example of EIM Interface Table Columns for Processing a Mapping to a Defined Table
|
|
|
|
|
|
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 Processing a Foreign Key
Table 103 describes the columns that EIM creates for each foreign key on the target EIM table mapping.
Table 103. EIM Interface Table Columns for Processing a Foreign Key
|
|
Name |
Derived from the target table name and the corresponding foreign key column on the target table using the following format: PART ONE FOREIGN KEY COLUMN OF THE TARGET TABLE
where: PART ONE is the target table name with the CX_ prefix replaced with T_
|
Type |
Set to IFMGR: Fkey |
Physical Type |
Physical type of foreign key column of the target table, which is typically Varchar. |
Length |
Length of foreign key column of the target table, which is typically 15. |
User Name |
Derived using the following format: TARGET TABLE NAME or EIM TABLE MAPPING NAME.FOREIGN KEY COLUMN NAME
|
Table 104 describes the EIM table columns that EIM generates if the CX_SEC_LEV table contains the following foreign key column mappings:
- The OPTY_ID foreign key column mapping references the S_OPTY table
- The ACCNT_ID foreign key column mapping references the S_ORG_EXT table
Table 104. Example of EIM Interface Table Columns for Processing a Foreign Key
|
|
|
|
|
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
Table 105 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.
Table 105. EIM Interface Table Columns for Foreign Keys
|
|
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) |
Table 106 describes properties of interface table columns for foreign keys using CX_SEC_LEV as an example. EIM generates the corresponding EIM columns depending on the base column type.
Table 106. Example of Interface Table Columns for Foreign Keys
|
|
|
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) |
EIM Interface Table Columns for Attributes on the Target Table
Table 107 describes properties of EIM interface table columns for attribute columns on the target table. The EIM interface table column includes the following qualities:
- Physical Type property is Data (Public)
- Foreign Key Table property is empty
Table 107. EIM Interface Table Column for Attributes on the Target Table
|
|
Name |
Derived using the following format: PREFIX_NAME OF THE CORRESPONDING COLUMN IN THE TARGET TABLE
CON and ACCNT are example prefixes. |
Physical Type |
Data (Public) |
Length |
Length of corresponding column in the target table. |
User Name |
Name of corresponding column in the target table. |
Table 108 describes the interface table columns that EIM generates if you enter a prefix of SECL with the following attribute columns in the CX_SEC_LEV table:
- NAME (Varchar 100)
- DESC_TEXT (Varchar 250)
- AUTO_UPDATE (Char 1)
Table 108. Example of EIM Interface Table Columns Attributes on the Target Table
|
|
|
|
|
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 Mappings That Reference the Target Table
Table 109 describes examples of how EIM sets the name and destination columns to the name of the target table. The processing column properties correspond to those that EIM generates.
Table 109. Example of EIM Table Mappings That Reference the Target Table
|
|
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 Properties of EIM Interface Columns That EIM Generates
Table 110 describes properties of the attribute mappings for each EIM interface column that EIM generates.
Table 110. Attribute Mapping Properties of EIM Interface Columns That EIM Generates
|
|
Name |
Attribute column on the target table. |
Interface Table Data Column |
Name of corresponding EIM interface table column generated. For more information, see Table 108. |
Base Table Attribute Column |
Name of the attribute column on the target table. |
Foreign Key Mapping Properties of Foreign Key Columns on the Target Table
Table 111 describes the properties of each foreign key mapping that EIM creates for each foreign key mapping column on the target table.
Table 111. Foreign Key Mapping Properties of Foreign Key Columns on the Target Table
|
|
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 derived from the following format: T_PART ONE_NAME OF THE USER KEY COLUMN
where: PART ONE is the name of the target table without the CX_ prefix
|
Table 112 describes the foreign key mapping, using the CX_SEC_LEV table as an example.
Table 112. Example of Foreign Key Mapping Properties of Foreign Key Columns on the Target Table
|
|
|
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 Foreign Key Mappings
Table 113 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 Table 111.
Table 113. Foreign Key Mapping Columns for Foreign Key Mappings
|
|
Name |
Name of the foreign key mapping column. |
Interface Data Column |
EIM interface table column to which EIM maps the user key column on the target table. EIM generates this EIM interface table column according to the specifications in Table 105. |
User Key Attribute |
Name of the user key column that is part of the user key defined in Table 111. |
Table 114 describes the foreign key mapping, using the CX_SEC_LEV table as an example.
Table 114. Example of Foreign Key Mapping Columns for Foreign Key Mappings
|
|
|
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 |
|