Web Pageviews
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 | |
| ID | NUMBER | 38 | 0 | Record Identifier | |||
| SESSION_IDENTIFIER | VARCHAR2 | 256 | Session Identifier | ||||
| SITE_SECTION | VARCHAR2 | 1024 | Site Section | ||||
| TSTAMP | TIMESTAMP | 0 | 6 | ||||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 1433 | 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 | |
| PAGE_URLPATH | VARCHAR2 | 4000 | URL Path | ||||
| PRESENCE_DISCOVERY_ID | NUMBER | 38 | 0 | Presence Discovery | DW_OUCI_X_EWDI_OUCI_DIM_PRESENCE_DISCOVERY | ID | |
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |