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

Deleting EIM Table Rows

When you have successfully imported most of your EIM table rows, you can delete them. However, you might want to leave rows that were not fully imported in order to examine and correct them. If you want to do this, remember that each EIM table imports data into one or more target base tables. For example, EIM_ACCOUNT imports into S_PARTY, S_ORG_EXT, S_ORG_BU, S_PARTY_PER, S_ORG_REL, S_ACCNT_POSTN, S_ADDR_ORG, and S_CTLG_CAT_ORG.

• Each EIM table includes a separate temporary column that contains a status code for each base table into which it has imported data. The names of these columns are contractions of the target base table name.

  For example, T_ORG_EXT__STA. T_ indicates that this is a temporary column; ORG_EXT is the first three letters of each word in the target base table name (S_ORG_EXT), and __STA indicates that this is the status column. Note that the extension begins with two underscores.

• During import, a row's status column is set to 0 for those tables into which the row was successfully imported. The IF_ROW_STAT is set to IMPORTED if a row is successfully imported into all target base tables, or PARTIALLY IMPORTED if it is successfully imported into at least one target.
  • To delete rows that were successfully imported into all target base tables, you could use the following SQL statement:

     delete from EIM_ACCOUNT
     where (IF_ROW_STAT = 'IMPORTED')

  • To delete rows that were successfully imported into specific target base tables, you could use the following SQL statement:

     delete from EIM_ACCOUNT
     where (if_row_stat = 'partially_imported' and
     t_org_ext__sta = 0 and t_addorg__sta = 0)

  • You can also use ONLY BASE TABLES to limit processing.