Deemed Total Demand Savings
Module: Customer Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | Record Identifier | |||
| PROGRAM_NAME | VARCHAR2 | 50 | Program Name | ||||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| SOURCE_RECORD_ID | VARCHAR2 | 122 | 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_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 | |
| DEEMED_SAVINGS | NUMBER | 38 | 0 | Deemed Savings | |||
| DEEMED_UNIT | VARCHAR2 | 5 | Deemed Unit | ||||
| END_DATE | TIMESTAMP | 0 | 6 | END_DATE | |||
| MEASURE_DESCRIPTION | VARCHAR2 | 256 | Measure Description | ||||
| MEASURE_LIFE | NUMBER | 38 | 0 | Measure Life (years) | |||
| MEASURE_NAME | VARCHAR2 | 90 | Measure Name | ||||
| PRESENCE_DISCOVERY_ID | NUMBER | 38 | 0 | Presence Discovery | DW_OUCI_X_EWDI_OUCI_DIM_PRESENCE_DISCOVERY | ID | |
| PROGRAM_DESCRIPTION | VARCHAR2 | 256 | Program Description | ||||
| START_DATE | TIMESTAMP | 0 | 6 | Start Date | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |