Registration

Actual data from the registration forms as returned by OCR. Includes creation data and shift_id (from shifts table), but also registrant data such as name, address, gender, DOB, etc.

Field	Type	Description	Joins
id	primary key (int)	registration form id	delivery_form_exclusions.voter_registration_form_id, flags_triggering_forms.form_id, quality_control_phone_verification_calls.voter_registration_form_id
shift_id	foreign key (int)	id of shift the form is attached to	shifts.id
created_by_user_id	foreign key (int)	id of user that uploaded the packet containing the registration form	users.id
first_name	text	first name of registrant	unique to table
middle_name	text	middle name of registrant	unique to table
last_name	text	last name of registrant	unique to table
name_suffix	text	suffix of registrant	unique to table
voting_street_address_one	text	line one of registrant street address	unique to table
voting_street_address_two	text	line two of registrant street address	unique to table
voting_city	text	city of registrant voting address	unique to table
voting_state	text	state of registrant voting address	unique to table
voting_zipcode	integer	zip code of registrant voting address	unique to table
mailing_street_address_one	text	line one of registrant mailing address	unique to table
mailing_street_address_two	text	line two of registrant mailing address	unique to table
mailing_city	text	city of registrant mailing address	unique to table
mailing_zipcode	integer	zipcode of registrant mailing address	unique to table
county	text	county of registrant	unique to table
gender	text	m/f/NULL	unique to table
date_of_birth	timestamp	registrant's date of birth	unique to table
registration_date	timestamp	date on registration form	unique to table
identification	text	t/NULL	unique to table
phone_number	integer	phone number of registrant	unique to table
email_address	text	email address of registrant	unique to table
us_citizen	text	t/NULL	unique to table
eligible_voting_age	text	t/NULL	unique to table
signature	text	t/NULL	unique to table
extras	jsonb	smarty streets normalized address, data from forms that is not included in table fields, varies from state to state based on template	unique to table
created_at	timestamp	date&time that the registration_form record was created	unique to table
updated_at	timestamp	date&time that the registration_form record was last updated	unique to table
delivery_id	int(foreign key)	id of delivery form is attached to in Blocks (inactive - refer to delivery_id in voter_registration_scans table)	deliveries.id
party	text	party of registrant	unique to table
name_prefix	text	prefix of registrant	unique to table
ethnicity	text	ethnicity of registrant	unique to table
secondary identification	text	t/NULL	unique to table
metadata	jsonb	data on registration form in Blocks	unique to table
smarty_streets_match_data	jsonb	smarty streets match data for registrant address	unique to table
twilio_match_data	jsonb	twilio match data for registrant phone number	unique to table
social_security	text	t/NULL	unique to table
state_id	text	t/NULL	unique to table
por_data	text	t/NULL (proof of residency for states such as WI)	unique to table
pledge_card_data	jsonb	data entered from a pledge card associated with the form	unique to table
hard_copy_collected	text	t/NULL for pledge card hard copy collected	unique to table
mailing_state	text	state of mailing address	unique to table
redacted_fields	jsonb	fields on pledge card to be redacted when present (compliant with state laws)	unique to table
district_config	jsonb	list of districts for registrant address	unique to table
voterfile_match	jsonb	information on voterfile match	unique to table
person_id	foreign key (int)	unique id of person profile associated with registrant	unique to table
scan_number	integer	scan number in packet this form is associated with	unique to table
notes	text	any notes added by the user on the form	unique to table
lookup_code	text	code associated with form in the QR tracking workflow	unique to table
reviewed_at	timestamp	date&time form is reviewed in visual QC	unique to table
reviewed_by_user_id	foreign key (int)	unique id of user that reviewed form in visual QC	users.id
ocr_data	jsonb	data from ocr process	unique to table
visual_review_approved	text	t/f if the form was marked approved in the visual QC process in Blocks	unique to table

No result found