Temporary Columns in EIM Tables

EIM tables (Interface tables) act as staging area which holds the data that has to be imported, data exported from the Siebel base tables, data to be deleted and that to be merged.

Every Siebel interface table has 4 types of temporary columns as defined below:

• UNQ column.
• EXS column.
• RID column.
• STA column.

Each of the temporary columns has a naming format as follows: 

" T_<base table without prefix S_>__<temporary column type> "

       Examples: T_ORG_EXT__UNQ, T_ORG_EXT__EXS, T_ORG_EXT__STA, T_ORG_EXT__RID

There are few exceptions for this naming rule.

       Examples: T_ACCNTPOST__STA, T_OPTYPOSTN__RID, T_PRODLNPOSTN__RID

EIM Mandatory Columns

For an EIM process to be successful , we must populate values in a certain set of columns.
The Mandatory Columns in an EIM Process are :

• ROW_ID
• IF_ROW_BATCH_NUM
• IF_ROW_STAT
• IF_ROW_MERGE_ID

In this set of four columns, IF_ROW_MERGE_ID is only mandatory when we are carrying out EIM Merge process. So we can look on to these columns in detail and what data to be populated on these.