Survey Starts & Completions
Module: Customer Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DATE_ID | NUMBER | 38 | 0 | Date | DW_OUCI_X_EWDI_OUCI_DIM_DATE | ID | |
| EVENT_TYPE | VARCHAR2 | 128 | Event Type | ||||
| ID | NUMBER | 38 | 0 | Record Identifier | |||
| SURVEY_EVENT_ID | NUMBER | 38 | 0 | ||||
| SURVEY_TYPE | VARCHAR2 | 20 | Survey Type | ||||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 299 | Source Record Id | ||||
| AUTH_TYPE | VARCHAR2 | 128 | Auth Type | ||||
| 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 | |
| EVENT_TIMESTAMP | TIMESTAMP | 0 | 6 | Event Timestamp | |||
| IS_CSR_EVENT | NUMBER | 1 | 0 | Is CSR Event | |||
| PRESENCE_DISCOVERY_ID | NUMBER | 38 | 0 | Presence Discovery | DW_OUCI_X_EWDI_OUCI_DIM_PRESENCE_DISCOVERY | ID | |
| QUESTIONNAIRE_VERSION | NUMBER | 38 | 0 | Questionnaire Version | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |