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 101 describes properties of the EIM interface table.
Table 101. 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 102 lists system columns of the EIM interface table.
Table 102. 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 103 describes the generic EIM interface table columns to facilitate EIM processing for each EIM table interface. You cannot modify the values of these columns.
Table 103. 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 104 describes EIM interface table columns for processing a mapping to a defined table.
Table 104. 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 that Siebel CRM uses with the column. |
Length |
Type |
User Name |
Name of the EIM Table Mapping object that Siebel CRM creates for the column. |
EIM Processing Column |
TRUE |
Table 105 describes an example of the columns that Siebel Tools creates and the default properties. For example, if the target table is CX_SEC_LEV, then Siebel Tools creates an EIM table mapping.
Table 105. 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 106 describes the columns that EIM creates for each foreign key on the target EIM table mapping.
Table 106. 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 107 describes the EIM table columns that EIM creates 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 107. 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 108 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 108. 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 109 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.
Table 109. 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 110 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 110. 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 111 describes the interface table columns that EIM creates 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 111. 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 112 describes examples of how EIM sets the name and destination columns to the name of the target table. The column properties correspond to the values that EIM creates.
Table 112. 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 Creates
Table 113 describes properties of the attribute mappings for each EIM interface column that EIM creates.
Table 113. Attribute Mapping Properties of EIM Interface Columns That EIM Creates
|
|
Name |
Attribute column on the target table. |
Interface Table Data Column |
Name of corresponding EIM interface table column created. For more information, see Table 111. |
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 114 describes the properties of each foreign key mapping that EIM creates for each foreign key mapping column on the target table.
Table 114. 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 115 describes the foreign key mapping, using the CX_SEC_LEV table as an example.
Table 115. 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 116 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 114.
Table 116. Foreign Key Mapping Columns for Foreign Key Mappings
|
|
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 Table 108. |
User Key Attribute |
Name of the user key column that is part of the user key defined in Table 114. |
Table 117 describes the foreign key mapping, using the CX_SEC_LEV table as an example.
Table 117. 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 |
|