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

Example of Setting Explicit Primary Mappings


After importing a Contact using EIM_CONTACT, you can use EIM_CONTACT3 to import the Contact's personal email addresses into S_PER_COMM_ADDR. You can explicitly set the primary email address by populating the primary flag column CON_PR_EMAIL_ADDR with Y.

Table 2 shows an example of setting the primary email address for Contact "CON100" to "John.Smith@hotmail.com."

Table 2.  Explicit Primary Mapping for a Contact

PARTY_UID

PARTY_TYPE_CD

CON_PERSON_UID

CON_PRIV_FLG

CON_BU

ADDR_COMMMEDIUM_CD

ADDR_ADDR

CON_PR_EMAIL_ADDR

CON100

Person

CON100

N

Default Organization

Email

JSmith@yahoo.com

 

CON100

Person

CON100

N

Default Organization

Email

JSmith@hotmail.com

Y

CON100

Person

CON100

N

Default Organization

Email

JSmith@gmail.com

 

If an explicit primary mapping is not used or not used properly—such as no address or more than one address flagged as the primary email address—then EIM ignores this explicit primary mapping and sets the primary implicitly.

Siebel Enterprise Integration Manager Administration Guide