Unauthenticated Starts & Completions
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 | ||
| DATE_ID | NUMBER | 38 | 0 | Date | DW_OUCI_X_EWDI_OUCI_DIM_DATE | ID | |
| FIRST_TIMESTAMP | TIMESTAMP | 0 | 6 | First Timestamp | |||
| SURVEY_EVENT_ID | NUMBER | 38 | 0 | ||||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 280 | Source Record Id | ||||
| AUTH_TYPE | VARCHAR2 | 128 | Auth Type | ||||
| EVENT_TYPE | VARCHAR2 | 128 | Event Type | ||||
| PII_UUID | VARCHAR2 | 128 | Email Provided | DW_OUCI_X_EWDI_OUCI_DIM_ANON_USER_PII | ANON_USER_UUID | ||
| QUESTIONNAIRE_VERSION | NUMBER | 38 | 0 | Questionnaire Version | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |