Fivetran documentation

Search the docs

/

15Five

Explore the interactive ERD

Table & Field Reference

high_five_receiver

Column	Type	Keys
`index`	Unknown	PK
`high_five_id`	Unknown	PKFK
`receiver_id`	Unknown	FK
`url`	Unknown

high_five_email_receiver

Column	Type	Keys
`index`	Unknown	PK
`high_five_id`	Unknown	PKFK
`email`	Unknown

high_five

Column	Type	Keys
`id`	Unknown	PK
`creator_detail_id`	Unknown	FK
`create_ts`	Instant
`creator`	Unknown
`creator_id`	Unknown
`report`	Unknown
`text`	Unknown

security_audit

Column	Type	Keys
`create_ts`	Unknown	PK
`actor`	Unknown	FK
`type`	Unknown
`custom_`

group_type

Column	Type	Keys
`id`	Unknown	PK
`company_group_set`	Json	FK
`create_ts`	Unknown
`name_plural`	Unknown
`name_singular`	Unknown

feature

Column	Type	Keys
`_fivetran_id`	String	PK
`demographic_attribute`	Unknown
`pulse`	Unknown

one_on_one

Column	Type	Keys
`id`	Unknown	PK
`user_1_details_id`	Unknown	FK
`user_2_details_id`	Unknown	FK
`create_ts`	Unknown
`end_ts`	Unknown
`for_date`	Unknown
`is_draft`	Unknown
`user_1`	Unknown
`user_1_role`	Unknown
`user_2`	Unknown
`user_2_role`	Unknown

user_vacation

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`creation_date`	Unknown
`end_dt`	Unknown
`note`	Unknown
`start_dt`	Unknown

review_cycle_participant

Column	Type	Keys
`index`	Unknown	PK
`review_cycle_id`	Unknown	PKFK
`participant_id`	Unknown	FK

review_cycle

Column	Type	Keys
`id`	Unknown	PK
`creator_detail_id`	Unknown	FK
`actual_start_ts`	Unknown
`create_ts`	Instant
`cycle_end_ts`	Unknown
`cycle_start_ts`	Unknown
`days_remaining`	Unknown
`does_manager_review`	Unknown
`does_peer_review`	Unknown
`does_self_review`	Unknown
`does_upward_review`	Unknown
`hierarchy_update_ts`	Instant
`lock_ts`	Unknown
`manager_review_end_ts`	Unknown
`name`	Unknown
`peer_manager_approval_due_ts`	Unknown
`peer_review_end_ts`	Unknown
`peer_review_template_id`	Unknown
`peer_review_template_name`	Unknown
`peer_review_transparency`	Unknown
`peer_selection_due_ts`	Unknown
`self_review_end_ts`	Unknown
`share_and_finalize_end_ts`	Unknown
`statistics_number_of_reviews_completed`	Unknown
`statistics_number_of_reviews_uncompleted`	Unknown
`status`	Unknown
`template_id`	Unknown
`template_name`	Unknown
`update_ts`	Instant
`upward_review_end_ts`	Unknown
`upward_review_template_id`	Unknown
`upward_review_template_name`	Unknown
`upward_review_transparency`	Unknown
`viewing_permissions`	Unknown

question

Column	Type	Keys
`id`	Unknown	PK
`groups`	Unknown
`is_active`	Unknown
`is_optional`	Unknown
`metrics_params`	Json
`question_frequency`	Unknown
`question_text`	Unknown
`question_type`	Unknown
`users`	Unknown

check_in_comment

Column	Type	Keys
`_fivetran_id`	String	PK
`check_in_id`	Unknown	FK
`comment_text`	Unknown
`users`	Unknown

check_in_goal

Column	Type	Keys
`_fivetran_id`	String	PK
`check_in_id`	Unknown	FK
`goals`	Json

check_in_accomplishment

Column	Type	Keys
`_fivetran_id`	String	PK
`check_in_id`	Unknown	FK
`goals`	Json

check_in

Column	Type	Keys
`id`	Unknown	PK
`due_date`	Unknown
`high_five`	Json
`objective`	Json
`reporting_period`	Unknown
`reporting_period_end`	Unknown
`reporting_period_start`	Unknown
`reviewed_by`	Unknown
`reviewed_ts`	Unknown
`submit_ts`	Unknown
`users`	Unknown
`was_submitted_late`	Unknown

check_in_answer

Column	Type	Keys
`_fivetran_id`	String	PK
`answer_text`	Unknown
`check_in_id`	Unknown
`create_ts`	Unknown
`goal_completed_ts`	Unknown
`goal_status`	Unknown
`goal_status_comment`	Json
`metrics_value`	Unknown
`object_type`	Unknown
`question_text`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`create_ts`	Unknown
`group_admin`	Json
`group_type`	Unknown
`group_type_name`	Unknown
`is_peer_drilldown`	Unknown
`is_peer_view`	Unknown
`member`	Json
`members_count`	Unknown
`mention_name`	Unknown
`name`	Unknown
`skip_company_wide_question`	Unknown

company_group_id

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`company_group_id`	Unknown	FK

users

Column	Type	Keys
`id`	Unknown	PK
`bi_weekly_due_day`	Unknown
`bi_weekly_due_day_which_week`	Unknown
`current_checkin_streak`	Unknown
`due_day`	Unknown
`email`	Unknown
`employee_id`	Unknown
`first_login_ts`	Unknown
`first_name`	Unknown
`hire_date_ts`	Unknown
`is_active`	Unknown
`is_company_admin`	Unknown
`is_reporter`	Unknown
`is_reviewer`	Unknown
`last_login_ts`	Unknown
`last_name`	Unknown
`location`	Unknown
`mention_name`	Unknown
`monthly_due_day`	Unknown
`monthly_due_day_which_in_month`	Unknown
`phone`	Unknown
`reporting_period`	Unknown
`reviewer_id`	Unknown
`skip_company_wide_question`	Unknown
`start_date_ts`	Unknown
`title`	Unknown

answer

Column	Type	Keys
`id`	Unknown	PK
`answer_text`	Unknown
`comment`	Json
`create_ts`	Unknown
`goal_completed_ts`	Unknown
`goal_status`	Unknown
`goal_status_comment`	Json
`metrics_value`	Unknown
`question`	Unknown
`users`	Unknown

pulse

Column	Type	Keys
`id`	Unknown	PK
`create_ts`	Unknown
`report`	Unknown
`users`	Unknown
`value`	Unknown

people_attribute

Column	Type	Keys
`id`	Unknown	PK
`datatype`	Unknown
`is_default`	Unknown
`is_only_admin_editable`	Unknown
`name`	Unknown
`slug`	Unknown