App Channel List standard fields
The following table describes the system-defined list fields for the app channel list. For mobile apps integrated with the Responsys Mobile App SDK, each record in the app channel list represents a device belonging to a person who has installed the mobile app.
Note: You can't alter an app channel list schema. Its fields are all system-defined fields and can't be modified, and you can't add custom fields to it. If you need to capture additional Mobile App channel data, you can create App Channel PETs. For details, see the Oracle Responsys Mobile App Channel Configuration Guide (PDF).
Field Name | Field Type | Description |
---|---|---|
ADMIN_AREA1_ |
Text Field (to 50 chars) |
Last known geographical classification of the device, such as State, Province, and Region. You can use this attribute to geo-target your campaigns. Important: Make sure to get explicit consent from your users to log this attribute. |
ADMIN_AREA2_ |
Text Field (to 50 chars) |
Last known sub-geographical classification of the device, such as County, or District. You can use this attribute to geo-target your campaigns. Important: Make sure to get explicit consent from your users to log this attribute. |
ADVERTISER_ID_ | Text Field (to 255 chars) |
Unique, platform-specific advertiser ID for the device. Depending on the platform, it is either the IDFA or the Google AD ID. Note: Can be used as a match key for an App Channel List PET import in Responsys. We do not recommend using this as a match key to import into the App Channel List PET when an account has more than one app using the same App Channel List. Because ADVERTISER_ID_ is unique for a device, there will be a conflict when a device has installed more than one app from the same account. Also, device users can reset the Advertiser ID and generate a new one at any time, so there is no guarantee that this value will remain unchanged. |
APP_ID_ |
Text Field (to 100 chars) |
App Id / Mobile App Identifier of the app installed on the device. |
API_KEY_ |
Text Field (to 25 chars) |
The app GUID, platform type, and platform identifier. (Platform-specific API key) |
APP_LOCATION_PERMISSION_ | Single Character Field | Indicates whether or not the app user has granted the app access to location services on the device. Learn more about permission-related fields for push in the App Channel List. |
APP_VERSION_ |
Text Field (to 20 chars) |
Last known app version on the device. |
CARRIER_ |
Text Field (to 30 chars) |
The mobile carrier on the device. |
CHANNEL_DELIVERABILITY_REASON_ |
Text Field (to 255 chars) |
Contains a value noting the reason that Channel Deliverability Status was set to "U" (Undeliverable). Values can be as follows:
NOTE: This column was added in 20D and will initially be NULL (empty). It will start getting populated in 21A onwards. |
CHANNEL_DELIVERABILITY_STATUS_ |
Single Character |
Indicates whether messages can be sent to this device or not. It is set to “D” (Deliverable) when the system creates an App Channel List record (that is, a new user installs an app on a specific mobile device for the first time). It is set to “U” (Undeliverable) when the device can no longer be reached, such as when the user has uninstalled the mobile app. Learn more about permission-related fields for push in the App Channel List. |
CHANNEL_PERMISSION_DATE_ | Time stamp field (date + time) | Logs the date and time whenever the Channel Permission Status is updated. |
CHANNEL_PERMISSION_REASON_ | Text | For accounts using the v2 Integrated Push architecture, this is set to “PU:MERGE” when the record is added to the App channel list. Accounts migrated from the v1 Integrated Push architecture may have App channel list records where this value is set to “CO:MERGE,” meaning that the record was added by a Connect job. |
CHANNEL_PERMISSION_STATUS_ |
Text |
Indicates whether the user has opted in to receive push notification from this device. Always set to “I” (Opted-In) for Android device records. For iOS device records, this could be set to either “I” (Opted-In) or “O” (Opted-Out), to reflect the User Preferences on the iOS device. Learn more about permission-related fields for push in the App Channel List. |
CREATED_DATE_ |
Time stamp field (date + time) |
Date and Time when the record is created in Responsys. |
DEVICE_CITY_ |
Text Field (to 100 chars) |
Last known city of the device. You can use this attribute to geo-target your campaigns. Important: Make sure to get explicit consent from your users to log this attribute. |
DEVICE_COUNTRY_CODE_ |
Text Field (to 2 chars) |
Last known country code of the device. You can use this attribute to geo-target your campaigns. Important: Make sure to get explicit consent from your users to log this attribute. |
DEVICE_ID_ |
Text Field (to 255 chars) |
Device ID, GUID/UUID style, as generated by the OS of the device during first run of the app. This means that different apps on the same device will have different device IDs. This ID changes when a mobile app is uninstalled and re-installed. Used internally by Responsys. Note: Device ID + API Key combination can be used as a match key for an App Channel List PET import in Responsys |
DEVICE_MODEL_ |
Text Field (to 100 chars) |
Model identifier of the device. |
DEVICE_POSTAL_CODE_ |
Text Field (to 255 chars) |
Last known postal or zip code of the device. You can use this attribute to geo-target your campaigns. Important: Make sure to get explicit consent from your users to log this attribute. |
DEVICE_TOKEN_ | Text (to 1024 chars) | Primary handle to send messages to GCM and APNS platforms. |
EXT_DEVICE_TRACKING_ID_ | Text (to 255 chars) |
Allows data captured by other SDKs, such as external analytics data about a device. Note: Can be used as a match key for an App channel list PET import in Responsys. This ID represents the unique Device ID of an external system. Using the Oracle Responsys Mobile App Platform Cloud Service SDK, a Mobile App Developer can log this during the first device registration and subsequent device registration updates. |
INSTALLED_AT_DATE_ |
Time stamp field (date + time) |
This is the date when the mobile app is first run on the device, which is when Responsys detects that the mobile app was installed. |
IP_ADDRESS_ | Text (to 50 chars) | IP of the device. Hidden column. |
LOCALE_ |
Text (to 25 chars) |
The locale of the device. Usually expressed as a combination of the two-character ISO language code and the two-character ISO country code. Example: |
MANUFACTURER_ | Text (to 100 chars) | Device manufacturer. |
MOBILE_COUNTY_CODE_ |
Text Field (to 25 chars) |
The mobile country code of the device. Populated when available. |
MODIFIED_DATE_ |
Time stamp field (date + time) |
Date and Time when the record was last updated in Responsys. |
OS_VERSION_ |
Text (to 25 chars) |
Operating system version of the device. |
PLATFORM_TYPE_ |
Text Field (to 10 chars) |
The platform type of a device. Values are:
|
PROFILE_RIID_ | Integer | This is a foreign key reference to the profile list. Every app channel list is associated to a profile list. When this field has a value, it corresponds to a known contact in the profile list. Conversely, when this field is blank, it implies the user’s profile is unknown (that is, the mobile app user has chosen to not sign in to the mobile app with their user identifier). |
PUSH_PERM_BADGES_ | Single Character Field |
Note: This field is only applicable to iOS devices. This column indicates whether the iOS user has opted in to App Icon Badging on this iOS device. This could be set to either I (Opted-In) or O (Opted-Out), to reflect the user preferences on the iOS device. Learn more about permission-related fields for push in the App Channel List. |
PUSH_PERM_AUTH_STATUS_ | Single Character Field |
Note: This field is only applicable to iOS devices. When an iOS app implements iOS Provisional Authorization, this column indicates whether the iOS user is still in the Provisional Authorization state (P) or not. When an iOS app is installed with Provisional Authorization, the application is automatically opted-in to Push Notifications and is provisionally authorized to "Deliver Quietly" (that is to only share non-interruptive notifications with the user), and Push Notifications do not interrupt the user by appearing on the device's lock screen or as banners. For such iOS apps, this column is set to P (Provisionally Authorized) when the user is still Provisionally Authorized and has not updated Push Notification permissions on the device after app installation. The purpose of this column is to let marketers take decisions based on whether or not a certain user is Provisionally Authorized. Learn more about this field and Provisional Authorization. |
REGISTRATION_UPDATED_DT_ | Time stamp field (date + time) | To be used internally by the system. Hidden column. |
RIID_ |
Integer |
Oracle Responsys ID that corresponds to a unique device record in the App Channel List. This is a reserved field used to track known and unknown mobile app users, and it is the key that is logged for all Mobile App channel activities (Sent, Opens, Conversions, and the like). Note: You can use RIID_ as a match key for an App Channel List PET import in Responsys. |
SCREEN_DENSITY_ | Number | Screen density multiplier (for example, “2” for a first-generation Apple Retina Display). |
SCREEN_HEIGHT_ |
Integer |
Screen height of the device, in pixels. |
SCREEN_WIDTH_ |
Integer |
Screen width of the device, in pixels. |
SDK_VERSION_ |
Text Field (to 25 chars) |
Responsys Mobile App SDK version, used by Oracle Responsys for troubleshooting. |
TIME_ZONE_ |
Text Field (to 50 chars) |
|
UPDATED_AT_DATE_ |
Time stamp field (date + time) |
This is the date when the mobile app last communicated with the Responsys system; this may be due to a user interaction or other cause (such as background location update). |
VENDOR_ID_ | Text (to 255 chars) | IDFV, or Identifier for Vendors. Shared by all apps from the same company. Hidden column. |
UNINSTALLED_AT_DATE_ | Time stamp field (date + time) |
Logs the date and time when uninstall detection occurs by Responsys. NOTE: This column was added in 20D and will initially be NULL (empty). It will start getting populated in 21A onwards. |
USER_IDENTIFIER_ | Text (to 50 chars) |
For logged in users, it contains the value of the USER_IDENTIFIER (match key) from the mobile app. For logged out users, it contains null. Used when the mobile app retrieves a logged in user’s Message Center messages from Responsys. |
App channel list, App Channel List, mobile app channel, Mobile App channel, system fields, standard fields, columns, app channel list, app channel, Responsys App channel, Responsys app channel, responsys app channel
App Channel List Permission Fields
Deleting App channel list records
Oracle Responsys Mobile App Channel Configuration Guide (PDF)