Siebel EIM Temporary Columns
Written By: Rohit|
December 23, 2012|
The temporary columns in an EIM table are the columns which are used by EIM task to manipulate data values at run times and let the programmer analyze data after import. The temporary columns perform these tasks:
1. Store the ROW IDs of records created or already present in all base tables of interface table.
2. Status and uniqueness of the records, and also whether the record already exists in the database.
3. Some temporary columns store the ROW ID values of deleted, merged or exported rows.
An EIM table has 4 types of temporary columns. Each type of temporary column has a naming format as follows:
T_<base table without prefix S_>__<temporary column type>
For e.g. Example: T_EVT_ACT__UNQ, T_EVT_ACT__EXS, T_ EVT_ACT__STA, T_EVT_ACT__RID
1. UNQ column: It stores a value ‘Y’ or ‘N’ depending on whether the row’s user key matches with the user key of any other row in same batch in same EIM table.
2. EXS column: It stores a value ‘Y’ or ‘N’ depending on whether a row in base table exists with the same user key.
3. RID column: It stores the ROW ID of record created or already present in the base table.
4. STA column: It stores the pass number of the base tables when they are processed by EIM. For e.g. If the EIM process at EIM_ACTIVITY failed and the value present in IF_ROW_STAT_NUM matches with T_EVT_ACT__STA, then the EIM failed to process S_EVT_ACT table.
So, temporary columns provide a great way to troubleshoot Siebel EIM errors! Good Luck!
Also See : How to Solve EIM Errors