Assessment Responses Extract (Incremental)
The Assessment Responses extract includes data provided by Energy Efficiency Web Portal - Classic users who update the What Uses Most feature within a specified date range. It is available as a standard recurring extract from your Delivery Team.
Note: The What Uses Most feature is a legacy feature that has been superseded by the Home Energy Analysis. Contact your Delivery Team if you have questions about whether this data extract is applicable to your situation.
Column | Description |
---|---|
utility_customer_id |
The customer identifier that is used on customer communications. This is usually the same value as the Example: 1234-1234-1234-1234 Field Size: 40. Can Be Empty?: No. |
home_thermostat_when_cold |
Thermostat setting used when home and cold. Integer value. Field Size: 3. Can Be Empty?: Yes. |
away_thermostat_when_cold |
Thermostat setting used when away and cold. Integer value. Field Size: 3. Can Be Empty?: Yes. |
asleep_thermostat_when_cold |
Thermostat setting used when asleep and cold. Integer value. Field Size: 3. Can Be Empty?: Yes. |
drafty_windows |
Indicates whether the home has drafty windows. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
window_condensation |
Indicates whether the home has window condensation. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
static_electricity |
Indicates whether the home has static electricity. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
home_thermostat_when_hot |
Thermostat setting used when home and hot. Integer value. Field Size: 3. Can Be Empty?: Yes. |
away_thermostat_when_hot |
Thermostat setting used when away and hot. Integer value. Field Size: 3. Can Be Empty?: Yes. |
asleep_thermostat_when_hot |
Thermostat setting used when asleep and hot. Integer value. Field Size: 3. Can Be Empty?: Yes. |
rooms_with_sun |
Indicates whether the home has rooms with signification amounts of sun. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
scalding_water |
Indicates whether water from the tap gets hot enough to scald. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
washing_machine |
Indicates whether the home has a clothes washing machine. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
dryer |
Indicates whether the home has a clothes dryer. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
second_fridge |
Indicates whether the home has a second fridge. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
mini_fridge |
Indicates whether the home has a mini fridge. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
standalone_freezer |
Indicates whether the home has a standalone freezer. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
efficient_lighting |
Indicates whether the home has efficient lighting. Allowed Values:
Field Size: 14. Can Be Empty?: Yes. |
outdoor_lighting |
Indicates whether the home has outdoor lighting. Allowed Values:
Field Size: 14. Can Be Empty?: Yes. |
pool_covered |
Indicates whether the home has a cover for the pool (if applicable). Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
desktop_computer |
Indicates whether the home has a desktop computer. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
television |
Indicates whether the home has a television. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
dvd_player |
Indicates whether the home has a DVD player. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
game_console |
Indicates whether the home has a game console. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
updated_date |
Date of the last update to the customer’s assessment responses. Field Size: 10. Can Be Empty?: No. |