DW_OUCI_X_EWDI_OUCI_FACT_RSYS_EMAIL_EVENTS

Unauthenticated Email Events

Details

Module: Customer Insights

Type: Fact

Key Columns

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCOUNT_ID NUMBER 38 0 Account Id
ANON_USER_UUID VARCHAR2 128 Unauthenticated User DW_OUCI_X_EWDI_OUCI_DIM_UNAUTH_USER ANON_USER_UUID
CAMPAIGN_ID NUMBER 38 0 Campaign
DATE_ID NUMBER 38 0 Date DW_OUCI_X_EWDI_OUCI_DIM_DATE ID
EVENT VARCHAR2 32 Event
LAUNCH_ID NUMBER 38 0 Launch
LIST_ID NUMBER 38 0 List
UTILITY VARCHAR2 32 Utility DW_OUCI_X_EWDI_OUCI_DIM_UTILITY CODE
SOURCE_RECORD_ID VARCHAR2 389 Source Record Id
PII_UUID VARCHAR2 128 Email Provided DW_OUCI_X_EWDI_OUCI_DIM_ANON_USER_PII ANON_USER_UUID
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6