Profile List standard fields (system-defined)
System-defined List fields
The following table describes the system-defined List fields. Depending of which features are enabled for your account, some fields might not be available.
Note: You cannot alter system-defined fields. You can, however, create custom fields for your lists. For more information, see Change Schema and Load from File.
Field Name | Field Type | Description |
---|---|---|
RIID_ | Integer Field |
Oracle Responsys recipient tracking ID. This is a reserved field used to track an individual customer through the life-cycle of a List, campaign activities, etc. |
CREATED_SOURCE_IP_ | Text field (to 255 chars) | |
CUSTOMER_ID_ | Text Field (to 255 chars) | If you have a unique, external-source ID for each customer, store it in this field. |
EMAIL_ADDRESS_ | Text Field (to 500 chars) | Stores customer email addresses. |
EMAIL_DOMAIN_ | Text Field (to 255 chars) | Stores customer email domains. |
EMAIL_ISP_ | Text Field (to 255 chars) | Stores customer email ISPs. |
EMAIL_FORMAT_ | Single Character Field | Customer email format preference. Valid values are H for HTML, T for Text, or U for Unknown. |
EMAIL_PERMISSION_STATUS_ | Single Character Field | Opt-in/out status for interaction with customer email channel. Valid values are I for Opt-in and O for Opt-out. |
EMAIL_DELIVERABILITY_STATUS_ | Single Character Field | Deliverability status for interaction with customer email channel. Valid values are D for Deliverable and U for Undeliverable. |
EMAIL_PERMISSION_REASON_ | Text Field (to 255 chars) | |
EMAIL_MD5_HASH_ | Text Field (to 50 chars) |
User identifier using the MD-5 hash value of normalized email addresses. |
EMAIL_SHA256_HASH_ | Text Field (to 100 chars) | User identifier using the SHA-256 hash value of normalized email addresses. |
MOBILE_NUMBER_ | Text Field (to 50 chars) |
Customer mobile number for campaigns targeting mobile devices. Note: Responsys recommends using E.164 format (+nnnnnnnnnnnnnnn) when storing data in this field. Note that the "+" will be omitted. |
MOBILE_COUNTY_ | Text Field (to 25 chars) | The mobile country code of the device. |
MOBILE_PERMISSION_STATUS_ | Single Character Field | Opt-in/out status for interaction with customer mobile (SMS) channel. Valid values are the uppercase letter I for Opt-in and the uppercase letter O for Opt-out. Automatically set to O if the mobile number is a US number that has been disconnected (learn more about carrier disconnect processing). |
MOBILE_DELIVERABILITY_STATUS_ | Single Character Field | Deliverability status for interaction with customer mobile channel. Valid values are D for Deliverable and U for Undeliverable. |
MOBILE__PERMISSION_REASON_ | Text Field (to 255 chars) | |
POSTAL_STREET_1_ | Text Field (to 255 chars) | Line 1 of a customer postal street address for direct mail or print-on-demand campaigns. |
POSTAL_STREET_2 | Text Field (to 255 chars) | Line 2 of a customer postal street address for direct mail or print-on-demand campaigns. |
CITY_ | Text Field (to 50 chars) | Customer's city. |
STATE_ | Text Field (to 50 chars) | Customer's state. |
POSTAL_CODE_ | Text Field (to 25 chars) | Postal code of a customer postal address for direct mail or print-on-demand campaigns. |
COUNTRY_ | Text Field (to 50 chars) | Customer's 2-character country code. |
POSTAL_PERMISSION_STATUS_ | Single Character Field | Opt-in/out status for interaction with customer postal channel. Valid values are I for Opt-in and O for Opt-out. |
POSTAL_DELIVERABILITY_STATUS_ | Single Character Field | Deliverability status for interaction with customer postal channel. Valid values are D for Deliverable and U for Undeliverable. |
POSTAL__PERMISSION_REASON_ | Text Field (to 255 chars) | |
CREATED_DATE_ | Time Stamp Field (date + time) | Reserved field. Date that the record was created. |
MODIFIED_DATE_ | Time Stamp Field (date + time) | Reserved field. Date that the record was last modified. |
Special system List fields
Though not displayed above, there are additional system fields that only appear when viewing and editing data or creating/designing filters.
These fields describe the nature of each List customer record: when it was created, when it was last modified, etc. There is also a customer-unique ID (described below).
Unique List Identifier Field (RIID_)
Every List includes a system field created by Oracle Responsys ID
(RIID_
) that uniquely identifies each customer
across all Lists within your account.
Understanding Data and List Management
Creating a list or channel list
Data Load Record Handling and Requirements
Managing Profile Extensions and Supplemental Data