Usage
Module: Customer Insights
Type: Dimension
ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 | 0 | True | Record Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 38 | Source Record Id | ||||
| AVG_DAILY_ELEC_BUCKET | VARCHAR2 | 20 | Avg Daily Elec | ||||
| AVG_DAILY_ELEC_FALL_BUCKET | VARCHAR2 | 20 | Avg Daily Elec Fall | ||||
| AVG_DAILY_ELEC_FALL_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_ELEC_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_ELEC_SPRING_BUCKET | VARCHAR2 | 20 | Avg Daily Elec Spring | ||||
| AVG_DAILY_ELEC_SPRING_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_ELEC_SUMMER_BUCKET | VARCHAR2 | 20 | Avg Daily Elec Summer | ||||
| AVG_DAILY_ELEC_SUMMER_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_ELEC_WINTER_BUCKET | VARCHAR2 | 20 | Avg Daily Elec Winter | ||||
| AVG_DAILY_ELEC_WINTER_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_GAS_BUCKET | VARCHAR2 | 20 | Avg Daily Gas | ||||
| AVG_DAILY_GAS_FALL_BUCKET | VARCHAR2 | 20 | Avg Daily Gas Fall | ||||
| AVG_DAILY_GAS_FALL_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_GAS_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_GAS_SPRING_BUCKET | VARCHAR2 | 20 | Avg Daily Gas Spring | ||||
| AVG_DAILY_GAS_SPRING_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_GAS_SUMMER_BUCKET | VARCHAR2 | 20 | Avg Daily Gas Summer | ||||
| AVG_DAILY_GAS_SUMMER_RANGE_MIN | NUMBER | 38 | 0 | ||||
| AVG_DAILY_GAS_WINTER_BUCKET | VARCHAR2 | 20 | Avg Daily Gas Winter | ||||
| AVG_DAILY_GAS_WINTER_RANGE_MIN | NUMBER | 38 | 0 | ||||
| ELEC_DAYS | NUMBER | 37 | 2 | Elec Days | |||
| ELEC_PCT_ACTUAL_READS | NUMBER | 37 | 2 | Elec Percent Actual Reads | |||
| GAS_DAYS | NUMBER | 37 | 2 | Gas Days | |||
| GAS_PCT_ACTUAL_READS | NUMBER | 37 | 2 | Gas Percent Actual Reads | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |