Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > Other Examples >

Example of Adding a Position to a Party Table

This example shows how positions are added to party tables, such as Account, Contact, and Employee. You are adding positions to the Account table.

You can use the EIM_ACCOUNT table to populate S_ACCNT_POSTN, which is an intersection table between Accounts and Position.

In the S_ACCNT_POSTN table, you provide information about the position you are trying to add (POSITION_ID) and the account you are trying to associate with the position (OU_EXT_ID).

In the EIM_ACCOUNT table, you provide information about the account.

To populate the EIM table, you must always include the target base table: in this case, S_PARTY. Since EIM_ACCOUNT is for account information, S_PARTY should also be filled with account information. So you set the S_PARTY.PARTY_TYPE_CD = 'Organization' since Account belongs to the Organization type. (PARTY_TYPE_CD = 'Person' is only used for Contact, User, Employee, or Partner.)

The .IFB file looks like this:

[Add Position]

TYPE = IMPORT

BATCH = 2002

TABLE = EIM_ACCOUNT

ONLY BASE TABLES = S_PARTY, S_ACCNT_POSTN

INSERT ROWS = S_PARTY, FALSE

INSERT ROWS = S_ORG_EXT, FALSE

INSERT ROWS = S_ACCNT_POSTN, TRUE

UPDATE ROWS = S_ACCNT_POSTN, TRUE