Questionnaire Wave 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Changes in housing ownership and structure
Customer_reference(PK) | no_of_electricity_meters | own_the_house_or_living_on_rent | occupy_renters_boarders | renters_were_there_during_w2_or_not | since_when_renters_are_living_in_household | awareness_of_electricity_consumption_of_renters | changes_to_the_structure_of_household_after_w1 | renovations_done_after_w1 | new_type_of_house | new_no_of_storeys | new_floor_area | built_house_or_purchased_house | considered_natural_lighting | considered_ventilation | used_insulation_material | new_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | other_business_activity | is_there_any_construction_or_renovation_ongoing | last_month_expenditure | smart_metered_or_non_smart_metered
ACCOUNT_NO/ LA_Unique_ID | W3_EM_1/ W3_EM_2 | W3_B_1 | W3_C_3 | W3_C_3b | W3_C_3c / W3_C_3cOth | W3_C_5 | W3_B_5a | W3_B_5b | W3_B_3 | W3_B_7 | W3_B_8 | W2_B_9 | T_W2_B_10_1 | T_W2_B_10_2 | T_W2_B_10_3 | W3_C_1_a | W3_C_4 | W3_C_6 | W3_C_7 | W3_C_8 | W3_C_8Oth | W2_E_8 | W1_H_4 | W1_H_5
Demographics Changes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Old household members |  |  |  |  |  |  |  |  |  |  |  |  |  |
Customer_reference(PK) | member_id(PK) | was_present_during_w1 | was_present_during_w2 | still_living_in_house_or_not | changed_main_activity_engaged_in_or_not | new_main_activity | new_main_occupation | daily_wage_earner_or_not | employment_status_of_the_new_main_occupation | no_of_hours_stayed_at_home_during_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | member_id | W3_C1.3a | W3_C1.3b | W2_C1_4 | W2_C.3.j_1 | W2_C.3.j | W2_C.3.k | W2_C.3.l | W2_C.3m | W2_C.3.n |  |  |  |  |  |  |  |  |  |  |  |  |  |
New household members |  |  |  |  |  |  |  |
Customer_reference(PK) | member_id(PK) | name | relationship_to_the_head_of_household | gender | year_of_birth | age | ethnicity | religion | marital_status | current_attendance_in_any_education_instituition | highest_level_of_education | main_activity_engaged_in | main_occupation | daily_wage_owner_or_not | employment_status_of_the_main_occupation | no_of_hours_stayed_at_home_during_last_week |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | member_id(may be continue above) | W1_C.2.a | W1_C.2.b | W1_C.2.c | W1_C.2.d | W1_C.2.d.1 | W1_C.2.e | W1_C.2.f | W1_C.2.g | W1_C.2.h | W1_C.2.i | W1_C.2.j | W1_C.2.k | W1_C.2.l | W1_C.2.m | W1_C.2.n |  |  |  |  |  |  |  |
Appliance Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Change in appliance list |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | appliance(PK) | appliance_type_and_no_of_appliances | still_have_the_same_number_of_appliances_or_not | new_no_of_appliances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | get the appliance list | W2_D | W1_D1a | W1.D2a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
New appliance list + old |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | appliance(PK) | is_the_appliance_available_in_the_household | no_of_appliances_of_that_type | no_of_hours_used_during_last_week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | get the appliance list | W2_D1 | W2_D2, W1.D2a | W2_D3, W1_D3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Room Roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
Changes in room roster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
customer_reference(FK)(PK) | room_id(PK) | room_type | no_of_rooms_of_each_type | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
ACCOUNT_NO/ LA_Unique_ID | ACCOUNT_NO_room_id | list the types | T_W1_E_5_1 - T_W1_E_5_10 | W2_E.5c | W2_E.5d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
consciously_reduced | switching off refrigerator | buying_before_unusable |
W3_N_1 | W3_N_3 | W3_N_4 |
awareness |
have_heard_about_time_of_use_metering | use_of_time_of_use_metering | reduced_electricity | why_havent_used_time_of_use_metering | like_to_use_time_of_use_metering | ability_to_shift_consumption |
W3_P_1 | W3_P_2 | W3_P_3 | W3_P_4 | W3_p_5 | 6 |
Billing |
target_units_of_consumption | target_type | target_number_of_units | target_bill_value | reading_smart_meter_data | Knowledge_on_bill_calculation | payment_practice | disconnection_due_to_late_payment | no_of_red_notices |
W3_M_1 | W3_M_2 | W3_M_3 | W3_M_4 | W3_M_5 | W3_M_6 | W3_M_7 | W3_M_8 | W3_M_9 |