Registration Forms

Field

Type

Description

Notes

id

primary key (int)

registration form id

joins: registration_form id in voter_registration_scans table

registration_type

integer

numerical representation of registration type; 0 - new registration, 1 - address change, 2 - name change, 3 - party change, 4 - federal or state, 5 - replacement card, NULL - not identified on form

unique to table

shift_id

foreign key (int)

id of shift the form is attached to

joins: id in shifts table, shift_id in voter_registration_scans table and voter_registration_scan_batches table

created_by_user_id

foreign key (int)

id of user that uploaded the packet containing the registration 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 phone_verification_responses table; reviewed_by_user_id in voter_registration_scans table

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 that the registration_form record was created

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)

unique to table

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

completed

text

t/f

unique to table (not active)

uuid

integer

uuid

unique to table

van_id

integer

van id

unique to table

secondary identification

text

t/NULL

unique to table

person_id

int(foreign key)

unique id of person record associated with the form in Blocks

joins: id in people table, person_id in phone_banking_calls table

smarty_streets_match_data

jsonb

smarty streets match data for registrant address

ㅤ

twilio_match_data

jsonb

twilio match data for registrant phone number

ㅤ

social_security

text

t/NULL

ㅤ

state_id

text

t/NULL

ㅤ

por_data

text

t/NULL (proof of residency for states such as WI)

ㅤ

pledge_card_data

jsonb

data entered from a pledge card associated with the form

ㅤ

hard_copy_collected

text

t/NULL for pledge card hard copy collected

ㅤ

redacted_fields

jsonb

fields on pledge card to be redacted when present (compliant with state laws)

ㅤ

district_config

jsonb

list of districts for registrant address

ㅤ

voterfile_match

jsonb

information on voterfile match

ㅤ

person_id

foreign key (int)

unique id of person profile associated with registrant

ㅤ

scan_number

integer

scan number in packet this form is associated with

ㅤ

notes

text

any notes added by the user on the form

ㅤ

lookup_code

text

code associated with form in the QR tracking workflow

ㅤ

reviewed_at

timestamp

date&time form is reviewed in visual QC

ㅤ

reviewed_by_user_id

foreign key (int)

unique id of user that reviewed form in visual QC

ㅤ