Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings >

EIM Table Mappings to Base Tables Without User Keys

Some EIM tables contain table mappings to base tables without user keys. When using these EIM tables, you should note the EIM behavior for the relevant process type as described in Process Issues for Base Tables Without User Keys.

EIM Tables and Base Tables Without User Keys

Table 5 lists some examples of EIM tables containing table mappings to base tables without user keys.

Table 5.  Example EIM Tables With Table Mappings to Base Tables Without User Keys
EIM Table
Target Base Table Without User Key
EIM_ACCNT_DTL
S_NOTE_ACCNT
EIM_ACCSRCPIDTL
S_NOTE_ACCSRCPI
EIM_ACC_SRC_DTL
S_NOTE_ACC_SRC
EIM_ACT_DTL
S_NOTE_ACT
EIM_ASGN_GRP
S_ASGN_RESULT
EIM_ASSET_DTL
S_NOTE_ASSET
EIM_BASELN_DTL
S_NOTE_BASELINE
EIM_CON_DTL
S_NOTE_CON
EIM_CONSUM_DTL
S_NOTE_CONSUME
EIM_CON_PI_DTL
S_NOTE_CON_PI
EIM_DCP_DTL
S_NOTE_DCP
EIM_DEFECT_DTL
S_NOTE_DEFECT
EIM_INVC_DTL
S_NOTE_INVOICE
EIM_NOTE
S_NOTE
EIM_OPTY_DTL
S_NOTE_OPTY
EIM_ORDER1
S_NOTE_ORDER
EIM_ORDER_ITEM1
S_NOTE_ORDER_IT
EIM_GROUP_DTL
S_NOTE_ORGGROUP
EIM_PRDINT_DTL
S_NOTE_PROD_INT
EIM_PROJECTDTL
S_NOTE_PROJ
EIM_PROJITMDTL
S_NOTE_PROJITEM
EIM_PROJRSRCDTL
S_NOTE_PROJRSRC
EIM_QUOTE_DTL
S_NOTE_QUOTE
EIM_QUO_IT_DTL
S_NOTE_QUOTE_IT
EIM_PDSHIP_DTL
S_NOTE_SHIPMENT
EIM_SR_DTL
S_NOTE_SR
EIM_SRC_DTL
S_NOTE_SRC
EIM_TARGET_DTL
S_NOTE_TARGET
EIM_USR_MSG_DTL
S_NOTE_USR_MSG
EIM_WFM_ACTION
S_ACTION_ARG
EIM_WFM_RULE
S_ESCL_ACTION

Process Issues for Base Tables Without User Keys

This subsection describes issues that you should be aware of when performing EIM processes involving base tables without user keys.

Importing Data into Base Tables Without User Keys. Import works but EIM does not check and prevent duplicate records from being imported into the base tables without user keys. If an import batch is executed repeatedly, the same records are imported repeatedly because EIM cannot check whether the records to be imported already exist in the base table without user keys.

Updating Data in Base Tables Without User Keys. Update on base tables without user keys cannot work, because EIM cannot uniquely identify the record to update.

Exporting Data from Base Tables Without User Keys. Exporting data from base tables without user keys is done the same way as exporting data from base tables with user keys.

Deleting Data from Base Tables Without User Keys. DELETE ALL ROWS and DELETE MATCHES can be used to delete data in target base tables. If a table without a user key is the target table, then delete works as it does for base tables with user keys. In most cases, however, a table without a user key is a secondary table and its data can only be deleted with the table as a child of its parent table.

NOTE:  EIM_NOTE_DEL and EIM_SKLI_DEL are special EIM tables used for deleting from the S_NOTE* and S_*SKILL_IT tables, which do not have the normal U1 user key.

Merging Data in Base Tables Without User Keys. Merge does not work on base tables without user keys.


 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004