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:

  • CAMPAIGN_LAUNCH_FEEDBACK: Uninstall signal received after a campaign launch
  • APP_UNREGISTERED: Unregister call received from the mobile app through the SDK
  • APP_UNINSTALL_CHECK_FEEDBACK: Uninstall signal received for the device during regular app uninstall check

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: en_US.

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:

  • APNS - Apple iOS platform
  • SAPNS - Apple iOS Development platform
  • GCM - Google Android platform
  • WNS - Windows platform (not supported for the Responsys v2 Push platform)
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)

The time zone of the device.

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

Learn more

App Channel List Permission Fields

Deleting App channel list records

Oracle Responsys Mobile App Channel Configuration Guide (PDF)