Shifts

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