Presence Discovery
Module: Customer Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| APPLIANCE | VARCHAR2 | 128 | Type of Appliance | ||||
| ID | NUMBER | 38 | 0 | Record Identifier | |||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| WEEK_ID | NUMBER | 38 | 0 | Date | DW_OUCI_X_EWDI_OUCI_DIM_WEEK | YEAR_WEEK | |
| SOURCE_RECORD_ID | VARCHAR2 | 239 | Source Record Id | ||||
| APPLIANCE_DISPLAY | VARCHAR2 | 255 | Appliance | ||||
| 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 | |
| SITE_PRESENCE | VARCHAR2 | 128 | Site Presence | ||||
| SITE_PRESENCE_DISPLAY | VARCHAR2 | 128 | Site Presence | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |