Dispatch and Engagement
Module: Customer Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CHANNEL | VARCHAR2 | 100 | Channel | ||||
| COMMUNICATION_ID | VARCHAR2 | 128 | Communication ID | DW_OUCI_X_EWDI_OUCI_DIM_MODULE_END_STATES | COMMUNICATION_ID | ||
| DATE_ID | NUMBER | 38 | 0 | Date | DW_OUCI_X_EWDI_OUCI_DIM_DATE | ID | |
| ENGAGEMENT_EVENT_ID | VARCHAR2 | 40 | |||||
| ENGAGEMENT_TYPE | VARCHAR2 | 20 | Engagement Type | ||||
| EVENT_TYPE | VARCHAR2 | 128 | Event Type | ||||
| ID | NUMBER | 38 | 0 | Record Identifier | |||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 531 | Source Record Id | ||||
| CUSTOMER_AFFORDABILITY_ID | NUMBER | 38 | 0 | Energy Affordability | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ENERGY_AFFORDABILITY | ID | |
| CUSTOMER_CLASSIFICATION_ID | NUMBER | 38 | 0 | Customer Classification | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_CLASSIFICATION | ID | |
| CUSTOMER_CONTACT_ID | NUMBER | 38 | 0 | Contact | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_CONTACT | ID | |
| CUSTOMER_DEMOGRAPHIC_ID | NUMBER | 38 | 0 | Demographics | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_DEMOGRAPHIC | ID | |
| CUSTOMER_ENERGY_BURDEN_ID | NUMBER | 38 | 0 | Customer Energy Burden | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ENERGY_BURDEN | ID | |
| CUSTOMER_HER_PROGRAM_ATTRIBUTES_ID | NUMBER | 38 | 0 | Opower HER Program | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_HER_PROGRAM_ATTRIBUTES | ID | |
| CUSTOMER_LOAD_ARCHETYPE_OVERALL_ELEC_ID | NUMBER | 38 | 0 | AMI Load Curve Archetype | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_LOAD_ARCHETYPE_OVERALL_ELEC | ID | |
| CUSTOMER_LOCATION_ID | NUMBER | 38 | 0 | Household Location | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_LOCATION | ID | |
| CUSTOMER_PII_ID | NUMBER | 38 | 0 | Personally Identifiable Information (PII) | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_PII | ID | |
| CUSTOMER_PROGRAM_PARTICIPATION_ID | NUMBER | 38 | 0 | Program Participation | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_PROGRAM_PARTICIPATION | ID | |
| CUSTOMER_ROLLUP_ACCT_SP_ID | NUMBER | 38 | 0 | Account Information | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_ACCT_SP | ID | |
| CUSTOMER_ROLLUP_EMAIL_ENGAGEMENT_ID | NUMBER | 38 | 0 | Email Engagement | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_EMAIL_ENGAGEMENT | ID | |
| CUSTOMER_ROLLUP_LOGINS_ID | NUMBER | 38 | 0 | Web Metrics - Logins | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_LOGINS | ID | |
| CUSTOMER_ROLLUP_USAGE_ID | NUMBER | 38 | 0 | Usage | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_USAGE | ID | |
| CUSTOMER_ROLLUP_WEB_ACTIONS_ID | NUMBER | 38 | 0 | Web Metrics - Actions | DW_OUCI_X_EWDI_OUCI_DIM_CUSTOMER_ROLLUP_WEB_ACTIONS | ID | |
| ENGAGEMENT_DATE_ID | NUMBER | 38 | 0 | Engagement Date | DW_OUCI_X_EWDI_OUCI_DIM_DATE | ID | |
| IS_AUTO_OPEN | NUMBER | 38 | 0 | Is Auto Open | |||
| IS_NON_AUTO_OPEN | NUMBER | 38 | 0 | Is Non-Auto Open | |||
| IS_UNIQUE_EVENT | NUMBER | 38 | 0 | ||||
| PRESENCE_DISCOVERY_ID | NUMBER | 38 | 0 | Presence Discovery | DW_OUCI_X_EWDI_OUCI_DIM_PRESENCE_DISCOVERY | ID | |
| REPORT_PERIOD_END_TSTAMP | DATE | 0 | Report Period End | ||||
| REPORT_PERIOD_START_TSTAMP | DATE | 0 | Report Period Start | ||||
| TEMPLATE_NAME | VARCHAR2 | 50 | Template Name | ||||
| TRACK_NAME | VARCHAR2 | 200 | Track Name | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |