List view
Getting Started
Getting Started
Voter Registration
Voter Registration
Organizing
Organizing
Petitions
Petitions
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 | ㅤ |