Just o note to myself: record producers store the values of questions in table question_answer and the relationship between record producers and records created using a record producer is stored in sc_item_produced_record.