Configure the Oracle Responsys Database Tables
Once you have configured the Oracle Responsys connection, you need to create two tables to store the information created by the integration. These tables are CC_Master_User_List and CC_Submit_Order. These tables should be created in a folder called CC in Responsys.
Note: These are the default names of the tables that are populated by this integration. If you create tables with different names or in a different folder then you must also modify the adapter configuration to point to the different tables.
This section shows the structure for each of these tables.
CC_Master_User_List Table
The following is a list of fields that must be included in a table called CC_Master_User_List created in a folder called /CC in Responsys. The first list is the system fields for the table, and the second list is the custom fields for the table.
| Field Name | Field Type |
|---|---|
| RIID_ | Integer Field |
| CREATED_SOURCE_IP_ | Text Field (to 255 chars) |
| CUSTOMER_ID_ | Text Field (to 255 chars) |
| EMAIL_ADDRESS_ | Text Field (to 500 chars) |
| EMAIL_DOMAIN_ | Text Field (to 255 chars) |
| EMAIL_ISP_ | Text Field (to 255 chars) |
| EMAIL_FORMAT_ | Single character field |
| EMAIL_PERMISSION_STATUS_ | Single character field |
| EMAIL_DELIVERABILITY_STATUS_ | Single character field |
| EMAIL_PERMISSION_REASON_ | Text Field (to 255 chars) |
| EMAIL_MD5_HASH_ | Text Field (to 50 chars) |
| EMAIL_SHA256_HASH_ | Text Field (to 100 chars) |
| MOBILE_NUMBER_ | Text Field (to 50 chars) |
| MOBILE_COUNTRY_ | Text Field (to 25 chars) |
| MOBILE_PERMISSION_STATUS_ | Single character field |
| MOBILE_DELIVERABILITY_STATUS_ | Single character field |
| MOBILE_PERMISSION_REASON_ | Text Field (to 255 chars) |
| POSTAL_STREET_1_ | Text Field (to 255 chars) |
| POSTAL_STREET_2_ | Text Field (to 255 chars) |
| CITY_ | Text Field (to 50 chars) |
| STATE_ | Text Field (to 50 chars) |
| POSTAL_CODE_ | Text Field (to 25 chars) |
| COUNTRY_ | Text Field (to 50 chars) |
| POSTAL_PERMISSION_STATUS_ | Single character field |
| POSTAL_DELIVERABILITY_STATUS_ | Single character field |
| POSTAL_PERMISSION_REASON_ | Text Field (to 255 chars) |
| CREATED_DATE_ | Time Stamp Field (date + time) |
| MODIFIED_DATE_ | Time Stamp Field (date + time) |
| LOCALE | Text Field (to 25 chars) |
| FIRST_NAME | Text Field (to 100 chars) |
| LAST_NAME | Text Field (to 100 chars) |
| COMMERCE_REGISTRATION_DATE | Time Stamp Field (date + time) |
| COMMERCE_LAST_ACTIVITY | Time Stamp Field (date + time) |
| AGE | Number Field |
| PROFILEATTRIBUTE | Text Field (to 100 chars) |
CC_Submit_Order Table
The following is a list of fields that must be included in a list extension table called CC_Submit_Order created in a folder called CC in Responsys.
| Field Name | Field Type |
|---|---|
| RIID_ | Integer Field |
| ORDER_ID | Text Field (to 25 chars) |
| NUMBER_OF_ITEMS | Number Field |
| ORDER_DETAILS_URL | Text Field (to 100 chars) |
| ORDER_CURRENCY | Text Field (to 25 chars) |
| ORDER_SUBMIT_TIME | Time Stamp Field (date + time) |
| ORDER_SHIPPING_ADDRESS1 | Text Field (to 100 chars) |
| ORDER_SHIPPING_ADDRESS2 | Text Field (to 100 chars) |
| ORDER_SHIPPING_CITY | Text Field (to 25 chars) |
| ORDER_SHIPPING_STATE | Text Field (to 25 chars) |
| ORDER_SHIPPING_COUNTRY | Text Field (to 25 chars) |
| ORDER_SHIPPING_POSTAL | Text Field (to 25 chars) |
| ORDER_TOTAL | Text Field (to 25 chars) |
| ORDER_SHIPPING_MOBILE | Text Field (to 25 chars) |
| ORDER_ITEM_NAMES | Text Field (to 50 chars) |
| CREATED_DATE_ | Time Stamp Field (date + time) |
| MODIFIED_DATE_ | Time Stamp Field (date + time) |
| SITE_ID | Text Field (to 25 chars) |
| SITE_NAME | Text Field (to 500 chars) |