Fivetran documentation

Search the docs

/

Jibble

Explore the interactive ERD

Table & Field Reference

location

Column	Type	Keys
`id`	Unknown	PK
`address`	Unknown
`code`	Unknown
`coordinates_latitude`	Unknown
`coordinates_longitude`	Unknown
`geo_fence_radius`	Unknown
`geo_fence_units`	Unknown
`name`	Unknown
`odata_etag`	Unknown

member_overridden_property

Column	Type	Keys
`overridden_property`	Unknown	PK
`member_id`	Unknown	PKFK

member

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`organization_id`	Unknown	FK
`schedule_id`	Unknown	FK
`calendar_id`	Unknown
`code`	Unknown
`country_code`	Unknown
`created_at`	Unknown
`email`	Unknown
`full_name`	Unknown
`has_embedding`	Unknown
`invited_at`	Unknown
`join_date`	Unknown
`kiosk`	Json
`latest_time_entry_time`	Unknown
`managed_unit`	Json
`manager`	Json
`nfc_token`	Unknown
`odata_etag`	Unknown
`phone_number`	Unknown
`picture`	Unknown
`pin_code`	Unknown
`position_id`	Unknown
`preferred_name`	Unknown
`project`	Json
`removed_at`	Unknown
`role`	Unknown
`status`	Unknown
`unit_time_off_policies`	Json
`updated_at`	Instant
`user_id`	Unknown
`work_start_date`	Unknown
`work_types`	Json
`custom_`

organization

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`face_recognition_model_id`	Unknown
`name`	Unknown
`odata_etag`	Unknown
`status`	Unknown
`updated_at`	Unknown
`custom_`

role

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`description`	Unknown
`do_propagate_name`	Unknown
`name`	Unknown
`orders`	Unknown
`organization_role_policy`	Json
`role_policies`	Json
`user_roles`	Json

time_off_holiday

Column	Type	Keys
`date`	Unknown	PK
`time_off_overview_id`	Unknown	PKFK
`is_short_day`	Unknown
`name`	Unknown
`rule`	Json

time_off_overview

Column	Type	Keys
`id`	Unknown	PK
`person_id`	Unknown	FK
`duration`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`kind`	Unknown
`note`	Unknown
`part_day_leave_duration`	Unknown
`part_of_day`	Unknown
`policy_id`	Unknown
`start_date`	Instant
`start_time`	Unknown
`status`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`schedule_id`	Unknown	FK
`activity`	Json
`calendar_id`	Unknown
`created_at`	Unknown
`first_approver`	Json
`kiosk`	Json
`manager`	Json
`name`	Unknown
`odata_etag`	Unknown
`overridden_property`	Json
`project`	Json
`second_approvers`	Json
`status`	Unknown
`unit_time_off_policy`	Json
`updated_at`	Instant
`work_type`	Json
`custom_`

timesheet_auto_deduction

Column	Type	Keys
`index`	Unknown	PK
`date`	Unknown	PKFK
`timesheet_id`	Unknown	PKFK
`duration`	Unknown
`name`	Unknown
`threshold`	Unknown

timesheet_daily

Column	Type	Keys
`date`	Unknown	PK
`timesheet_id`	Unknown	PKFK
`daily_double_overtime_is_edited`	Unknown
`daily_double_overtime_payroll_hour_id`	Unknown
`daily_double_overtime_time`	Unknown
`daily_overtime_is_edited`	Unknown
`daily_overtime_payroll_hour_id`	Unknown
`daily_overtime_time`	Unknown
`end_offset`	Unknown
`end_time`	Unknown
`first_in`	Unknown
`first_in_location_id`	Unknown
`first_in_offset`	Unknown
`first_in_timestamp`	Unknown
`has_archived_screenshots`	Unknown
`last_out`	Unknown
`last_out_location_id`	Unknown
`last_out_offset`	Unknown
`last_out_timestamp`	Unknown
`payroll_hours_billing`	Unknown
`payroll_hours_total`	Unknown
`public_holiday_overtime_is_edited`	Unknown
`public_holiday_overtime_payroll_hour_id`	Unknown
`public_holiday_overtime_time`	Unknown
`regular_is_edited`	Unknown
`regular_payroll_hour_id`	Unknown
`regular_time`	Unknown
`rest_day_overtime_is_edited`	Unknown
`rest_day_overtime_payroll_hour_id`	Unknown
`rest_day_overtime_time`	Unknown
`start_offset`	Unknown
`start_time`	Unknown
`time_off_holiday`	Json
`time_off_is_rest_day`	Unknown
`time_off_paid_time_off`	Unknown
`time_off_short_day`	Json
`time_off_type`	Json
`time_off_unpaid_time_off`	Unknown
`tracked_hours_added`	Unknown
`tracked_hours_breaks`	Json
`tracked_hours_paid_break_time`	Unknown
`tracked_hours_total`	Unknown
`tracked_hours_total_auto_deduction_time`	Unknown
`tracked_hours_total_break_time`	Unknown
`tracked_hours_unpaid_break_time`	Unknown
`tracked_hours_worked`	Unknown
`weekly_overtime_is_edited`	Unknown
`weekly_overtime_payroll_hour_id`	Unknown
`weekly_overtime_time`	Unknown

timesheet

Column	Type	Keys
`id`	Unknown	PK
`person_id`	Unknown	FK
`summary_added`	Unknown
`summary_auto_deduction_time`	Unknown
`summary_break_time`	Unknown
`summary_daily_double_overtime`	Unknown
`summary_daily_overtime`	Unknown
`summary_paid_break_time`	Unknown
`summary_paid_time_off`	Unknown
`summary_payroll`	Unknown
`summary_public_holiday_overtime`	Unknown
`summary_regular`	Unknown
`summary_rest_day_overtime`	Unknown
`summary_tracked`	Unknown
`summary_unpaid_break_time`	Unknown
`summary_unpaid_time_off`	Unknown
`summary_weekly_overtime`	Unknown
`summary_worked`	Unknown
`total`	Unknown
`total_payroll`	Unknown
`total_tracked`	Unknown

time_entry

Column	Type	Keys
`id`	Unknown	PK
`activity_id`	Unknown	FK
`location_id`	Unknown	FK
`next_time_entry_id`	Unknown	FK
`organization_id`	Unknown	FK
`person_id`	Unknown	FK
`previous_time_entry_id`	Unknown	FK
`address`	Unknown
`auto_clock_out_time`	Unknown
`belongs_to_date`	Unknown
`break_id`	Unknown
`client_type`	Unknown
`clock_in_out_reminder_time`	Unknown
`coordinate`	Unknown
`created_at`	Unknown
`event_id`	Unknown
`face_similarity`	Unknown
`is_automatic`	Unknown
`is_end_of_day`	Unknown
`is_face_recognized`	Unknown
`is_from_speed_kiosk`	Unknown
`is_locked`	Unknown
`is_manual`	Unknown
`is_manual_location`	Unknown
`is_offline`	Unknown
`is_outside_geofence`	Unknown
`is_unusual`	Unknown
`kiosk_id`	Unknown
`local_time`	Unknown
`note`	Unknown
`offsets`	Unknown
`picture`	Unknown
`platform_client_version`	Unknown
`platform_device_id`	Unknown
`platform_device_model`	Unknown
`platform_device_name`	Unknown
`platform_os`	Unknown
`project_id`	Unknown
`status`	Unknown
`time`	Unknown
`type`	Unknown
`updated_at`	Instant

schedule_auto_deduction

Column	Type	Keys
`index`	Unknown	PK
`schedule_id`	Unknown	PKFK
`duration`	Unknown
`name`	Unknown
`threshold`	Unknown

schedule_break

Column	Type	Keys
`id`	Unknown	PK
`schedule_id`	Unknown	PKFK
`allow_to_be_taken_from_to`	Unknown
`duration`	Unknown
`from_time`	Unknown
`name`	Unknown
`to_time`	Unknown

schedule_day

Column	Type	Keys
`index`	Unknown	PK
`schedule_id`	Unknown	PKFK
`day`	Unknown
`duration`	Unknown
`from_time`	Unknown
`to_time`	Unknown

schedule

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`breaks_type`	Unknown
`created_at`	Unknown
`daily_double_overtime_multiplier`	Unknown
`daily_overtime_multiplier`	Unknown
`defaults`	Unknown
`exclude_early_clock_in`	Unknown
`location`	Json
`name`	Unknown
`odata_etag`	Unknown
`overtime_daily`	Unknown
`overtime_daily_double`	Unknown
`overtime_daily_double_duration`	Unknown
`overtime_daily_double_from`	Unknown
`overtime_daily_duration`	Unknown
`overtime_daily_from`	Unknown
`overtime_end_work_day_at`	Unknown
`overtime_public_holiday`	Unknown
`overtime_rest_day`	Unknown
`overtime_time_range_style`	Unknown
`overtime_weekly`	Unknown
`overtime_weekly_duration`	Unknown
`public_holiday_overtime_multiplier`	Unknown
`rest_day_overtime_multiplier`	Unknown
`updated_at`	Instant
`weekly_hours`	Unknown
`weekly_overtime_multiplier`	Unknown
`work_arrangement`	Unknown

activity

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`assigned_group`	Json
`code`	Unknown
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`odata_etag`	Unknown
`status`	Unknown
`updated_at`	Instant