Performance_Reviews

Field	Type	Description	Joins
id	primary key (int)	unique id of performance review	performance_reviews_flags.performance_review_id, performance_reviews_shifts.performance_review_id
reasons	jsonb	reason selected for opening performance review	unique to table
status	text	status of performance review - open, ready_for_review, completed	unique to table
pull_from_field	text	t/f field whether the canvasser is pulled from field during performance review	unique to table
canvasser_id	foreign key (int)	unique id of canvasser in Blocks	canvassers.id
requested_by_user_id	foreign key (int)	unique id of user who requested performance review	users.id
assigned_to_used_id	foreign key (int)	unique id of user who the performance review is assigned to for review	users.id
created_at	timestamp	date&time performance review was created	unique to table
updated_at	timestamp	date&time performance review was last updated	unique to table
created_by_user_id	foreign key (int)	unique id of user who created the performance review	users.id
additional_details	text	additional details entered by the user creating the performance review	unique to table
timeline_events	jsonb	timeline events recorded on the performance review	unique to table
verification_start_date	timestamp	start date of verification data displayed on performance review	unique to table
verification_end_date	timestamp	end date of verification data displayed on performance review	unique to table
investigation_calls	integer	count of calls completed in performance review process	unique to table
investigation_contacts	integer	count of contacts made via calls completed in performance review process	unique to table
investigation_result	text	result of investigation	unique to table
outcome	text	outcome of performance review	unique to table
notes	text	additional notes on the performance review	unique to table
requested_changes	text	changes requested by reviewer on performance review before it can be completed	unique to table

No result found