Energy Affordability
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 | ||||
| AMI_INCOME_BUCKET | VARCHAR2 | 20 | Ability to pay | ||||
| AREA_MEDIAN_INCOME_LOW | NUMBER | 38 | 0 | ||||
| DLLR_MMBTU_LOW | NUMBER | 38 | 0 | ||||
| DOMINANT_FUEL_TYPE | VARCHAR2 | 20 | Dominant Fuel Type | ||||
| DOMINANT_HEAT_PRICE | VARCHAR2 | 20 | Dominant Fuel Price | ||||
| ENERGY_BURDEN | NUMBER | 38 | 0 | Energy Burden | |||
| LOCALE_SUB | VARCHAR2 | 10 | Sub Locale | ||||
| LOCALE_TYPE | VARCHAR2 | 10 | Locale | ||||
| MEDIAN_INCOME_BUCKET | VARCHAR2 | 20 | Approximate Income Level | ||||
| MODE_VINTAGE | VARCHAR2 | 20 | Housing Vintage | ||||
| PCT_CHILD_ELDERY_BUCKET | VARCHAR2 | 10 | Percent Children and Elderly | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |