Phone Verification Responses

This table displays each phone verification response input by a QC caller. You will see the registration scan id, question id, as well as which user input the response in which round and when.

Field	Type	Description	Notes
id	primary key (int)	id of phone verification response	unique to table
phone_verification_question_id	foreign key (int)	id of phone verification question	matches: id from phone_verification_questions table
voter_registration_scan_id	foreign key (int)	id of voter registration scan this verification response corresponds to	joins: id in voter_registration_scans table, and voter_registration_scan_id in voter_registration_scan_visual_review_responses table
created_by_user_id	foreign key (int)	id of user who created this phone verification response (user doing phone verification on this form)	joins: id in users table, created_by_user_id in shifts table, deliveries table, voter_registration_scan_batches table, canvassers table, locations table, and registration_forms table; reviewed_by_user_id in voter_registration_scans table
response	text	abbreviation of response to the question: t - true, f - false, lm - left message, lb - language barrier, rf - refused, cb - call back, b - busy, dc - disconnected, dn - do not call, wn - wrong number, vm - voicemail message is not the applicant	joins: phone_verification_response in quality_control_flag_triggers
created_at	timestamp	date&time the response was created	unique to table
updated_at	timestamp	date&time the response was last updated	unique to table
round_number	integer	phone verification round the response was submitted in	unique to table
notes	text	notes in the response	unique to table
call_id	foreign key (int)	unique twilio call id	joins: id in twilio_calls

No result found