Handling Updates

Consumers of the Web Audit Customer Answers and Questions extract should consider the unique key for each row to be a combination of utility_customer_id, premise_id, and question_name. This means that any row with a previously unseen combination of the above should be entered in the target system as a new record. Any row which matches an existing combination of the above should overwrite the existing values in user_input_answer or the selected_answer_option for the given utility_customer_id/ premise_id/question_name combination.