Unauthenticated Web Events
Module: Customer Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ANON_USER_UUID | VARCHAR2 | 128 | Unauthenticated User | DW_OUCI_X_EWDI_OUCI_DIM_UNAUTH_USER | ANON_USER_UUID | ||
| APPLICATION_NAME | VARCHAR2 | 10 | Application Name | ||||
| DATE_ID | NUMBER | 38 | 0 | Date | DW_OUCI_X_EWDI_OUCI_DIM_DATE | ID | |
| EVENT | VARCHAR2 | 32 | Event | ||||
| SESSION_IDENTIFIER | VARCHAR2 | 256 | Session Identifier | ||||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 501 | Source Record Id | ||||
| DEVICE_TYPE | VARCHAR2 | 1024 | Device Type | ||||
| IS_EMBEDDED | NUMBER | 1 | 0 | Is Embedded | |||
| PAGE_URLHOST | VARCHAR2 | 1024 | Page Urlhost | ||||
| PAGE_URLPATH | VARCHAR2 | 4000 | URL Path | ||||
| PAGE_URLQUERY | VARCHAR2 | 1024 | Page Urlquery | ||||
| PII_UUID | VARCHAR2 | 128 | Email Provided | DW_OUCI_X_EWDI_OUCI_DIM_ANON_USER_PII | ANON_USER_UUID | ||
| REFR_URLHOST | VARCHAR2 | 1024 | Refr Urlhost | ||||
| REFR_URLPATH | VARCHAR2 | 1024 | Refr Urlpath | ||||
| REFR_URLQUERY | VARCHAR2 | 1024 | Refr Urlquery | ||||
| REQUEST_FORMAT | VARCHAR2 | 1024 | Request Format | ||||
| SE_ACTION | VARCHAR2 | 1024 | Se Action | ||||
| SE_CATEGORY | VARCHAR2 | 32 | Se Category | ||||
| SE_LABEL | VARCHAR2 | 1024 | Tip Name | ||||
| SE_PROPERTY | VARCHAR2 | 1024 | Se Property | ||||
| SE_VALUE | NUMBER | 38 | 0 | Se Value | |||
| SITE_SECTION | VARCHAR2 | 1024 | Site Section | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |