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	Joins
id	primary key (int)	unique shift id	performance_reviews_shifts.shift_id, quality_control_flags.shift_id, registration_forms.shift_id
location_id	foreign key (int)	unique location id of location of shift	locations.id
canvasser_id	foreign key (int)	id from canvassers table of canvasser attached to shift	canvassers.id
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	users.id
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	users.id
phone_verification_completed_by_user_id	foreign key (int)	unique id of user that completed phone verification on forms in the shift	users.id
qc_external	text	t/f field (whether QC is completed by outside organization)	unique to table
ready_for_qc_at	timestamp	date&time the shift was marked ready_for_qc	unique to table
type	text	type of shift - voter_registration	unique to table
completed_at	timestamp	date&time the shift was marked completed	unique to table
tags	jsonb	list of tags associated with shift via api	unique to table
custom_field_data	jsonb	list of values entered during data entry into custom fields	unique to table
delivered	text	t/f field if all forms in shift are associated to a completed delivery	unique to table
name	text	filename of packet uploaded to shift	unique to table
forms_count	integer	count of registration_forms associated with the shift	unique to table
assignee_id	foreign key (int)	id of user assigned to the packet in quality control	users.id
qc_deadline	timestamp	timestamp of set deadline to complete quality control	unique to table

No result found