3 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 if you Contact 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 customer_id column sent by the utility in other data files, but not always. Additional identifiers may need to be added to the extract. Discuss this modification with your Delivery Team, if necessary. 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: N Y Field Size: 1. Can Be Empty?: Yes.
window_condensation	Indicates whether the home has window condensation. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
static_electricity	Indicates whether the home has static electricity. Allowed Values: N Y 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: N Y Field Size: 1. Can Be Empty?: Yes.
scalding_water	Indicates whether water from the tap gets hot enough to scald. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
washing_machine	Indicates whether the home has a clothes washing machine. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
dryer	Indicates whether the home has a clothes dryer. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
second_fridge	Indicates whether the home has a second fridge. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
mini_fridge	Indicates whether the home has a mini fridge. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
standalone_freezer	Indicates whether the home has a standalone freezer. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
efficient_lighting	Indicates whether the home has efficient lighting. Allowed Values: A_LOT LITTLE_OR_NONE SOME Field Size: 14. Can Be Empty?: Yes.
outdoor_lighting	Indicates whether the home has outdoor lighting. Allowed Values: A_LOT LITTLE_OR_NONE SOME Field Size: 14. Can Be Empty?: Yes.
pool_covered	Indicates whether the home has a cover for the pool (if applicable). Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
desktop_computer	Indicates whether the home has a desktop computer. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
television	Indicates whether the home has a television. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
dvd_player	Indicates whether the home has a DVD player. Allowed Values: N Y Field Size: 1. Can Be Empty?: Yes.
game_console	Indicates whether the home has a game console. Allowed Values: N Y 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.