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
UNQ column
The temporary columns that have suffix UNQ, stores Y or N values if the interface record’s user keys are not same as another interface record’s user keys in the same batch.
EXS column
The temporary columns that have suffix EXS, stores Y or N values if the interface record can be mapped to an existing base record (i.e. base record exists for the same user keys).
RID column
The temporary columns that have suffix RID, stores the ROW_ID of the record already existing in the base table or generated ROW_ID for new records in the interface table.
STA column
The temporary columns that have suffix STA, stores the pass number of the EIM process where it failed. Example: If the EIM process failed while processing a record in the S_ORG_EXT table, the temporary column T_ORG_EXT__STA is set the EIM pass number at that point of time.
No comments:
Post a Comment