RIID_ |
NUMBER |
RIID_ of Record in Web App Channel List. |
PROFILE_RIID_ |
NUMBER |
Profile List RIID_ of the Known User. |
CHANNEL_PERMISSION_STATUS_ |
CHAR(1 CHAR) |
Web Push Permission Status from the End User (Opted In or Opted Out). |
CHANNEL_DELIVERABILITY_STATUS_ |
CHAR(1 CHAR) |
Web Push Deliverability Status for this End User. Possible values are D and U. |
CHANNEL_PERMISSION_REASON_ |
VARCHAR2(255 CHAR) |
Web Push Permission Reason. |
CHANNEL_PERMISSION_DATE_ |
TIMESTAMP(6) |
Log the Date / Time whenever the Web Push Permission Status is updated. |
CREATED_DATE_ |
TIMESTAMP(6) |
Date and Time when the record is created in
Responsys.
|
MODIFIED_DATE_ |
TIMESTAMP(6) |
Date and Time when the record is last updated in
Responsys. |
APP_ID_ |
VARCHAR2(25 CHAR) |
Application ID. Any number of Web Push apps (APP_ID_) can be associated with the same Web Push Channel list |
API_KEY_ |
VARCHAR2(100 CHAR) |
Identifies the platform for the Web Push app. |
PLATFORM_TYPE_ |
VARCHAR2(25 CHAR) |
Identifies the user's platform type. Open standard-compliant browsers identified by platform type standard. |
VISITOR_ID_ |
VARCHAR2(255 CHAR)1 |
Every visitor to the Website will be assigned a unique Visitor ID. |
SUBSCRIPTION_TOKEN_ |
VARCHAR2(1000 CHAR) |
Web Push Notifications Token issued by a Web Push Service. |
REGISTRATION_UPDATED_DT_ |
TIMESTAMP(6)
|
This is the date when the website last communicated with the Responsys system; this may be due to a user interaction or other cause (such as background location update). |
FIRST_OPT_IN_AT_DATE_ |
DATE |
Date / Time when the End User first Opted Into Web Push on the Browser. |
APP_VERSION_ |
VARCHAR2(25 CHAR)
|
Version of the website that this User last visited. |
SDK_VERSION_ |
VARCHAR2(25 CHAR)
|
Oracle Web Push Cloud Service SDK version. |
BROWSER_ |
VARCHAR2(50 CHAR) |
Browser name being used when the last registration was received. |
BROWSER_VERSION_ |
VARCHAR2(25 CHAR) |
The browser version being used when the last registration was received. |
OS_TYPE_ |
VARCHAR2(100 CHAR) |
The operating system being used by the end user. |
OS_VERSION_ |
VARCHAR2(25 CHAR) |
The operating system version. |
MANUFACTURER_ |
VARCHAR2(100 CHAR) |
The device manufacturer. |
DEVICE_MODEL_ |
VARCHAR2(100 CHAR)
|
Model identifier of the device. |
SCREEN_WIDTH_ |
NUMBER
|
Screen width of devices, in pixels. |
SCREEN_HEIGHT_ |
NUMBER
|
Screen height of device, in pixels. |
SCREEN_DENSITY_ |
FLOAT |
Screen density multiplier. |
DEVICE_LOC_PERM_STATUS_ |
VARCHAR2(25 CHAR)
|
Location Permission Status indicates whether the user has given the Website Location Service Permission. Values for this field are NO_SUPPORT, NOT_DETERMINED, ALLOWED, NOT_ALLOWED, and Empty / NULL value.
NOTE: Because location parameters are not populated currently, this field's value will be NULL.
|
DEVICE_COUNTRY_CODE_ |
VARCHAR2(25 CHAR)
|
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. NOTE: Because location parameters are not populated currently, this field's value will be NULL. |
DEVICE_CITY_ |
VARCHAR2(255 CHAR)
|
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.
NOTE: Because location parameters are not populated currently, this field's value will be NULL. |
DEVICE_POSTAL_CODE_ |
VARCHAR2(25 CHAR)
|
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. NOTE: Because location parameters are not populated currently, this field's value will be NULL. |
ADMIN_AREA1_ |
VARCHAR2(50 CHAR)
|
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.
NOTE: Because location parameters are not populated currently, this field's value will be NULL. |
ADMIN_AREA2_ |
VARCHAR2(50 CHAR)
|
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.
NOTE: Because location parameters are not populated currently, this field's value will be NULL. |
LOCALE_ |
VARCHAR2(25 CHAR)
|
This identifies the locale / language that has been set by the user in the browser settings. |
TIME_ZONE_ |
VARCHAR2(50 CHAR)
|
Time zone of the device. |
EXT_DEVICE_TRACKING_ID_ |
VARCHAR2(255 CHAR)
|
Identifier for data captured by other SDKs, such as external analytics data about a device. |
IP_ADDRESS_ |
TEXT (to 50 CHAR) |
IP of the device. Hidden column. |
USER_IDENTIFIER_ |
VARCHAR2(500 CHAR)
|
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. |