Phone_Verification_Responses

List view
Voter Registration and Quality Control
Organizing
Petitions and Quality Control
Admin
Phone Banking
 

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
Joins
id
primary key (int)
id of phone verification response
unique to table
created_by_user_id
foreign key (int)
id of user who created this phone verification response (user doing phone verification on this form)
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
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
question_key
text
phone verification question the response is associated with in Blocks