List view
Getting Started
Getting Started
Voter Registration
Voter Registration
Organizing
Organizing
Petitions
Petitions
Shifts
This table displays shift information such as location and staging location (from locations table), and data such as type, date, time and status. It also displays soft counts of forms.
Field | Type | Description | Notes |
id | primary key (int) | unique shift id | joins: shift_id in voter_registration_scans table, voter_registration_scan_batches table and registration_forms table |
location_id | foreign key (int) | unique location id of location of shift | joins: id in locations table |
canvasser_id | foreign key (int) | id from canvassers table of canvasser attached to shift | joins: id in canvasser table, canvasser_id in deliveries table |
shift_start | timestamp | date&time shift began | unique to table |
shift_end | timestamp | date&time shift ended | unique to table |
created_by_user_id | foreign key (int) | unique id of user that created the shift | joins: id in users table; created_by_user_id in deliveries table, voter_registration_scan_batches table, canvassers table, locations table, registration_forms table, and phone_verification_responses table; reviewed_by_user_id in voter_registration_scans table |
created_at | timestamp | date&time shift was created | unique to table |
updated_at | timestamp | date&time shift was last updated | unique to table |
status | text | status of shift, options are: ready_for_scans, ready_for_qc, in_qc, ready_for_phone_verification, in_phone_verification, completed | unique to table |
incomplete_vr_forms_count | integer | total of incomplete cards from data entry | unique to table |
registration_forms_count | integer | total registration forms from data entry | unique to table |
soft_count_cards_total_collected | integer | soft count of total cards from cover sheet | unique to table |
soft_count_cards_complete_collected | integer | soft count of complete cards from cover sheet | unique to table |
soft_count_cards_incomplete_collected | integer | soft count of incomplete cards from cover sheet | unique to table |
soft_count_cards_with_phone_collected | integer | soft count of cards with phone numbers from cover sheet | unique to table |
notes | text | any notes entered for the shift | unique to table |
field_start | timestamp | date&time the field hours begin for the shift | unique to table |
field_end | timestamp | date&time the field hours end for the shift | unique to table |
soft_count_pre_registration_cards_collected | integer | soft count of pre-registration cards from cover sheet | unique to table |
ready_for_phone_verification_at | timestamp | date&time the shift was marked ready_for_phone_verification | unique to table |
ready_for_delivery_at | timestamp | date&time the shift was marked ready_for_delivery | unique to table |
visual_qc_completed_by_user_id | foreign key (int) | unique id of user that completed visual QC on forms in the shift | ㅤ |
phone_verification_completed_by_user_id | foreign key (int) | unique id of user that completed phone verification on forms in the shift | ㅤ |
qc_external | text | true/false field (whether QC is completed by outside organization) | ㅤ |
ready_for_qc_at | timestamp | date&time the shift was marked ready_for_qc | ㅤ |
type | text | type of shift - voter_registration | ㅤ |
completed_at | timestamp | date&time the shift was marked completed | ㅤ |
custom_field_data | jsonb | list of values entered during data entry into custom fields | ㅤ |
delivered | text | true/false field | ㅤ |