Field Mappings Between Siebel Loyalty and OIC
The field mappings between Siebel Loyalty and Oracle Integration Cloud (OIC) are described in the following table. Customers cannot modify these mappings.
| Integration Object Name | Integration Component Name | Integration Component Field Name | CrowdTwist Field Name | Mapping in OIC if Siebel Value is Null | Sample Value | Data Type |
|---|---|---|---|---|---|---|
|
CT LOY Member |
LOY Member |
Member Number |
thirrd_party_id |
N/A |
296-2185770 |
String |
|
CT Loyalty Member |
LOY Member |
<lang> |
lang_pref |
N/A |
en |
String |
|
CT Loyalty Member |
LOY Member |
Status Active mapped to 1 (is_active=true). REST mapped to 0 (is_active=false) |
is_active |
N/A |
Active |
String |
|
CT Loyalty Member |
Contact |
Contact First Name |
first_name |
N/A |
Mike |
String |
|
CT Loyalty Member |
Contact |
Contact Last Name |
last_name |
N/A |
Smith |
String |
|
CT Loyalty Member |
Contact |
Contact Middle Name |
middle_name |
N/A |
John |
String |
|
CT Loyalty Member |
Contact |
Data of Birth |
date_of_birth |
N/A |
312724555 |
Number |
|
CT Loyalty Member |
Contact |
Email Address |
email_address |
<Member Number> + ORCL-BRT-SIEBEL_LOY_CROWDTWIST_ CONFIG_SETTINGS.CT Default Email Domain |
a@gmail.com |
|
|
CT Loyalty Member |
Contact |
Primary Postal Code |
postal_code |
ORCL-BRT-SIEBEL_LOY_CROWDTWIST_ CONFIG_SETTINGS.Default CT User Postal Code |
10010 |
String |
|
CT Loyalty Member |
Contact |
Primary City |
city_name |
Capital of resolved CT country_code from ORCL-BRT-SIEBEL_LOY_ CROWDTWIST_ CONFIG_SETTINGS.Default CT User City ID |
London |
String |
|
CT Loyalty Member |
Contact |
Primary Country Code |
country_code |
ORCL-BRT-SIEBEL_LOY_ CROWDTWIST_ CONFIG_SETTINGS.Default CT User Country Code |
US |
String |
|
CT Loyalty Member |
Contact |
M/F |
gender_id |
N/A |
1 |
Number |