Deliveries

Deliveries


 
This table displays delivery information such as office id and turn-in location id from the locations table as well as canvasser id from the canvassers table, turn in date and delivery status.
 

Field
Type
Description
Notes
id
primary key (int)
unique delivery id
joins: delivery_id in voter_registration_scans table
office_id
foreign key (int)
unique id of location selected as the office of the delivery
joins: id in locations table
turn_in_location_id
foreign key (int)
unique id of location selected as the turn-in location for the delivery
joins: id in locations table, location_id in shifts table, turn_in_location_id in voter_registration_scans table
canvasser_id
foreign key (int)
unique canvasser id of the runner assigned to the delivery
joins: id in canvassers table, canvasser_id in shifts table
turn_in_date
timestamp
date of delivery
unique to table
notes
text
notes added to the delivery
unique to table
created_at
timestamp
date&time the delivery was created
unique to table
updated_at
timestamp
date&time the delivery was last updated
unique to table
created_by_user_id
foreign key (int)
unique id of user that created the delivery
joins: id in users table; created_by_user_id in locations table, canvassers table, shifts table, voter_registration_scan_batches table; reviewed_by_user_id in voter_registration_scans table
status
integer
numerical representation of delivery stage: 0 - Selection, 1 - Review, 2 - Ready for Delivery, 3 - Delivered
unique to table
runner_receipt_data
text
receipt data if a delivery receipt has been uploaded. If a receipt has not been uploaded, this field will be NULL
unique to table
form_filter_registration_date_start
date
start date of delivery filter - eligible forms
unique to table
form_filter_registration_date_end
date
end date of delivery filter - eligible forms
unique to table
form_filter_turf_id
integer
id of the turf of the delivery filter
unique to table
form_filter_counties
text
counties included in the delivery
joins: county in voter_registration_scans table
form_filters_no_county
text
true/false field
unique to table
delivery_method
text
mail/in_person field
unique to table
form_filter_qc_statuses
jsonb
list of QC statuses for shifts that will be eligible for the delivery