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.