Savings
Module: Customer Insights
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | Record Identifier | |||
| MEASUREMENT_ID | NUMBER | 38 | 0 | Measurement | |||
| METER_TYPE | VARCHAR2 | 32 | Meter Type | ||||
| UTILITY | VARCHAR2 | 32 | Utility | DW_OUCI_X_EWDI_OUCI_DIM_UTILITY | CODE | ||
| YEAR_MONTH_ID | NUMBER | 38 | 0 | Date | DW_OUCI_X_EWDI_OUCI_DIM_MONTH | YEAR_MONTH | |
| SOURCE_RECORD_ID | VARCHAR2 | 182 | Source Record Id | ||||
| MEASUREMENT_NAME | VARCHAR2 | 64 | Measurement Name | ||||
| MODEL_LABEL | VARCHAR2 | 32 | Model Label | ||||
| SAVINGS | NUMBER | 16 | 4 | ||||
| SAVINGS_RATE | NUMBER | 10 | 4 | ||||
| TREATMENT_CUSTOMER_COUNT | NUMBER | 38 | 0 | ||||
| TREATMENT_DATA_DAYS | NUMBER | 38 | 0 | ||||
| TREATMENT_EXPECTED_DATA_DAYS | NUMBER | 38 | 0 | ||||
| TREATMENT_USAGE | NUMBER | 16 | 4 | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |