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.
The following table shows an example of setting the primary email address for Contact “CON100” to “John.Smith@hotmail.com.”
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 |
JSmith@yahoo.com |
Not applicable |
|
CON100 |
Person |
CON100 |
N |
Default Organization |
JSmith@hotmail.com |
Y |
|
CON100 |
Person |
CON100 |
N |
Default Organization |
JSmith@gmail.com |
Not applicable |
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.