Fivetran documentation

Search the docs

/

Tymeshift

Explore the interactive ERD

Table & Field Reference

report_data_metrics

Column	Type	Keys
`index`	Unknown	PK
`report_data_fivetran_id`	Unknown	PKFK
`key`	Unknown
`type`	Unknown
`value`	Unknown

report_data

Column	Type	Keys
`_fivetran_id`	String	PK
`report_template_id`	Unknown	FK
`children`	Json
`end_date`	Unknown
`item_key`	Unknown
`item_value`	Unknown
`start_date`	Unknown

agent_team

Column	Type	Keys
`index`	Unknown	PK
`agent_id`	Unknown	PKFK
`team_id`	Unknown

agent

Column	Type	Keys
`id`	Unknown	PK
`deactivated`	Unknown
`default_group_id`	Unknown
`email`	Unknown
`group_id`	Unknown
`is_deleted`	Unknown
`location_id`	Unknown
`name`	Unknown
`photo`	Unknown
`role_id`	Unknown
`shift_template_id`	Unknown
`tymeshift_account_id`	Unknown
`user_id`	Unknown

agent_activity

Column	Type	Keys
`id`	Unknown	PK
`agent_id`	Unknown	FK
`duration`	Unknown
`end_time`	Unknown
`event_type`	Unknown
`general_task_id`	Unknown
`is_paid`	Unknown
`lock_interval`	Unknown
`start_time`	Unknown
`ticket_id`	Unknown
`type`	Unknown
`user_id`	Unknown
`workstreams`	Json

report_template

Column	Type	Keys
`id`	Unknown	PK
`agent_id`	Json
`created_at`	Unknown
`created_by`	Unknown
`dimension_group_by`	Json
`dimension_interval`	Unknown
`file_structure`	Unknown
`filter_activity_type_id`	Unknown
`filter_group_id`	Json
`filter_interval`	Json
`filter_location_id`	Json
`filter_scopes`	Json
`filter_status`	Json
`filter_tags`	Json
`filter_team_id`	Json
`filter_ticket_customfield_option_key`	Json
`filter_ticket_id`	Json
`filter_ticket_via_type`	Json
`filter_timeoff_reason_id`	Json
`is_default`	Unknown
`metrics`	Json
`name`	Unknown
`timezone`	Unknown
`tymeshift_account_id`	Unknown
`type`	Unknown

published_schedule_workstream

Column	Type	Keys
`id`	Unknown	PK
`published_schedule_id`	Unknown	PKFK
`taskable_id`	Unknown	FK
`color`	Unknown
`created_at`	Unknown
`end_time`	Unknown
`name`	Unknown
`shift_id`	Unknown
`start_time`	Unknown
`taskable_type`	Unknown

published_schedule_general_task

Column	Type	Keys
`id`	Unknown	PK
`published_schedule_id`	Unknown	PKFK
`taskable_id`	Unknown	FK
`created_at`	Unknown
`end_time`	Unknown
`shift_id`	Unknown
`start_time`	Unknown
`taskable_type`	Unknown

published_schedule_task

Column	Type	Keys
`id`	Unknown	PK
`published_schedule_id`	Unknown	PKFK
`color`	Unknown
`created_at`	Unknown
`end_time`	Unknown
`name`	Unknown
`shift_id`	Unknown
`start_time`	Unknown
`taskable_id`	Unknown
`taskable_type`	Unknown

published_schedule

Column	Type	Keys
`id`	Unknown	PK
`agent_id`	Unknown	FK
`end_time`	Unknown
`parent_id`	Unknown
`published`	Unknown
`schedule_id`	Unknown
`start_time`	Unknown
`tymeshift_account_id`	Unknown

time_off

Column	Type	Keys
`id`	Unknown	PKFK
`time_off`	Json

contact_method_key

Column	Type	Keys
`index`	Unknown	PK
`workstream_id`	Unknown	PKFK
`contact_method_key`	Unknown

workstream_condition_all

Column	Type	Keys
`index`	Unknown	PK
`workstream_id`	Unknown	PKFK
`field`	Unknown
`operator`	Unknown
`value`	Unknown

workstream_condition_any

Column	Type	Keys
`index`	Unknown	PK
`workstream_id`	Unknown	PKFK
`field`	Unknown
`operator`	Unknown
`value`	Unknown

inbound_volume_adjustment

Column	Type	Keys
`id`	Unknown	PK
`workstream_id`	Unknown	PKFK
`active`	Unknown
`change`	Unknown
`change_type`	Unknown
`end_time`	Unknown
`name`	Unknown
`start_time`	Unknown
`tymeshift_account_id`	Unknown

availability_hour

Column	Type	Keys
`index`	Unknown	PK
`workstream_id`	Unknown	PKFK
`day_of_the_week`	Unknown
`end_time`	Unknown
`is_active`	Unknown
`start_time`	Unknown

workstream_agent

Column	Type	Keys
`agent_id`	Unknown	PKFK
`workstream_id`	Unknown	PKFK

workstream

Column	Type	Keys
`id`	Unknown	PK
`actual_algorithm`	Unknown
`color`	Unknown
`condition_id`	Unknown
`condition_tymeshift_account_id`	Unknown
`contact_method_group`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`exclude_inbound_volume_outliers`	Unknown
`forecast_algorithm`	Unknown
`full_time_equivalent_availability`	Unknown
`full_time_equivalent_availability_timezone`	Unknown
`full_time_equivalent_average_handle_time`	Unknown
`full_time_equivalent_average_handle_time_type`	Unknown
`full_time_equivalent_channel`	Unknown
`full_time_equivalent_concurrency`	Unknown
`full_time_equivalent_id`	Unknown
`full_time_equivalent_max_occupancy_rate`	Unknown
`full_time_equivalent_minimum_staffing`	Unknown
`full_time_equivalent_shrinkage`	Unknown
`full_time_equivalent_target_service_level`	Unknown
`full_time_equivalent_target_time`	Unknown
`full_time_equivalent_tymeshift_account_id`	Unknown
`full_time_equivalent_workstream_id`	Unknown
`ignore_data_prior_to_date`	Unknown
`imported_historical_volume`	Unknown
`inbound_volume_outlier`	Json
`is_deleted`	Unknown
`name`	Unknown
`orders`	Unknown
`priority`	Unknown
`tymeshift_account_id`	Unknown
`use_all_zendesk_data`	Unknown
`visible`	Unknown

task_permitted_team

Column	Type	Keys
`permitted_team_id`	Unknown	PK
`general_task_id`	Unknown	PKFK

task_permitted_team_without_scoping

Column	Type	Keys
`permitted_team_id_without_scoping`	Unknown	PK
`general_task_id`	Unknown	PKFK

general_task

Column	Type	Keys
`id`	Unknown	PK
`color`	Unknown
`deleted_at`	Unknown
`exclude_occupancy`	Unknown
`is_deleted`	Unknown
`is_paid`	Unknown
`job_id`	Unknown
`name`	Unknown
`permitted_team_preset`	Unknown
`productive_time`	Unknown
`talk_status`	Unknown