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