# Genesys schema ERD

Table and field reference for the Fivetran Genesys connector.

## Table & Field Reference

### user_skill_group_skill_condition_routing_skill_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| user_skill_group_id | Unknown | FK |
| child_condition | Json |  |
| comparator | Unknown |  |
| proficiency | Unknown |  |
| routing_skill | Unknown |  |

### user_skill_group_skill_condition_language_skill_condition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| user_skill_group_id | Unknown | FK |
| child_condition | Json |  |
| comparator | Unknown |  |
| language_skill | Unknown |  |
| proficiency | Unknown |  |

### user_skill_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| division_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| description | Unknown |  |
| member_count | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |

### user_call_forwarding_target

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_call_forwarding_id | Unknown | FK |
| user_id | Unknown | FK |
| type | Unknown |  |
| value | Unknown |  |

### user_call_forwarding

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| enabled | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| self_uri | Unknown |  |
| voicemail | Unknown |  |

### evaluation_answer_question_group_question_score

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| evaluation_answer_question_group_score_question_group_id | Unknown | PK, FK |
| evaluation_id | Unknown | PK, FK |
| answer_id | Unknown |  |
| assisted_answer_id | Unknown |  |
| comments | Unknown |  |
| failed_kill_question | Unknown |  |
| marked_na | Unknown |  |
| score | Unknown |  |
| system_marked_na | Unknown |  |

### evaluation_answer_question_group_score

| Column | Type | Keys |
| --- | --- | --- |
| question_group_id | Unknown | PK |
| evaluation_id | Unknown | PK, FK |
| marked_na | Unknown |  |
| max_total_critical_score | Unknown |  |
| max_total_critical_score_unweighted | Unknown |  |
| max_total_non_critical_score | Unknown |  |
| max_total_non_critical_score_unweighted | Unknown |  |
| max_total_score | Unknown |  |
| max_total_score_unweighted | Unknown |  |
| system_marked_na | Unknown |  |
| total_critical_score | Unknown |  |
| total_critical_score_unweighted | Unknown |  |
| total_non_critical_score | Unknown |  |
| total_non_critical_score_unweighted | Unknown |  |
| total_score | Unknown |  |
| total_score_unweighted | Unknown |  |

### evaluation_answer_transcript_topic

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evaluation_id | Unknown | PK, FK |
| confidence | Unknown |  |
| duration_total_milliseconds | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| offset_charactercount | Unknown |  |
| offset_wordcount | Unknown |  |
| recording_location | Unknown |  |
| start_time_milliseconds | Unknown |  |
| topic_phrase | Unknown |  |
| transcript_phrase | Unknown |  |

### evaluation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_team_division_id | Unknown | FK |
| assignee_id | Unknown | FK |
| calibration_id | Unknown | FK |
| evaluation_form_id | Unknown | FK |
| evaluator_id | Unknown | FK |
| queue_id | Unknown | FK |
| agent_has_read | Unknown |  |
| agent_id | Unknown |  |
| agent_team_date_created | Unknown |  |
| agent_team_date_modified | Unknown |  |
| agent_team_description | Unknown |  |
| agent_team_id | Unknown |  |
| agent_team_member_count | Unknown |  |
| agent_team_name | Unknown |  |
| agent_team_self_uri | Unknown |  |
| answer_agent_comments | Unknown |  |
| answer_any_failed_kill_questions | Unknown |  |
| answer_comments | Unknown |  |
| answer_private_comments | Unknown |  |
| answer_question_group_scores | Unknown |  |
| answer_total_critical_score | Unknown |  |
| answer_total_non_critical_score | Unknown |  |
| answer_total_score | Unknown |  |
| assigned | Unknown |  |
| assigned_date | Unknown |  |
| assignee_applicable | Unknown |  |
| changed_date | Unknown |  |
| conversation_date | Unknown |  |
| conversation_end_date | Unknown |  |
| conversation_id | Unknown |  |
| date_assignee_changed | Unknown |  |
| evaluation_source_id | Unknown |  |
| evaluation_source_name | Unknown |  |
| evaluation_source_self_uri | Unknown |  |
| evaluation_source_type | Unknown |  |
| has_assistance_failed | Unknown |  |
| is_scoring_index | Unknown |  |
| name | Unknown |  |
| never_release | Unknown |  |
| redacted | Unknown |  |
| release_date | Unknown |  |
| rescore | Unknown |  |
| resource_id | Unknown |  |
| resource_type | Unknown |  |
| revision_created_date | Unknown |  |
| self_uri | Unknown |  |
| status | Unknown |  |

### users_group

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| id | Unknown | PK, FK |

### agent_activity_evaluator_list_contact_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_activity_evaluator_list_index | Unknown | PK, FK |
| agent_activity_fivetran_id | Unknown | PK, FK |
| address | Unknown |  |
| media_type | Unknown |  |
| type | Unknown |  |

### agent_activity_evaluator_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_activity_fivetran_id | Unknown | PK, FK |
| agent_id | Unknown | FK |
| evaluator_id | Unknown | FK |
| average_evaluation_score | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| num_evaluation | Unknown |  |
| num_evaluations_without_view_permission | Unknown |  |

### agent_activity

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown | FK |
| integration_presence_definition_id | Unknown | FK |
| presence_definition_id | Unknown | FK |
| average_critical_score | Unknown |  |
| average_evaluation_score | Unknown |  |
| highest_critical_score | Unknown |  |
| highest_evaluation_score | Unknown |  |
| id | Unknown |  |
| lowest_critical_score | Unknown |  |
| lowest_evaluation_score | Unknown |  |
| name | Unknown |  |
| num_critical_evaluations | Unknown |  |
| num_evaluations | Unknown |  |
| num_evaluations_without_view_permission | Unknown |  |

### aggregate_query_conversation_survey_answer_question_group_question_score

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| conversation_survey_answer_question_group_score_index | Unknown | PK, FK |
| conversation_survey_id | Unknown | PK, FK |
| answer_id | Unknown |  |
| assisted_answer_id | Unknown |  |
| free_text_answer | Unknown |  |
| marked_na | Unknown |  |
| nps_score | Unknown |  |
| nps_text_answer | Unknown |  |
| question_id | Unknown |  |
| score | Unknown |  |
| system_marked_na | Unknown |  |

### aggregate_query_conversation_survey_answer_question_group_score

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| conversation_survey_id | Unknown | PK, FK |
| marked_na | Unknown |  |
| max_total_score | Unknown |  |
| question_group_id | Unknown |  |
| system_marked_na | Unknown |  |
| total_score | Unknown |  |

### aggregate_query_conversation_survey

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| queue_id | Unknown | FK |
| survey_form_id | Unknown | FK |
| agent_team_date_created | Unknown |  |
| agent_team_date_modified | Unknown |  |
| agent_team_description | Unknown |  |
| agent_team_division_id | Unknown |  |
| agent_team_division_name | Unknown |  |
| agent_team_id | Unknown |  |
| agent_team_member_count | Unknown |  |
| agent_team_name | Unknown |  |
| agent_team_self_uri | Unknown |  |
| answer_nps_score | Unknown |  |
| answer_total_score | Unknown |  |
| completed_date | Unknown |  |
| flow_id | Unknown |  |
| missing_required_answer | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| status | Unknown |  |
| survey_error_flow_diagnostic_last_action_id | Unknown |  |
| survey_error_survey_error_reason | Unknown |  |
| survey_type | Unknown |  |

### flow_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |

### campaign_diagnostic_dnc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| dnc_id | Unknown | FK |

### campaign_diagnostic_rule_set

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| rule_set_id | Unknown | FK |

### campaign_rule_set_diagnostic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| rule_set_id | Unknown | FK |
| warnings | Json |  |

### campaign_diagnostic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| attempt_limit_id | Unknown | FK |
| callable_time_set_id | Unknown | FK |
| campaign_id | Unknown | FK |
| queue_utilization_diagnostic_queue_id | Unknown | FK |
| campaign_skill_statistics_eligible_skilled_agent | Unknown |  |
| campaign_skill_statistics_skill_combination | Unknown |  |
| outstanding_interactions_count | Unknown |  |
| queue_utilization_diagnostic_active_users_in_queue | Unknown |  |
| queue_utilization_diagnostic_users_in_queue | Unknown |  |
| queue_utilization_diagnostic_users_not_utilized | Unknown |  |
| queue_utilization_diagnostic_users_on_a_campaign_call | Unknown |  |
| queue_utilization_diagnostic_users_on_a_non_campaign_call | Unknown |  |
| queue_utilization_diagnostic_users_on_different_edge_group | Unknown |  |
| queue_utilization_diagnostic_users_on_queue | Unknown |  |
| queue_utilization_diagnostic_users_on_queue_with_station | Unknown |  |
| scheduled_interactions_count | Unknown |  |
| timezone_rescheduled_calls_count | Unknown |  |

### intraday_planning_routepath

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| intraday_planning_date | Unknown | PK, FK |
| intraday_planning_id | Unknown | PK, FK |
| language_id | Unknown |  |
| language_self_uri | Unknown |  |
| media_type | Unknown |  |
| queue_id | Unknown |  |
| queue_self_uri | Unknown |  |
| skills | Json |  |

### intraday_planning

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| abandon_rate | Unknown |  |
| abandon_rate_percent | Unknown |  |
| average_speed_of_answer_second | Unknown |  |
| decrease_by_percent | Unknown |  |
| increase_by_percent | Unknown |  |
| name | Unknown |  |
| service_level_percent | Unknown |  |
| service_level_second | Unknown |  |

### campaign_progress

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| contact_list_id | Unknown | FK |
| number_of_contact_call | Unknown |  |
| number_of_contact_message | Unknown |  |
| number_of_contact_skipped | Json |  |
| percentage | Unknown |  |
| total_number_of_contact | Unknown |  |

### management_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| setting_adherence_adherence_exception_threshold_second | Unknown |  |
| setting_adherence_adherence_target_percent | Unknown |  |
| setting_adherence_ignored_activity_categories | Json |  |
| setting_adherence_non_on_queue_activities_equivalent | Unknown |  |
| setting_adherence_severe_alert_threshold_minute | Unknown |  |
| setting_adherence_track_on_queue_activity | Unknown |  |
| setting_scheduling_default_shrinkage_percent | Unknown |  |
| setting_scheduling_max_occupancy_percent_for_deferred_work | Unknown |  |
| setting_scheduling_shrinkage_override_values | Json |  |
| setting_scheduling_start_day_of_weekend | Unknown |  |
| setting_shift_trading_allow_direct_trades | Unknown |  |
| setting_shift_trading_auto_review | Unknown |  |
| setting_shift_trading_enabled | Unknown |  |
| setting_shift_trading_max_trade_span_weeks | Unknown |  |
| setting_shift_trading_max_trades_per_agent_per_week | Unknown |  |
| setting_shift_trading_min_hours_in_future | Unknown |  |
| setting_shift_trading_min_minutes_between_shifts | Unknown |  |
| setting_shift_trading_min_minutes_between_shifts_violations | Unknown |  |
| setting_shift_trading_one_sided | Unknown |  |
| setting_shift_trading_planning_period_max_paid_violations | Unknown |  |
| setting_shift_trading_planning_period_min_paid_violations | Unknown |  |
| setting_shift_trading_requires_matching_languages | Unknown |  |
| setting_shift_trading_requires_matching_planning_groups | Unknown |  |
| setting_shift_trading_requires_matching_queues | Unknown |  |
| setting_shift_trading_requires_matching_skills | Unknown |  |
| setting_shift_trading_unequal_paid | Unknown |  |
| setting_shift_trading_weekly_max_paid_violations | Unknown |  |
| setting_shift_trading_weekly_min_paid_violations | Unknown |  |
| setting_timeoff_submission_earliest_day_from_now | Unknown |  |
| setting_timeoff_submission_latest_day_from_now | Unknown |  |
| setting_timeoff_submission_range_enforced | Unknown |  |
| shrinkage_override_value | Json |  |
| start_day_of_week | Unknown |  |
| time_zone | Unknown |  |
| version | Unknown |  |

### messaging_campaign_dnc

| Column | Type | Keys |
| --- | --- | --- |
| dnc_id | Unknown | PK, FK |
| messaging_campaign_id | Unknown | PK, FK |

### messaging_campaign_contact_sort

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| messaging_campaign_id | Unknown | PK, FK |
| direction | Unknown |  |
| field_name | Unknown |  |
| numeric | Unknown |  |

### messaging_campaign_contact_list_filter

| Column | Type | Keys |
| --- | --- | --- |
| contact_list_filter_id | Unknown | PK, FK |
| messaging_campaign_id | Unknown | PK, FK |

### messaging_campaign_rule_set

| Column | Type | Keys |
| --- | --- | --- |
| messaging_campaign_id | Unknown | PK, FK |
| rule_set_id | Unknown | PK, FK |

### messaging_campaign_error

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| messaging_campaign_id | Unknown | FK |
| details | Unknown |  |
| error | Unknown |  |

### messaging_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| callable_time_set_id | Unknown | FK |
| contact_list_id | Unknown | FK |
| division_id | Unknown | FK |
| always_running | Unknown |  |
| campaign_status | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| dynamic_contact_queueing_settings_sort | Unknown |  |
| email_config_content_template_id | Unknown |  |
| email_config_content_template_name | Unknown |  |
| email_config_content_template_self_uri | Unknown |  |
| email_config_email_column | Json |  |
| email_config_from_address_domain_id | Unknown |  |
| email_config_from_address_domain_name | Unknown |  |
| email_config_from_address_domain_self_uri | Unknown |  |
| email_config_from_address_friendly_name | Unknown |  |
| email_config_from_address_local_part | Unknown |  |
| email_config_reply_address_domain_id | Unknown |  |
| email_config_reply_address_domain_name | Unknown |  |
| email_config_reply_address_domain_self_uri | Unknown |  |
| email_config_reply_address_route_id | Unknown |  |
| email_config_reply_address_route_name | Unknown |  |
| email_config_reply_address_route_self_uri | Unknown |  |
| messages_per_minute | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| sms_config_content_template_id | Unknown |  |
| sms_config_content_template_name | Unknown |  |
| sms_config_content_template_self_uri | Unknown |  |
| sms_config_message_column | Unknown |  |
| sms_config_phone_column | Unknown |  |
| sms_config_sender_sms_phone_number | Unknown |  |
| sms_config_sender_sms_phone_number_self_uri | Unknown |  |
| version | Unknown |  |

### flow_data_table

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |
| schema_additional_properties | Json |  |
| schema_description | Unknown |  |
| schema_id | Unknown |  |
| schema_properties | Json |  |
| schema_required | Json |  |
| schema_schema | Unknown |  |
| schema_title | Unknown |  |
| schema_type | Unknown |  |
| self_uri | Unknown |  |

### analytics_conversation_aggregate_query_data_metrics

| Column | Type | Keys |
| --- | --- | --- |
| analytics_conversation_aggregate_query_data_index | Unknown | PK |
| conversation_id | Unknown | PK |
| index | Unknown | PK |
| interval | Unknown |  |
| media_type | Unknown |  |
| metric | Unknown |  |
| qualifier | Unknown |  |
| stats_count | Unknown |  |
| stats_count_negative | Unknown |  |
| stats_count_positive | Unknown |  |
| stats_current | Unknown |  |
| stats_denominator | Unknown |  |
| stats_max | Unknown |  |
| stats_min | Unknown |  |
| stats_numerator | Unknown |  |
| stats_p_95 | Unknown |  |
| stats_p_99 | Unknown |  |
| stats_ratio | Unknown |  |
| stats_sum | Unknown |  |
| stats_target | Unknown |  |

### campaign_agent_mapping_review_result

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| agent_owned_column | Unknown |  |
| campaign_id | Unknown |  |
| email | Unknown |  |
| exists | Unknown |  |
| is_queue_member | Unknown |  |
| record_count | Unknown |  |

### routing_queue_routing_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| routing_queue_id | Unknown | FK |
| operator | Unknown |  |
| threshold | Unknown |  |
| wait_seconds | Unknown |  |

### routing_queue_conditional_group_routing_rule_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| index | Unknown | PK, FK |
| routing_queue_id | Unknown | PK, FK |

### routing_queue_conditional_group_routing_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| routing_queue_id | Unknown | PK, FK |
| condition_value | Unknown |  |
| metric | Unknown |  |
| operator | Unknown |  |
| wait_seconds | Unknown |  |

### routing_queue_bulls_eye_ring_expansion_criteria

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| routing_queue_id | Unknown | FK |
| threshold | Unknown |  |
| type | Unknown |  |

### routing_queue_bulls_eye_ring_skill_to_remove

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| routing_queue_id | Unknown | PK, FK |
| name | Unknown |  |
| self_uri | Unknown |  |

### routing_queue_bulls_eye_ring_member_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| routing_queue_id | Unknown | PK, FK |
| member_count | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| type | Unknown |  |

### routing_queue_member_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| routing_queue_id | Unknown | PK, FK |
| member_count | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| type | Unknown |  |

### routing_queue_email_address_route_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| routing_queue_id | Unknown | PK, FK |
| name | Unknown |  |
| self_uri | Unknown |  |

### routing_queue_email_address_auto_bcc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| routing_queue_id | Unknown | FK |
| email | Unknown |  |
| name | Unknown |  |

### routing_queue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| acw_settings_timeout_ms | Unknown |  |
| acw_settings_wrapup_prompt | Unknown |  |
| agent_owned_routing_enable_agent_owned_call_back | Unknown |  |
| agent_owned_routing_max_owned_call_back_delay_hours | Unknown |  |
| agent_owned_routing_max_owned_call_back_hours | Unknown |  |
| auto_answer_only | Unknown |  |
| calling_party_name | Unknown |  |
| calling_party_number | Unknown |  |
| created_by | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| default_script | Json |  |
| description | Unknown |  |
| direct_routing_agent_wait_second | Unknown |  |
| direct_routing_backup_queue_id | Unknown |  |
| direct_routing_call_media_settingenabled | Unknown |  |
| direct_routing_call_media_settinginbound_flow_id | Unknown |  |
| direct_routing_call_media_settinginbound_self_uri | Unknown |  |
| direct_routing_call_media_settingvoice_mail_flow | Unknown |  |
| direct_routing_email_media_settingenabled | Unknown |  |
| direct_routing_email_media_settinginbound_flow_id | Unknown |  |
| direct_routing_email_media_settinginbound_self_uri | Unknown |  |
| direct_routing_enabled | Unknown |  |
| direct_routing_message_media_setting | Unknown |  |
| direct_routing_wait_for_agent | Unknown |  |
| email_in_queue_flow_id | Unknown |  |
| email_in_queue_flow_name | Unknown |  |
| email_in_queue_flow_self_uri | Unknown |  |
| enable_manual_assignment | Unknown |  |
| enable_transcription | Unknown |  |
| joined_member_count | Unknown |  |
| media_settings_call_alerting_timeout_seconds | Unknown |  |
| media_settings_call_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_call_enable_auto_answer | Unknown |  |
| media_settings_call_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_call_service_level | Unknown |  |
| media_settings_call_sub_type_setting | Json |  |
| media_settings_callback_alerting_timeout_seconds | Unknown |  |
| media_settings_callback_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_callback_enable_auto_answer | Unknown |  |
| media_settings_callback_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_callback_service_level | Unknown |  |
| media_settings_callback_sub_type_setting | Json |  |
| media_settings_chat_alerting_timeout_seconds | Unknown |  |
| media_settings_chat_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_chat_enable_auto_answer | Unknown |  |
| media_settings_chat_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_chat_service_level | Unknown |  |
| media_settings_chat_sub_type_setting | Json |  |
| media_settings_email_alerting_timeout_seconds | Unknown |  |
| media_settings_email_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_email_enable_auto_answer | Unknown |  |
| media_settings_email_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_email_service_level | Unknown |  |
| media_settings_email_sub_type_setting | Json |  |
| media_settings_message_alerting_timeout_seconds | Unknown |  |
| media_settings_message_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_message_enable_auto_answer | Unknown |  |
| media_settings_message_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_message_service_level | Unknown |  |
| media_settings_message_sub_type_setting | Json |  |
| member_count | Unknown |  |
| message_in_queue_flow_id | Unknown |  |
| message_in_queue_flow_name | Unknown |  |
| message_in_queue_flow_self_uri | Unknown |  |
| modified_by | Unknown |  |
| name | Unknown |  |
| on_hold_prompt_id | Unknown |  |
| on_hold_prompt_name | Unknown |  |
| on_hold_prompt_self_uri | Unknown |  |
| outbound_messaging_addresses_open_messaging_recipient_id | Unknown |  |
| outbound_messaging_addresses_open_messaging_recipient_name | Unknown |  |
| outbound_messaging_addresses_open_messaging_recipient_self_uri | Unknown |  |
| outbound_messaging_addresses_sms_address_name | Unknown |  |
| outbound_messaging_addresses_sms_address_self_uri | Unknown |  |
| outbound_messaging_addresses_sms_adress_id | Unknown |  |
| outbound_messaging_addresses_whats_app_recipient_id | Unknown |  |
| outbound_messaging_addresses_whats_app_recipient_name | Unknown |  |
| outbound_messaging_addresses_whats_app_recipient_self_uri | Unknown |  |
| peer_id | Unknown |  |
| queue_flow_id | Unknown |  |
| queue_flow_name | Unknown |  |
| queue_flow_self_uri | Unknown |  |
| reply_email_address_domain_id | Unknown |  |
| reply_email_address_domain_name | Unknown |  |
| reply_email_address_domain_self_uri | Unknown |  |
| reply_email_address_route_allow_multiple_actions | Unknown |  |
| reply_email_address_route_always_included | Unknown |  |
| reply_email_address_route_flow_id | Unknown |  |
| reply_email_address_route_flow_name | Unknown |  |
| reply_email_address_route_flow_self_uri | Unknown |  |
| reply_email_address_route_from_email | Unknown |  |
| reply_email_address_route_from_name | Unknown |  |
| reply_email_address_route_history_inclusion | Unknown |  |
| reply_email_address_route_id | Unknown |  |
| reply_email_address_route_inclusion_type | Unknown |  |
| reply_email_address_route_language_id | Unknown |  |
| reply_email_address_route_language_name | Unknown |  |
| reply_email_address_route_language_self_url | Unknown |  |
| reply_email_address_route_name | Unknown |  |
| reply_email_address_route_pattern | Unknown |  |
| reply_email_address_route_priority | Unknown |  |
| reply_email_address_route_queue_id | Unknown |  |
| reply_email_address_route_reply_email_address | Json |  |
| reply_email_address_route_self_uri | Unknown |  |
| reply_email_address_route_signature_canned_response_id | Unknown |  |
| reply_email_address_route_signature_enabled | Unknown |  |
| reply_email_address_route_spam_flow_id | Unknown |  |
| reply_email_address_route_spam_flow_name | Unknown |  |
| reply_email_address_route_spam_flow_self_uri | Unknown |  |
| scoring_method | Unknown |  |
| self_uri | Unknown |  |
| skill_evaluation_method | Unknown |  |
| suppress_in_queue_call_recording | Unknown |  |
| user_member_count | Unknown |  |
| whisper_prompt_id | Unknown |  |
| whisper_prompt_name | Unknown |  |
| whisper_prompt_self_uri | Unknown |  |

### conversation_participant_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | Unknown | PK |
| conversation_id | Unknown | PK |
| participant_id | Unknown | PK |
| attribute_value | Unknown |  |

### head_count_forecast_entities

| Column | Type | Keys |
| --- | --- | --- |
| business_unit_id | Unknown | PK |
| index | Unknown | PK |
| reference_start_date | Unknown | PK |
| schedule_id | Unknown | PK |
| schedule_week_date | Unknown | PK |
| planning_group_id | Unknown |  |
| planning_group_self_uri | Unknown |  |
| required_per_interval | Json |  |
| required_without_shrinkage_per_interval | Json |  |

### conversation_call_history_participants

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_call_history_id | Unknown | PK, FK |
| campaign_id | Unknown | FK |
| group_id | Unknown | FK |
| queue_id | Unknown | FK |
| user_id | Unknown | FK |
| address | Unknown |  |
| ani | Unknown |  |
| did_interact | Unknown |  |
| direction | Unknown |  |
| disconnect_type | Unknown |  |
| dnis | Unknown |  |
| end_time | Unknown |  |
| external_canonical_contact_id | Unknown |  |
| external_canonical_contact_self_uri | Unknown |  |
| external_contact_address_address_1 | Unknown |  |
| external_contact_address_address_2 | Unknown |  |
| external_contact_address_city | Unknown |  |
| external_contact_address_country_code | Unknown |  |
| external_contact_address_postal_code | Unknown |  |
| external_contact_address_state | Unknown |  |
| external_contact_cellphone_accepts_sms | Unknown |  |
| external_contact_cellphone_country_code | Unknown |  |
| external_contact_cellphone_display | Unknown |  |
| external_contact_cellphone_e_164 | Unknown |  |
| external_contact_cellphone_extension | Unknown |  |
| external_contact_cellphone_user_input | Unknown |  |
| external_contact_create_date | Unknown |  |
| external_contact_custom_fields | Json |  |
| external_contact_external_data_source | Json |  |
| external_contact_external_organization_id | Unknown |  |
| external_contact_external_system_url | Unknown |  |
| external_contact_facebook_id | Json |  |
| external_contact_facebook_id_displayname | Unknown |  |
| external_contact_first_name | Unknown |  |
| external_contact_homephone_accepts_sms | Unknown |  |
| external_contact_homephone_country_code | Unknown |  |
| external_contact_homephone_display | Unknown |  |
| external_contact_homephone_e_164 | Unknown |  |
| external_contact_homephone_extension | Unknown |  |
| external_contact_homephone_user_input | Unknown |  |
| external_contact_id | Unknown |  |
| external_contact_json_schema | Unknown |  |
| external_contact_json_schema_additional_properties | Json |  |
| external_contact_json_schema_description | Unknown |  |
| external_contact_json_schema_id | Unknown |  |
| external_contact_json_schema_properties | Json |  |
| external_contact_json_schema_required | Json |  |
| external_contact_json_schema_title | Unknown |  |
| external_contact_json_schema_type | Unknown |  |
| external_contact_last_name | Unknown |  |
| external_contact_line_id | Json |  |
| external_contact_line_id_display_name | Unknown |  |
| external_contact_merge_operation_resulting_contact_id | Unknown |  |
| external_contact_merge_operation_resulting_contact_self_uri | Unknown |  |
| external_contact_merge_operation_source_contact_id | Unknown |  |
| external_contact_merge_operation_source_contact_self_uri | Unknown |  |
| external_contact_merge_operation_target_contact_id | Unknown |  |
| external_contact_merge_operation_target_contact_self_uri | Unknown |  |
| external_contact_merge_set | Json |  |
| external_contact_middle_name | Unknown |  |
| external_contact_modify_date | Unknown |  |
| external_contact_other_email | Unknown |  |
| external_contact_other_phone_accepts_sms | Unknown |  |
| external_contact_other_phone_country_code | Unknown |  |
| external_contact_other_phone_display | Unknown |  |
| external_contact_other_phone_e_164 | Unknown |  |
| external_contact_other_phone_extension | Unknown |  |
| external_contact_other_phone_user_input | Unknown |  |
| external_contact_personal_email | Unknown |  |
| external_contact_salutation | Unknown |  |
| external_contact_schema_applies_to | Unknown |  |
| external_contact_schema_created_by_id | Unknown |  |
| external_contact_schema_date_created | Unknown |  |
| external_contact_schema_enabled | Unknown |  |
| external_contact_schema_id | Unknown |  |
| external_contact_schema_name | Unknown |  |
| external_contact_schema_self_uri | Unknown |  |
| external_contact_schema_version | Unknown |  |
| external_contact_self_uri | Unknown |  |
| external_contact_survey_opt_out | Unknown |  |
| external_contact_title | Unknown |  |
| external_contact_twitter_id | Unknown |  |
| external_contact_twitter_id_id | Unknown |  |
| external_contact_twitter_id_name | Unknown |  |
| external_contact_twitter_id_profile_url | Unknown |  |
| external_contact_twitter_id_screen_name | Unknown |  |
| external_contact_twitter_id_verified | Unknown |  |
| external_contact_type | Unknown |  |
| external_contact_whatsapp_id_phone_number_accepts_sms | Unknown |  |
| external_contact_whatsapp_id_phone_number_country_code | Unknown |  |
| external_contact_whatsapp_id_phone_number_display | Unknown |  |
| external_contact_whatsapp_id_phone_number_e_164 | Unknown |  |
| external_contact_whatsapp_id_phone_number_extension | Unknown |  |
| external_contact_whatsapp_id_phone_number_user_input | Unknown |  |
| external_contact_whatsappid_displayname | Unknown |  |
| external_contact_work_email | Unknown |  |
| external_contact_workphone_accepts_sms | Unknown |  |
| external_contact_workphone_country_code | Unknown |  |
| external_contact_workphone_display | Unknown |  |
| external_contact_workphone_e_164 | Unknown |  |
| external_contact_workphone_extension | Unknown |  |
| external_contact_workphone_user_input | Unknown |  |
| external_organization_address_address_1 | Unknown |  |
| external_organization_address_address_2 | Unknown |  |
| external_organization_address_city | Unknown |  |
| external_organization_address_country_code | Unknown |  |
| external_organization_address_postal_code | Unknown |  |
| external_organization_address_state | Unknown |  |
| external_organization_company_type | Unknown |  |
| external_organization_create_date | Unknown |  |
| external_organization_custom_fields | Unknown |  |
| external_organization_did_interact | Unknown |  |
| external_organization_employee_count | Unknown |  |
| external_organization_external_data_source | Unknown |  |
| external_organization_external_system_url | Unknown |  |
| external_organization_fax_number_accepts_sms | Unknown |  |
| external_organization_fax_number_country_code | Unknown |  |
| external_organization_fax_number_display | Unknown |  |
| external_organization_fax_number_e_164 | Unknown |  |
| external_organization_fax_number_extension | Unknown |  |
| external_organization_fax_number_user_input | Unknown |  |
| external_organization_flagged_reason | Unknown |  |
| external_organization_id | Unknown |  |
| external_organization_industry | Unknown |  |
| external_organization_modify_date | Unknown |  |
| external_organization_name | Unknown |  |
| external_organization_outbound_campaign_id | Unknown |  |
| external_organization_phone_number_accepts_sms | Unknown |  |
| external_organization_phone_number_country_code | Unknown |  |
| external_organization_phone_number_display | Unknown |  |
| external_organization_phone_number_e_164 | Unknown |  |
| external_organization_phone_number_extension | Unknown |  |
| external_organization_phone_number_user_input | Unknown |  |
| external_organization_primary_contact_id | Unknown |  |
| external_organization_revenue | Unknown |  |
| external_organization_schema_additional_properties | Unknown |  |
| external_organization_schema_applies_to | Unknown |  |
| external_organization_schema_created_by_id | Unknown |  |
| external_organization_schema_date_created | Unknown |  |
| external_organization_schema_enabled | Unknown |  |
| external_organization_schema_id | Unknown |  |
| external_organization_schema_jsonschema_description | Unknown |  |
| external_organization_schema_jsonschema_id | Unknown |  |
| external_organization_schema_jsonschema_schema | Unknown |  |
| external_organization_schema_jsonschema_title | Unknown |  |
| external_organization_schema_jsonschema_type | Unknown |  |
| external_organization_schema_name | Unknown |  |
| external_organization_schema_properties | Unknown |  |
| external_organization_schema_required | Unknown |  |
| external_organization_schema_version | Unknown |  |
| external_organization_selfuri | Unknown |  |
| external_organization_sip_response_code | Unknown |  |
| external_organization_tag | Json |  |
| external_organization_tickers | Json |  |
| external_organization_trustor_authorization_permission | Unknown |  |
| external_organization_trustor_created_by_id | Unknown |  |
| external_organization_trustor_date_created | Unknown |  |
| external_organization_trustor_enabled | Unknown |  |
| external_organization_trustor_id | Unknown |  |
| external_organization_trustor_organization | Json |  |
| external_organization_trustor_selfuri | Unknown |  |
| external_organization_websites | Json |  |
| flagged_reason | Unknown |  |
| had_cobrowse | Unknown |  |
| had_screen_share | Unknown |  |
| missed_call | Unknown |  |
| name | Unknown |  |
| purpose | Unknown |  |
| self_uri | Unknown |  |
| start_time | Unknown |  |
| was_callback | Unknown |  |
| was_conference | Unknown |  |
| was_outbound_campaign | Unknown |  |
| went_to_voicemail | Unknown |  |

### conversation_call_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| direction | Unknown |  |
| had_cobrowse | Unknown |  |
| had_screen_share | Unknown |  |
| missed_call | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| start_time | Unknown |  |
| was_callback | Unknown |  |
| was_conference | Unknown |  |
| was_outbound_campaign | Unknown |  |
| went_to_voice_mail | Unknown |  |

### schedule_campaign_interval

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| schedule_campaign_id | Unknown | FK |
| ends | Unknown |  |
| start | Unknown |  |

### schedule_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| timezone | Unknown |  |
| version | Unknown |  |

### survey_form_published_version

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| survey_form_id | Unknown | PK, FK |
| context_id | Unknown |  |
| disabled | Unknown |  |
| id | Unknown |  |
| lang | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |
| question_groups | Json |  |
| self_uri | Unknown |  |
| weight_mode | Unknown |  |

### workforce_management_unit_agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| work_plan_management_unit_id | Unknown | FK |
| accept_direct_shift_trades | Unknown |  |
| languages | Json |  |
| queue | Json |  |
| schedulable | Unknown |  |
| self_uri | Unknown |  |
| skill | Json |  |
| work_plan_id | Unknown |  |
| work_plan_management_unit_self_uri | Unknown |  |
| work_plan_override | Json |  |
| work_plan_rotation_id | Unknown |  |
| work_plan_self_uri | Unknown |  |

### campaign_stats

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| adjusted_calls_per_agent | Unknown |  |
| contact_rate_attempts | Unknown |  |
| contact_rate_connect_ratio | Unknown |  |
| contact_rate_connects | Unknown |  |
| effective_idle_agents | Unknown |  |
| idle_agents | Unknown |  |
| outstanding_calls | Unknown |  |
| scheduled_calls | Unknown |  |
| time_zone_rescheduled_calls | Unknown |  |

### user_queue_routing_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| user_queue_id | Unknown | FK |
| operator | Unknown |  |
| threshold | Unknown |  |
| wait_seconds | Unknown |  |

### user_queue_conditional_group_routing_rule_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| index | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| user_queue_id | Unknown | PK, FK |

### user_queue_conditional_group_routing_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_queue_id | Unknown | PK, FK |
| condition_value | Unknown |  |
| metric | Unknown |  |
| operator | Unknown |  |
| wait_seconds | Unknown |  |

### user_queue_bulls_eye_ring_expansion_criteria

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| user_queue_id | Unknown | FK |
| threshold | Unknown |  |
| type | Unknown |  |

### user_queue_bulls_eye_ring_skill_to_remove

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_queue_id | Unknown | PK, FK |
| name | Unknown |  |
| self_uri | Unknown |  |

### user_queue_bulls_eye_ring_member_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_queue_id | Unknown | PK, FK |
| member_count | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| type | Unknown |  |

### user_queue_member_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_queue_id | Unknown | PK, FK |
| member_count | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| type | Unknown |  |

### user_queue_email_address_route_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_queue_id | Unknown | PK, FK |
| name | Unknown |  |
| self_uri | Unknown |  |

### user_queue_email_address_auto_bcc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| user_queue_id | Unknown | FK |
| email | Unknown |  |
| name | Unknown |  |

### user_queue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| division_id | Unknown | FK |
| acw_settings_timeout_ms | Unknown |  |
| acw_settings_wrapup_prompt | Unknown |  |
| agent_owned_routing_enable_agent_owned_call_back | Unknown |  |
| agent_owned_routing_max_owned_call_back_delay_hours | Unknown |  |
| agent_owned_routing_max_owned_call_back_hours | Unknown |  |
| auto_answer_only | Unknown |  |
| calling_party_name | Unknown |  |
| calling_party_number | Unknown |  |
| created_by | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| default_script | Json |  |
| description | Unknown |  |
| direct_routing_agent_wait_second | Unknown |  |
| direct_routing_backup_queue_id | Unknown |  |
| direct_routing_call_media_setting_enabled | Unknown |  |
| direct_routing_call_media_setting_inbound_flow_id | Unknown |  |
| direct_routing_call_media_setting_inbound_self_uri | Unknown |  |
| direct_routing_call_media_setting_voice_mail_flow | Unknown |  |
| direct_routing_email_media_setting_enabled | Unknown |  |
| direct_routing_email_media_setting_inbound_flow_id | Unknown |  |
| direct_routing_email_media_setting_inbound_self_uri | Unknown |  |
| direct_routing_enabled | Unknown |  |
| direct_routing_message_media_setting | Unknown |  |
| direct_routing_wait_for_agent | Unknown |  |
| email_in_queue_flow_id | Unknown |  |
| email_in_queue_flow_name | Unknown |  |
| email_in_queue_flow_self_uri | Unknown |  |
| enable_manual_assignment | Unknown |  |
| enable_transcription | Unknown |  |
| joined_member_count | Unknown |  |
| media_settings_call_alerting_timeout_seconds | Unknown |  |
| media_settings_call_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_call_enable_auto_answer | Unknown |  |
| media_settings_call_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_call_service_level | Unknown |  |
| media_settings_call_sub_type_setting | Json |  |
| media_settings_callback_alerting_timeout_seconds | Unknown |  |
| media_settings_callback_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_callback_enable_auto_answer | Unknown |  |
| media_settings_callback_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_callback_service_level | Unknown |  |
| media_settings_callback_sub_type_setting | Json |  |
| media_settings_chat_alerting_timeout_seconds | Unknown |  |
| media_settings_chat_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_chat_enable_auto_answer | Unknown |  |
| media_settings_chat_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_chat_service_level | Unknown |  |
| media_settings_chat_sub_type_setting | Json |  |
| media_settings_email_alerting_timeout_seconds | Unknown |  |
| media_settings_email_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_email_enable_auto_answer | Unknown |  |
| media_settings_email_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_email_service_level | Unknown |  |
| media_settings_email_sub_type_setting | Json |  |
| media_settings_message_alerting_timeout_seconds | Unknown |  |
| media_settings_message_auto_answer_alert_tone_seconds | Unknown |  |
| media_settings_message_enable_auto_answer | Unknown |  |
| media_settings_message_manual_answer_alert_tone_seconds | Unknown |  |
| media_settings_message_service_level | Unknown |  |
| media_settings_message_sub_type_setting | Json |  |
| member_count | Unknown |  |
| message_in_queue_flow_id | Unknown |  |
| message_in_queue_flow_name | Unknown |  |
| message_in_queue_flow_self_uri | Unknown |  |
| modified_by | Unknown |  |
| name | Unknown |  |
| on_hold_prompt_id | Unknown |  |
| on_hold_prompt_name | Unknown |  |
| on_hold_prompt_self_uri | Unknown |  |
| outbound_messaging_addresses_open_messaging_recipient_id | Unknown |  |
| outbound_messaging_addresses_open_messaging_recipient_name | Unknown |  |
| outbound_messaging_addresses_open_messaging_recipient_self_uri | Unknown |  |
| outbound_messaging_addresses_sms_address_name | Unknown |  |
| outbound_messaging_addresses_sms_address_self_uri | Unknown |  |
| outbound_messaging_addresses_sms_adress_id | Unknown |  |
| outbound_messaging_addresses_whats_app_recipient_id | Unknown |  |
| outbound_messaging_addresses_whats_app_recipient_name | Unknown |  |
| outbound_messaging_addresses_whats_app_recipient_self_uri | Unknown |  |
| peer_id | Unknown |  |
| queue_flow_id | Unknown |  |
| queue_flow_name | Unknown |  |
| queue_flow_self_uri | Unknown |  |
| reply_email_address_domain_id | Unknown |  |
| reply_email_address_domain_name | Unknown |  |
| reply_email_address_domain_self_uri | Unknown |  |
| reply_email_address_route_allow_multiple_actions | Unknown |  |
| reply_email_address_route_always_included | Unknown |  |
| reply_email_address_route_flow_id | Unknown |  |
| reply_email_address_route_flow_name | Unknown |  |
| reply_email_address_route_flow_self_uri | Unknown |  |
| reply_email_address_route_from_email | Unknown |  |
| reply_email_address_route_from_name | Unknown |  |
| reply_email_address_route_history_inclusion | Unknown |  |
| reply_email_address_route_id | Unknown |  |
| reply_email_address_route_inclusion_type | Unknown |  |
| reply_email_address_route_language_id | Unknown |  |
| reply_email_address_route_language_name | Unknown |  |
| reply_email_address_route_language_self_url | Unknown |  |
| reply_email_address_route_name | Unknown |  |
| reply_email_address_route_pattern | Unknown |  |
| reply_email_address_route_priority | Unknown |  |
| reply_email_address_route_queue_id | Unknown |  |
| reply_email_address_route_reply_email_address | Json |  |
| reply_email_address_route_self_uri | Unknown |  |
| reply_email_address_route_signature_canned_response_id | Unknown |  |
| reply_email_address_route_signature_enabled | Unknown |  |
| reply_email_address_route_spam_flow_id | Unknown |  |
| reply_email_address_route_spam_flow_name | Unknown |  |
| reply_email_address_route_spam_flow_self_uri | Unknown |  |
| scoring_method | Unknown |  |
| self_uri | Unknown |  |
| skill_evaluation_method | Unknown |  |
| suppress_in_queue_call_recording | Unknown |  |
| user_member_count | Unknown |  |
| whisper_prompt_id | Unknown |  |
| whisper_prompt_name | Unknown |  |
| whisper_prompt_self_uri | Unknown |  |

### users_primary_contact_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| address | Unknown |  |
| country_code | Unknown |  |
| display | Unknown |  |
| extension | Unknown |  |
| integration | Unknown |  |
| media_type | Unknown |  |
| type | Unknown |  |

### users_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| address | Unknown |  |
| country_code | Unknown |  |
| display | Unknown |  |
| extension | Unknown |  |
| integration | Unknown |  |
| media_type | Unknown |  |
| type | Unknown |  |

### users_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| image_uri | Unknown |  |
| resolution | Unknown |  |

### users_certification

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| certifications | Unknown |  |

### users_biography_interest

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| interests | Unknown |  |

### users_biography_hobby

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| hobbies | Unknown |  |

### users_biography_education

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| date_end | Unknown |  |
| date_start | Unknown |  |
| field_of_study | Unknown |  |
| notes | Unknown |  |
| school | Unknown |  |

### users_geo_location_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| users_geo_location_id | Unknown | PK, FK |

### users_geo_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### users_profile_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| profile_skill | Unknown |  |

### users_location

| Column | Type | Keys |
| --- | --- | --- |
| location_definition_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| coordinates | Json |  |
| floorplan_id | Unknown |  |
| id | Unknown |  |
| notes | Unknown |  |

### users_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| name | Unknown |  |
| proficiency | Unknown |  |
| self_uri | Unknown |  |
| skill_uri | Unknown |  |
| state | Unknown |  |

### users_language

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| language_uri | Unknown |  |
| name | Unknown |  |
| proficiency | Unknown |  |
| self_uri | Unknown |  |
| state | Unknown |  |

### users_authorization_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| name | Unknown |  |

### users_authorization_unused_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| name | Unknown |  |

### users_authorization_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| permission | Unknown |  |

### users_authorization_permission_policy

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | PK, FK |
| action_set | Json |  |
| action_set_key | Unknown |  |
| allow_conditions | Unknown |  |
| domain | Unknown |  |
| entity_name | Unknown |  |
| id | Unknown |  |
| named_resources | Json |  |
| policy_description | Unknown |  |
| policy_name | Unknown |  |
| resource_condition | Unknown |  |
| resource_condition_node_conjunction | Unknown |  |
| resource_condition_node_variable_name | Unknown |  |
| resourceconditionnode_operator | Unknown |  |
| terms | Json |  |
| custom_operands_** |  |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| associated_station_default_user | Unknown | FK |
| associated_station_location_id | Unknown | FK |
| associated_station_user_id | Unknown | FK |
| conversation_summary_user_id | Unknown | FK |
| default_station_default_user | Unknown | FK |
| default_station_location_id | Unknown | FK |
| default_station_user_id | Unknown | FK |
| division_id | Unknown | FK |
| effective_station_default_user | Unknown | FK |
| effective_station_location_id | Unknown | FK |
| effective_station_user_id | Unknown | FK |
| last_associated_station_default_user | Unknown | FK |
| last_associated_station_location_id | Unknown | FK |
| last_associated_station_user_id | Unknown | FK |
| manager_id | Unknown | FK |
| out_of_office_user_id | Unknown | FK |
| routing_status_user_id | Unknown | FK |
| team_division_id | Unknown | FK |
| acd_auto_answer | Unknown |  |
| associated_station_date | Unknown |  |
| associated_station_default_user_id | Unknown |  |
| associated_station_edge_group_id | Unknown |  |
| associated_station_id | Unknown |  |
| associated_station_name | Unknown |  |
| associated_station_web_rtc_call_appearances | Unknown |  |
| biography | Unknown |  |
| biography_spouse | Unknown |  |
| chat_jabber_id | Unknown |  |
| conversation_call_contact_center_active | Unknown |  |
| conversation_call_contact_center_acw | Unknown |  |
| conversation_call_enterprise_active | Unknown |  |
| conversation_call_enterprise_acw | Unknown |  |
| conversation_callback_contact_center_active | Unknown |  |
| conversation_callback_contact_center_acw | Unknown |  |
| conversation_callback_enterprise_active | Unknown |  |
| conversation_callback_enterprise_acw | Unknown |  |
| conversation_chat_contact_center_active | Unknown |  |
| conversation_chat_contact_center_acw | Unknown |  |
| conversation_chat_enterprise_active | Unknown |  |
| conversation_chat_enterprise_acw | Unknown |  |
| conversation_email_contact_center_active | Unknown |  |
| conversation_email_contact_center_acw | Unknown |  |
| conversation_email_enterprise_active | Unknown |  |
| conversation_email_enterprise_acw | Unknown |  |
| conversation_message_contact_center_active | Unknown |  |
| conversation_message_contact_center_acw | Unknown |  |
| conversation_message_enterprise_active | Unknown |  |
| conversation_message_enterprise_acw | Unknown |  |
| conversation_social_expression_contact_center_active | Unknown |  |
| conversation_social_expression_contact_center_acw | Unknown |  |
| conversation_social_expression_enterprise_active | Unknown |  |
| conversation_social_expression_enterprise_acw | Unknown |  |
| conversation_video_contact_center_active | Unknown |  |
| conversation_video_contact_center_acw | Unknown |  |
| conversation_video_enterprise_active | Unknown |  |
| conversation_video_enterprise_acw | Unknown |  |
| date_last_login | Unknown |  |
| default_station_date | Unknown |  |
| default_station_default_user_id | Unknown |  |
| default_station_edge_group_id | Unknown |  |
| default_station_id | Unknown |  |
| default_station_name | Unknown |  |
| default_station_web_rtc_call_appearances | Unknown |  |
| department | Unknown |  |
| effective_station_date | Unknown |  |
| effective_station_default_user_id | Unknown |  |
| effective_station_edge_group_id | Unknown |  |
| effective_station_id | Unknown |  |
| effective_station_name | Unknown |  |
| effective_station_web_rtc_call_appearances | Unknown |  |
| email | Unknown |  |
| employee_date_hire | Unknown |  |
| employee_id | Unknown |  |
| employee_official_name | Unknown |  |
| employee_type | Unknown |  |
| geolocation_city | Unknown |  |
| geolocation_country | Unknown |  |
| geolocation_id | Unknown |  |
| geolocation_latitude | Unknown |  |
| geolocation_longitude | Unknown |  |
| geolocation_name | Unknown |  |
| geolocation_primary | Unknown |  |
| geolocation_region | Unknown |  |
| geolocation_self_uri | Unknown |  |
| geolocation_type | Unknown |  |
| integration_presence_definition_id | Unknown |  |
| integration_presence_definition_self_uri | Unknown |  |
| integration_presence_definition_system_presence | Unknown |  |
| integration_presence_id | Unknown |  |
| integration_presence_message | Unknown |  |
| integration_presence_modified_date | Unknown |  |
| integration_presence_name | Unknown |  |
| integration_presence_primary | Unknown |  |
| integration_presence_self_uri | Unknown |  |
| integration_presence_source | Unknown |  |
| language_preference | Unknown |  |
| last_associated_station_associated_date | Unknown |  |
| last_associated_station_default_user_id | Unknown |  |
| last_associated_station_edge_group_id | Unknown |  |
| last_associated_station_id | Unknown |  |
| last_associated_station_name | Unknown |  |
| last_associated_station_web_rtc_call_appearances | Unknown |  |
| last_token_issueddate | Unknown |  |
| name | Unknown |  |
| out_of_office_active | Unknown |  |
| out_of_office_end_date | Unknown |  |
| out_of_office_id | Unknown |  |
| out_of_office_indefinite | Unknown |  |
| out_of_office_name | Unknown |  |
| out_of_office_self_uri | Unknown |  |
| out_of_office_start_date | Unknown |  |
| presence_definition_id | Unknown |  |
| presence_definition_self_uri | Unknown |  |
| presence_definition_system_presence | Unknown |  |
| presence_id | Unknown |  |
| presence_message | Unknown |  |
| presence_modified_date | Unknown |  |
| presence_name | Unknown |  |
| presence_primary | Unknown |  |
| presence_self_uri | Unknown |  |
| presence_source | Unknown |  |
| routing_status | Unknown |  |
| routing_status_start_time | Unknown |  |
| self_uri | Unknown |  |
| state | Unknown |  |
| team_date_created | Unknown |  |
| team_date_modified | Unknown |  |
| team_description | Unknown |  |
| team_id | Unknown |  |
| team_member_count | Unknown |  |
| team_name | Unknown |  |
| team_self_uri | Unknown |  |
| title | Unknown |  |
| username | Unknown |  |
| version | Unknown |  |

### campaign_phone_column

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| column_name | Unknown |  |
| type | Unknown |  |

### campaign_dnc

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| dnc_id | Unknown | PK, FK |

### campaign_errors

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| details | Unknown |  |
| error | Unknown |  |

### campaign_rule_set

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| rule_set_id | Unknown | PK, FK |

### campaign_contact_sort

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| direction | Unknown |  |
| field_name | Unknown |  |
| numeric | Unknown |  |

### campaign_contact_list_filter

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| contact_list_filter_id | Unknown | PK, FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| callable_time_set_id | Unknown | FK |
| contact_list_id | Unknown | FK |
| division_id | Unknown | FK |
| queue_id | Unknown | FK |
| script_id | Unknown | FK |
| abandon_rate | Unknown |  |
| always_running | Unknown |  |
| call_analysis_language | Unknown |  |
| call_analysis_response_set_id | Unknown |  |
| call_analysis_response_set_name | Unknown |  |
| call_analysis_response_set_self_uri | Unknown |  |
| caller_address | Unknown |  |
| caller_name | Unknown |  |
| campaign_status | Unknown |  |
| contact_sort_direction | Unknown |  |
| contact_sort_field_name | Unknown |  |
| contact_sort_numeric | Unknown |  |
| date_created | Unknown |  |
| date_modified | Instant |  |
| dialing_mode | Unknown |  |
| dynamic_contact_queueing_settings_sort | Unknown |  |
| edge_group_id | Unknown |  |
| edge_group_name | Unknown |  |
| edge_group_self_uri | Unknown |  |
| name | Unknown |  |
| no_answer_timeout | Unknown |  |
| outbound_line_count | Unknown |  |
| preview_time_out_second | Unknown |  |
| priority | Unknown |  |
| self_uri | Unknown |  |
| single_number_preview | Unknown |  |
| site_id | Unknown |  |
| site_name | Unknown |  |
| site_self_uri | Unknown |  |
| skip_preview_disabled | Unknown |  |
| version | Unknown |  |

### flow_outcome_error_detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flow_outcome_id | Unknown | FK |
| entity_id | Unknown |  |
| entity_name | Unknown |  |
| error_code | Unknown |  |
| field_name | Unknown |  |

### flow_outcome

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| current_operation_user_id | Unknown | FK |
| division_id | Unknown | FK |
| current_operation_action_name | Unknown |  |
| current_operation_action_status | Unknown |  |
| current_operation_client_id | Unknown |  |
| current_operation_client_name | Unknown |  |
| current_operation_client_self_uri | Unknown |  |
| current_operation_complete | Unknown |  |
| current_operation_error_code | Unknown |  |
| current_operation_error_message | Unknown |  |
| current_operation_error_message_params | Json |  |
| current_operation_id | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |

### user_routing_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| name | Unknown |  |
| proficiency | Unknown |  |
| self_uri | Unknown |  |
| skill_uri | Unknown |  |
| state | Unknown |  |

### conversation_callback_participants_wrapup_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_callback_id | Unknown | PK, FK |
| conversation_callback_participants_id | Unknown | PK, FK |
| tag_name | Unknown |  |

### conversation_callback_participants_callback_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_callback_id | Unknown | PK, FK |
| conversation_callback_participants_id | Unknown | PK, FK |
| callback_number | Unknown |  |

### conversation_callback_participants_media_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_callback_id | Unknown | PK, FK |
| conversation_callback_participants_id | Unknown | PK, FK |
| media_role | Unknown |  |

### conversation_callback_participants

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_callback_id | Unknown | PK, FK |
| queue_id | Unknown | FK |
| user_id | Unknown | FK |
| alerting_timeout_ms | Unknown |  |
| attributes | Json |  |
| connected_time | Unknown |  |
| direction | Unknown |  |
| disconnect_type | Unknown |  |
| end_time | Unknown |  |
| error_info_code | Unknown |  |
| error_info_message | Unknown |  |
| external_contact_id | Unknown |  |
| external_contact_name | Unknown |  |
| external_contact_self_url | Unknown |  |
| external_organization_id | Unknown |  |
| external_organization_name | Unknown |  |
| external_organization_self_url | Unknown |  |
| flagged_reason | Unknown |  |
| held | Unknown |  |
| media_roles | Json |  |
| name | Unknown |  |
| peer | Unknown |  |
| provider | Unknown |  |
| purpose | Unknown |  |
| script_id | Unknown |  |
| start_hold_time | Unknown |  |
| start_time | Unknown |  |
| state | Unknown |  |
| team_id | Unknown |  |
| team_name | Unknown |  |
| team_self_url | Unknown |  |
| wrapup_code | Unknown |  |
| wrapup_duration_seconds | Unknown |  |
| wrapup_end_time | Unknown |  |
| wrapup_name | Unknown |  |
| wrapup_notes | Unknown |  |
| wrapup_prompt | Unknown |  |
| wrapup_provisional | Unknown |  |
| wrapup_required | Unknown |  |
| wrapup_skipped | Unknown |  |
| wrapup_tag | Json |  |
| wrapup_timeout_ms | Unknown |  |

### conversation_callback_other_media_uris

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_callback_id | Unknown | FK |
| other_media_uri | Unknown |  |

### conversation_callback_participants_recent_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_callback_id | Unknown | PK, FK |
| destination_user_id | Unknown | FK |
| initiator_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| date_issued | Unknown |  |
| destination_address | Unknown |  |
| state | Unknown |  |

### conversation_callback

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### schedule_message_severity_count

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schedule_business_unit_id | Unknown | PK, FK |
| schedule_id | Unknown | PK, FK |
| schedule_week_date | Unknown | PK, FK |
| count | Unknown |  |
| severity | Unknown |  |

### schedule_management_unit_agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| schedule_business_unit_id | Unknown | PK, FK |
| schedule_id | Unknown | PK, FK |
| schedule_management_unit_index | Unknown | PK, FK |
| schedule_week_date | Unknown | PK, FK |
| self_uri | Unknown |  |

### schedule_management_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schedule_business_unit_id | Unknown | PK, FK |
| schedule_id | Unknown | PK, FK |
| schedule_week_date | Unknown | PK, FK |
| management_unit_id | Unknown | FK |
| agent_count | Unknown |  |
| end_date | Unknown |  |
| management_unit_self_uri | Unknown |  |
| start_date | Unknown |  |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| business_unit_id | Unknown | PK |
| id | Unknown | PK |
| week_date | Unknown | PK |
| created_by_id | Unknown | FK |
| description | Unknown |  |
| generation_results_failed | Unknown |  |
| generation_results_message_count | Unknown |  |
| generation_results_run_id | Unknown |  |
| metadata_date_created | Unknown |  |
| metadata_date_modified | Unknown |  |
| metadata_version | Unknown |  |
| modified_by_id | Unknown |  |
| modified_by_self_uri | Unknown |  |
| published | Unknown |  |
| self_uri | Unknown |  |
| short_term_forecast_description | Unknown |  |
| short_term_forecast_id | Unknown |  |
| short_term_forecast_self_uri | Unknown |  |
| short_term_forecast_week_date | Unknown |  |
| week_count | Unknown |  |

### conversation_survey_answer_question_group_question_score

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| conversation_survey_answer_question_group_score_index | Unknown | PK, FK |
| conversation_survey_id | Unknown | PK, FK |
| answer_id | Unknown |  |
| assisted_answer_id | Unknown |  |
| free_text_answer | Unknown |  |
| marked_na | Unknown |  |
| nps_score | Unknown |  |
| nps_text_answer | Unknown |  |
| question_id | Unknown |  |
| score | Unknown |  |
| system_marked_na | Unknown |  |

### conversation_survey_answer_question_group_score

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| conversation_survey_id | Unknown | PK, FK |
| marked_na | Unknown |  |
| max_total_score | Unknown |  |
| question_group_id | Unknown |  |
| system_marked_na | Unknown |  |
| total_score | Unknown |  |

### conversation_survey

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| queue_id | Unknown | FK |
| survey_form_id | Unknown | FK |
| agent_team_date_created | Unknown |  |
| agent_team_date_modified | Unknown |  |
| agent_team_description | Unknown |  |
| agent_team_division_id | Unknown |  |
| agent_team_division_name | Unknown |  |
| agent_team_id | Unknown |  |
| agent_team_member_count | Unknown |  |
| agent_team_name | Unknown |  |
| agent_team_self_uri | Unknown |  |
| answer_nps_score | Unknown |  |
| answer_total_score | Unknown |  |
| completed_date | Unknown |  |
| flow_id | Unknown |  |
| missing_required_answer | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| status | Unknown |  |
| survey_error_flow_diagnostic_last_action_id | Unknown |  |
| survey_error_survey_error_reason | Unknown |  |
| survey_type | Unknown |  |

### location_path

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| path | Unknown |  |

### location_profile_image

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| location_id | Unknown | FK |
| image_uri | Unknown |  |
| resolution | Unknown |  |

### location_floor_plan_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| floor_plan_image | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_user_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_country_name | Unknown |  |
| address_state | Unknown |  |
| address_stored | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_verified | Unknown |  |
| address_verify_date_finished | Unknown |  |
| address_verify_date_started | Unknown |  |
| address_verify_service | Unknown |  |
| address_verify_status | Unknown |  |
| address_zipcode | Unknown |  |
| emergency_e_164 | Unknown |  |
| emergency_number | Unknown |  |
| emergency_type | Unknown |  |
| images | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| self_uri | Unknown |  |
| state | Unknown |  |
| version | Unknown |  |

### presence_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deactivated | Unknown |  |
| division_id | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| system_presence | Unknown |  |
| type | Unknown |  |
| language_labels_** |  |  |

### division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| home_division | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| count_** |  |  |

### dnc_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dnc_id | Unknown | PK, FK |
| dnc_code | Unknown |  |

### dnc

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| division_id | Unknown | FK |
| contact_method | Unknown |  |
| custom_exclusion_column | Unknown |  |
| date_created | Unknown |  |
| date_modified | Instant |  |
| dnc_source_type | Unknown |  |
| import_status_completed_records | Unknown |  |
| import_status_failure_reason | Unknown |  |
| import_status_percent_complete | Unknown |  |
| import_status_state | Unknown |  |
| import_status_total_record | Unknown |  |
| license_id | Unknown |  |
| login_id | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| size | Unknown |  |
| version | Unknown |  |

### activity_code_secondary_presence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_code_id | Unknown | PK, FK |
| self_uri | Unknown |  |

### activity_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| modified_by_id | Unknown | FK |
| active | Unknown |  |
| category | Unknown |  |
| counts_as_paid_time | Unknown |  |
| counts_as_work_time | Unknown |  |
| counts_toward_shrinkage | Unknown |  |
| date_modified | Unknown |  |
| default_code | Unknown |  |
| interruptible | Unknown |  |
| length_in_minute | Unknown |  |
| name | Unknown |  |
| planned_shrinkage | Unknown |  |
| self_uri | Unknown |  |
| version | Unknown |  |

### user_routing_language

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| language_uri | Unknown |  |
| name | Unknown |  |
| proficiency | Unknown |  |
| self_uri | Unknown |  |
| state | Unknown |  |

### business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| authorized | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |

### script_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| script_id | Unknown | PK, FK |
| created_date | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| properties | Json |  |
| root_container | Json |  |
| self_uri | Unknown |  |
| version_id | Unknown |  |

### script

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| created_date | Unknown |  |
| custom_actions | Json |  |
| features | Json |  |
| modified_date | Instant |  |
| name | Unknown |  |
| published_date | Unknown |  |
| self_uri | Unknown |  |
| start_page_id | Unknown |  |
| start_page_name | Unknown |  |
| variables | Json |  |
| version_date | Unknown |  |
| version_id | Unknown |  |

### attempt_limit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created | Unknown |  |
| date_modified | Instant |  |
| max_attempts_per_contact | Unknown |  |
| max_attempts_per_number | Unknown |  |
| name | Unknown |  |
| recall_entries | Json |  |
| reset_period | Unknown |  |
| self_uri | Unknown |  |
| time_zone_id | Unknown |  |
| version | Unknown |  |

### evaluation_form_question_group_question_answer_option_assistance_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evaluation_form_id | Unknown | PK, FK |
| evaluation_form_question_group_index | Unknown | PK, FK |
| evaluation_form_question_group_question_answer_option_index | Unknown | PK, FK |
| evaluation_form_question_group_question_index | Unknown | PK, FK |
| operator | Unknown |  |
| topic_ids | Json |  |

### evaluation_form_question_group_question_answer_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evaluation_form_id | Unknown | PK, FK |
| evaluation_form_question_group_index | Unknown | PK, FK |
| evaluation_form_question_group_question_index | Unknown | PK, FK |
| id | Unknown |  |
| text | Unknown |  |
| value | Unknown |  |

### evaluation_form_question_group_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evaluation_form_id | Unknown | PK, FK |
| evaluation_form_question_group_index | Unknown | PK, FK |
| comments_required | Unknown |  |
| help_text | Unknown |  |
| id | Unknown |  |
| is_critical | Unknown |  |
| is_kill | Unknown |  |
| na_enabled | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |
| visibility_condition_combining_operation | Unknown |  |
| visibility_condition_predicates | Json |  |

### evaluation_form_question_group

| Column | Type | Keys |
| --- | --- | --- |
| evaluation_form_id | Unknown | PK |
| index | Unknown | PK |
| default_answers_to_highest | Unknown |  |
| default_answers_to_na | Unknown |  |
| id | Unknown |  |
| manual_weight | Unknown |  |
| na_enabled | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| visibility_condition | Unknown |  |
| weight | Unknown |  |

### campaign_rule_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| campaign_rule_id | Unknown | PK, FK |

### campaign_rule_entity_sequence

| Column | Type | Keys |
| --- | --- | --- |
| campaign_rule_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### campaign_rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_rule_id | Unknown | PK, FK |
| condition_type | Unknown |  |
| parameters_dialing_mode | Unknown |  |
| parameters_operator | Unknown |  |
| parameters_priority | Unknown |  |
| parameters_value | Unknown |  |

### campaign_rule_action_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| campaign_rule_action_id | Unknown | PK, FK |
| campaign_rule_id | Unknown | PK, FK |

### campaign_rule_action_sequence

| Column | Type | Keys |
| --- | --- | --- |
| campaign_rule_action_id | Unknown | PK, FK |
| campaign_rule_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### campaign_rule_action

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_rule_id | Unknown | PK, FK |
| action_type | Unknown |  |
| parameters_dialing_mode | Unknown |  |
| parameters_operator | Unknown |  |
| parameters_priority | Unknown |  |
| parameters_value | Unknown |  |
| use_triggering_entity | Unknown |  |

### campaign_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created | Unknown |  |
| date_modified | Instant |  |
| enabled | Unknown |  |
| match_any_conditions | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| version | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| correlation_id | Unknown |  |
| error_entity_id | Unknown |  |
| error_entity_name | Unknown |  |
| error_entity_self_uri | Unknown |  |
| level | Unknown |  |
| name | Unknown |  |
| related_entity_id | Unknown |  |
| related_entity_name | Unknown |  |
| related_entity_self_uri | Unknown |  |
| resource_uris_code | Unknown |  |
| resource_uris_documentation_uri | Unknown |  |
| resource_uris_message | Unknown |  |
| resource_uris_message_params | Json |  |
| resource_uris_message_with_params | Unknown |  |
| resource_uris_resource_uris | Json |  |
| self_uri | Unknown |  |
| time_stamp | Unknown |  |

### external_contact_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| external_contact_id | Unknown | PK, FK |
| date_created | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### external_contact_line_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| external_contact_id | Unknown | PK, FK |
| user_id | Unknown | FK |

### external_contact_facebook_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| external_contact_id | Unknown | PK, FK |
| scoped_id | Unknown |  |

### external_contact_external_data_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| external_contact_id | Unknown | PK, FK |
| platform | Unknown |  |
| url | Unknown |  |

### external_contact_external_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| external_contact_id | Unknown | PK, FK |
| external_source_active | Unknown |  |
| external_source_id | Unknown |  |
| external_source_link_configuration_uri_template | Unknown |  |
| external_source_name | Unknown |  |
| value | Unknown |  |

### external_contact_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | Unknown | PK |
| external_contact_id | Unknown | PK, FK |
| attribute_value | Unknown |  |

### external_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| canonical_contact_id | Unknown | FK |
| organization_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| create_date | Unknown |  |
| external_system_url | Unknown |  |
| facebook_display_name | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| line_display_name | Unknown |  |
| merge_operation_resulting_contact | Unknown |  |
| merge_operation_source_contact | Unknown |  |
| merge_operation_target_contact | Unknown |  |
| merge_set | Json |  |
| middle_name | Unknown |  |
| modify_date | Unknown |  |
| other_email | Unknown |  |
| personal_email | Unknown |  |
| salutation | Unknown |  |
| schema | Unknown |  |
| self_uri | Unknown |  |
| survey_opt_out | Unknown |  |
| title | Unknown |  |
| twitter_id | Unknown |  |
| twitter_name | Unknown |  |
| twitter_profile_url | Unknown |  |
| twitter_screen_name | Unknown |  |
| twitter_verified | Unknown |  |
| type | Unknown |  |
| whats_app_display_name | Unknown |  |
| whats_app_phone_number | Unknown |  |
| work_email | Unknown |  |
| work_phone_accepts_sms | Unknown |  |
| work_phone_country_code | Unknown |  |
| work_phone_display | Unknown |  |
| work_phone_e_164 | Unknown |  |
| work_phone_extension | Unknown |  |
| work_phone_normalization_country_code | Unknown |  |
| work_phone_user_input | Unknown |  |

### calibration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| calibrator_id | Unknown | FK |
| evaluation_form_id | Unknown | FK |
| evaluation_id | Unknown | FK |
| evaluator_id | Unknown | FK |
| expert_evaluator_id | Unknown | FK |
| manager_id | Unknown | FK |
| scoring_index_id | Unknown | FK |
| agent | Unknown |  |
| average_score | Unknown |  |
| context_id | Unknown |  |
| conversation_id | Unknown |  |
| created_date | Unknown |  |
| high_score | Unknown |  |
| low_score | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |

### analytics_conversation_aggregate_query_details_division

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK, FK |
| division_id | Unknown | PK, FK |

### analytics_conversation_aggregate_query_details_knowledge_base_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| knowledge_base_id | Unknown |  |

### analytics_conversation_aggregate_query_details_evaluation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| assignee_id | Unknown | FK |
| conversation_id | Unknown | FK |
| division_id | Unknown | FK |
| evaluator_id | Unknown | FK |
| user_id | Unknown | FK |
| assignee_applicable | Unknown |  |
| calibration_id | Unknown |  |
| context_id | Unknown |  |
| deleted | Unknown |  |
| evaluation_id | Unknown |  |
| evaluation_status | Unknown |  |
| event_time | Unknown |  |
| form_id | Unknown |  |
| form_name | Unknown |  |
| queue_id | Unknown |  |
| released | Unknown |  |
| rescored | Unknown |  |
| total_critical_score | Unknown |  |
| total_score | Unknown |  |

### analytics_conversation_aggregate_query_details_survey

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| queue_id | Unknown | FK |
| user_id | Unknown | FK |
| event_time | Unknown |  |
| o_survey_total_score | Unknown |  |
| survey_completed_date | Unknown |  |
| survey_form_context_id | Unknown |  |
| survey_form_id | Unknown |  |
| survey_form_name | Unknown |  |
| survey_id | Unknown |  |
| survey_partial_response | Unknown |  |
| survey_promoter_score | Unknown |  |
| survey_status | Unknown |  |
| survey_type | Unknown |  |

### analytics_conversation_aggregate_query_details_resolution

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| queue_id | Unknown | FK |
| user_id | Unknown | FK |
| event_time | Unknown |  |
| n_next_contact_avoided | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_callback_number

| Column | Type | Keys |
| --- | --- | --- |
| callback_number | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |

### analytics_conversation_aggregate_query_details_participant_session_bcc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| bcc | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_cc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| cc | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_destination_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| destination_addresses | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_eligible_agent_count

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| eligible_agent_count | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_requested_routing

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| requested_routing | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_waiting_interaction_counts

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| waiting_interaction_count | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_proposed_agent

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| agent_rank | Unknown |  |
| proposed_agent_id | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_agent_group

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| agent_group_id | Unknown |  |
| agent_group_type | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_media_endpoint_stats

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| codecs | Json |  |
| discarded_packets | Unknown |  |
| duplicate_packets | Unknown |  |
| event_time | Unknown |  |
| invalid_packets | Unknown |  |
| max_latency_ms | Unknown |  |
| min_mos | Unknown |  |
| min_r_factor | Unknown |  |
| overrun_packets | Unknown |  |
| received_packets | Unknown |  |
| underrun_packets | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_flow_outcome

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| flow_outcome | Unknown |  |
| flow_outcome_end_timestamp | Unknown |  |
| flow_outcome_id | Unknown |  |
| flow_outcome_start_timestamp | Unknown |  |
| flow_outcome_value | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_metric

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| emit_date | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_segment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| audio_muted | Unknown |  |
| conference | Unknown |  |
| destination_conversation_id | Unknown |  |
| destination_session_id | Unknown |  |
| disconnect_type | Unknown |  |
| error_code | Unknown |  |
| group_id | Unknown |  |
| properties | Json |  |
| q_850_response_code | Json |  |
| queue_id | Unknown |  |
| requested_language_id | Unknown |  |
| requested_routing_skill_ids | Json |  |
| requested_routing_user_ids | Json |  |
| scored_agents | Json |  |
| segment_end | Unknown |  |
| segment_start | Unknown |  |
| segment_type | Unknown |  |
| sip_response_codes | Json |  |
| source_conversation_id | Unknown |  |
| source_session_id | Unknown |  |
| subject | Unknown |  |
| video_muted | Unknown |  |
| wrap_up_code | Unknown |  |
| wrap_up_note | Unknown |  |
| wrap_up_tags | Json |  |

### analytics_conversation_aggregate_query_details_participant_session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| assigner_id | Unknown | FK |
| campaign_id | Unknown | FK |
| contact_list_id | Unknown | FK |
| script_id | Unknown | FK |
| acw_skipped | Unknown |  |
| address_from | Unknown |  |
| address_other | Unknown |  |
| address_self | Unknown |  |
| address_to | Unknown |  |
| agent_assistant_id | Unknown |  |
| agent_bullseye_ring | Unknown |  |
| agent_owned | Unknown |  |
| ani | Unknown |  |
| authenticated | Unknown |  |
| barged_participant_id | Unknown |  |
| callback_scheduled_time | Unknown |  |
| callback_user_name | Unknown |  |
| cleared | Unknown |  |
| coached_participant_id | Unknown |  |
| cobrowse_role | Unknown |  |
| cobrowse_room_id | Unknown |  |
| contact_id | Unknown |  |
| delivery_status | Unknown |  |
| delivery_status_change_date | Unknown |  |
| detected_speech_end | Unknown |  |
| detected_speech_start | Unknown |  |
| direction | Unknown |  |
| disposition_analyzer | Unknown |  |
| disposition_name | Unknown |  |
| dnis | Unknown |  |
| edge_id | Unknown |  |
| extended_delivery_status | Unknown |  |
| flow_ending_language | Unknown |  |
| flow_entry_reason | Unknown |  |
| flow_entry_type | Unknown |  |
| flow_ersion | Unknown |  |
| flow_exit_reason | Unknown |  |
| flow_id | Unknown |  |
| flow_in_type | Unknown |  |
| flow_issued_callback | Unknown |  |
| flow_name | Unknown |  |
| flow_out_type | Unknown |  |
| flow_recognition_failure_reason | Unknown |  |
| flow_starting_language | Unknown |  |
| flow_transfer_target_address | Unknown |  |
| flow_transfer_target_name | Unknown |  |
| flow_transfer_type | Unknown |  |
| flow_type | Unknown |  |
| journey_action_id | Unknown |  |
| journey_action_map_id | Unknown |  |
| journey_action_map_version | Unknown |  |
| journey_customer_id | Unknown |  |
| journey_customer_id_type | Unknown |  |
| journey_customer_session_id | Unknown |  |
| journey_customer_session_id_type | Unknown |  |
| media_bridge_id | Unknown |  |
| media_count | Unknown |  |
| media_type | Unknown |  |
| message_type | Unknown |  |
| monitored_participant_id | Unknown |  |
| peer_id | Unknown |  |
| protocol_call_id | Unknown |  |
| provider | Unknown |  |
| recording | Unknown |  |
| remote | Unknown |  |
| remote_name_displayable | Unknown |  |
| room_id | Unknown |  |
| routing_ring | Unknown |  |
| routing_rule | Unknown |  |
| routing_rule_type | Unknown |  |
| screen_share_address_self | Unknown |  |
| screen_share_room_id | Unknown |  |
| selected_agent_id | Unknown |  |
| selected_agent_rank | Unknown |  |
| session_dnis | Unknown |  |
| sharing_screen | Unknown |  |
| skip_enabled | Unknown |  |
| timeout_seconds | Unknown |  |
| used_routing | Unknown |  |
| video_address_self | Unknown |  |
| video_room_id | Unknown |  |

### analytics_conversation_aggregate_query_details_participant

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| external_contact_id | Unknown |  |
| external_organization_id | Unknown |  |
| flagged_reason | Unknown |  |
| participant_name | Unknown |  |
| purpose | Unknown |  |
| screen_recording | Unknown |  |
| team_id | Unknown |  |

### analytics_conversation_aggregate_query_details

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK |
| conference_start | Unknown |  |
| conversation_end | Unknown |  |
| conversation_initiator | Unknown |  |
| conversation_start | Unknown |  |
| customer_participation | Unknown |  |
| external_tag | Unknown |  |
| media_stats_min_conversation_mos | Unknown |  |
| media_stats_min_conversation_r_factor | Unknown |  |
| originating_direction | Unknown |  |
| self_served | Unknown |  |

### analytics_conversation_aggregate_query_details_participant_session_skill_id

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| object_type | Unknown |  |

### messaging_campaign_progress

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| messaging_campaign_id | Unknown | PK, FK |
| campaign_id | Unknown | FK |
| contact_list_id | Unknown | FK |
| number_of_contacts_called | Unknown |  |
| number_of_contacts_messaged | Unknown |  |
| number_of_contacts_skipped | Json |  |
| percentage | Unknown |  |
| total_number_of_contact | Unknown |  |

### organization_ticker

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| exchange | Unknown |  |
| symbol | Unknown |  |

### organization_external_data_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| platform | Unknown |  |
| url | Unknown |  |

### organization_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | Unknown | PK |
| organization_id | Unknown | PK, FK |
| attribute_value | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| trustor_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| company_type | Unknown |  |
| create_date | Unknown |  |
| employee_count | Unknown |  |
| external_system_url | Unknown |  |
| fax_number | Unknown |  |
| industry | Unknown |  |
| modify_date | Unknown |  |
| name | Unknown |  |
| phone_number_accepts_sms | Unknown |  |
| phone_number_country_code | Unknown |  |
| phone_number_display | Unknown |  |
| phone_number_e_164 | Unknown |  |
| phone_number_extension | Unknown |  |
| phone_number_normalization_country_code | Unknown |  |
| phone_number_user_input | Unknown |  |
| primary_contact_id | Unknown |  |
| revenue | Unknown |  |
| schema_applies_to | Json |  |
| schema_created_by_id | Unknown |  |
| schema_created_by_name | Unknown |  |
| schema_date_created | Unknown |  |
| schema_enabled | Unknown |  |
| schema_id | Unknown |  |
| schema_json_schema | Unknown |  |
| schema_json_schema_additional_properties | Json |  |
| schema_json_schema_description | Unknown |  |
| schema_json_schema_id | Unknown |  |
| schema_json_schema_properties | Json |  |
| schema_json_schema_required | Json |  |
| schema_json_schema_title | Unknown |  |
| schema_json_schema_type | Unknown |  |
| schema_name | Unknown |  |
| schema_version | Unknown |  |
| self_uri | Unknown |  |
| tags | Json |  |
| trustor_authorization_permissions | Json |  |
| trustor_created_by_organization_default_country_code | Unknown |  |
| trustor_created_by_organization_default_language | Unknown |  |
| trustor_created_by_organization_default_site_id | Unknown |  |
| trustor_created_by_organization_domain | Unknown |  |
| trustor_created_by_organization_features | Json |  |
| trustor_created_by_organization_id | Unknown |  |
| trustor_created_by_organization_name | Unknown |  |
| trustor_created_by_organization_product_platform | Unknown |  |
| trustor_created_by_organization_self_uri | Unknown |  |
| trustor_created_by_organization_state | Unknown |  |
| trustor_created_by_organization_support_uri | Unknown |  |
| trustor_created_by_organization_third_party_org_name | Unknown |  |
| trustor_created_by_organization_third_party_uri | Unknown |  |
| trustor_created_by_organization_version | Unknown |  |
| trustor_created_by_organization_voicemail_enabled | Unknown |  |
| trustor_date_created | Unknown |  |
| trustor_enabled | Unknown |  |
| trustor_organization | Unknown |  |
| twitter_id | Unknown |  |
| twitter_name | Unknown |  |
| twitter_profile_url | Unknown |  |
| twitter_screen_name | Unknown |  |
| twitter_verified | Unknown |  |
| websites | Json |  |

### analytics_conversation_aggregate_query_data_metric

| Column | Type | Keys |
| --- | --- | --- |
| analytics_conversation_aggregate_query_data_index | Unknown | PK |
| conversation_id | Unknown | PK |
| index | Unknown | PK |
| interval | Unknown |  |
| media_type | Unknown |  |
| metric | Unknown |  |
| qualifier | Unknown |  |
| stats_count | Unknown |  |
| stats_count_negative | Unknown |  |
| stats_count_positive | Unknown |  |
| stats_current | Unknown |  |
| stats_denominator | Unknown |  |
| stats_max | Unknown |  |
| stats_min | Unknown |  |
| stats_numerator | Unknown |  |
| stats_p_95 | Unknown |  |
| stats_p_99 | Unknown |  |
| stats_ratio | Unknown |  |
| stats_sum | Unknown |  |
| stats_target | Unknown |  |

### contact_list_column_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_list_id | Unknown | PK, FK |
| column_name | Unknown |  |

### contact_list_phone_column

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_list_id | Unknown | FK |
| callable_time_column | Unknown |  |
| column_name | Unknown |  |
| type | Unknown |  |

### contact_list_email_column

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_list_id | Unknown | FK |
| callable_time_column | Unknown |  |
| column_name | Unknown |  |
| type | Unknown |  |

### contact_list_preview_mode_accepted_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_list_id | Unknown | PK, FK |
| preview_mode_accepted_value | Unknown |  |

### column_data_type_specification

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_list_id | Unknown | FK |
| column_data_type | Unknown |  |
| column_name | Unknown |  |
| max | Unknown |  |
| max_length | Unknown |  |
| min | Unknown |  |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attempt_limit_id | Unknown | FK |
| division_id | Unknown | FK |
| automatic_time_zone_mapping | Unknown |  |
| date_created | Unknown |  |
| date_modified | Instant |  |
| import_status_completed_record | Unknown |  |
| import_status_failure_reason | Unknown |  |
| import_status_percent_complete | Unknown |  |
| import_status_state | Unknown |  |
| import_status_total_record | Unknown |  |
| name | Unknown |  |
| preview_mode_column_name | Unknown |  |
| self_uri | Unknown |  |
| size | Unknown |  |
| trim_white_space | Unknown |  |
| version | Unknown |  |
| zip_code_column_name | Unknown |  |

### workforce_management_intraday_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| end_date | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| forecast_data_average_handle_time_second | Unknown |  |
| forecast_data_offered | Unknown |  |
| media_type | Unknown |  |
| performance_prediction_data_per_interval | Json |  |
| performance_prediction_data_summary_average_speed_of_answer_seconds | Unknown |  |
| performance_prediction_data_summary_occupancy_percent | Unknown |  |
| performance_prediction_data_summary_service_level_percent | Unknown |  |
| schedule_data_per_interval | Json |  |
| schedule_data_summary_on_queue_time_seconds | Unknown |  |

### workforce_management_intraday

| Column | Type | Keys |
| --- | --- | --- |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| category | Json |  |
| interval_length_minute | Unknown |  |
| no_data_reason | Unknown |  |
| schedule_id | Unknown |  |
| schedule_week_date | Unknown |  |
| short_term_forecast_description | Unknown |  |
| short_term_forecast_id | Unknown |  |
| short_term_forecast_week_date | Unknown |  |

### routing_wrapup_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| created_by | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| modified_by | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |

### callable_timeset_callable_time_slot

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| callable_timeset_id | Unknown |  |
| day | Unknown |  |
| start_time | Unknown |  |
| stop_time | Unknown |  |
| time_zone_id | Unknown |  |

### callable_timeset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created | Unknown |  |
| date_modified | Instant |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| version | Unknown |  |

### rule_condition_field_mapping

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index | Unknown | FK |
| rule_id | Unknown | FK |
| ruleset_id | Unknown | FK |
| contact_column_name | Unknown |  |
| data_action_field | Unknown |  |

### rule_condition_predicate

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index | Unknown | FK |
| rule_id | Unknown | FK |
| ruleset_id | Unknown | FK |
| comparison_value | Unknown |  |
| inverted | Unknown |  |
| output_field | Unknown |  |
| output_field_missing_resolution | Unknown |  |
| output_operator | Unknown |  |

### rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| rule_id | Unknown | PK, FK |
| ruleset_id | Unknown | PK, FK |
| agent_wrapup_field | Unknown |  |
| attribute_name | Unknown |  |
| call_analysis_result_field | Unknown |  |
| codes | Json |  |
| contact_id_field | Unknown |  |
| data_action_id | Unknown |  |
| data_action_name | Unknown |  |
| data_action_self_uri | Unknown |  |
| data_not_found_resolution | Unknown |  |
| inverted | Unknown |  |
| operator | Unknown |  |
| property | Unknown |  |
| property_type | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |
| value_type | Unknown |  |

### rule_action_field_mapping

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index | Unknown | FK |
| rule_id | Unknown | FK |
| ruleset_id | Unknown | FK |
| contact_column_name | Unknown |  |
| data_action_field | Unknown |  |

### rule_action

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| rule_id | Unknown | PK, FK |
| ruleset_id | Unknown | PK, FK |
| action_type_name | Unknown |  |
| agent_wrapup_field | Unknown |  |
| call_analysis_result_field | Unknown |  |
| contact_id_field | Unknown |  |
| data_action_id | Unknown |  |
| data_action_name | Unknown |  |
| data_action_self_uri | Unknown |  |
| properties | Json |  |
| type | Unknown |  |
| update_option | Unknown |  |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ruleset_id | Unknown | PK, FK |
| category | Unknown |  |
| name | Unknown |  |
| orders | Unknown |  |

### ruleset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_list_id | Unknown | FK |
| queue_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Instant |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| version | Unknown |  |

### sequence_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| sequence_id | Unknown | PK, FK |

### sequence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| current_campaign | Unknown |  |
| date_created | Unknown |  |
| date_modified | Instant |  |
| name | Unknown |  |
| repeat | Unknown |  |
| self_uri | Unknown |  |
| status | Unknown |  |
| stop_message | Unknown |  |
| version | Unknown |  |

### survey_form_question_group_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_form_id | Unknown | PK, FK |
| survey_form_question_group_id | Unknown | PK, FK |
| answer_options | Json |  |
| explanation_prompt | Unknown |  |
| help_text | Unknown |  |
| max_response_characters | Unknown |  |
| na_enabled | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |
| visibility_condition_combining_operation | Unknown |  |
| visibility_condition_predicates | Json |  |

### survey_form_question_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_form_id | Unknown | PK, FK |
| na_enabled | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| visibility_condition | Unknown |  |

### survey_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| context_id | Unknown |  |
| disabled | Unknown |  |
| footer | Unknown |  |
| header | Unknown |  |
| lang | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |
| self_uri | Unknown |  |

### wrapup_code_map

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| default_set | Json |  |
| id | Unknown |  |
| mapping | Json |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| version | Unknown |  |

### contact_list_filter_clause_predicate

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_list_filter_id | Unknown | FK |
| column_name | Unknown |  |
| column_type | Unknown |  |
| index | Unknown |  |
| inverted | Unknown |  |
| operator | Unknown |  |
| range_in_set | Json |  |
| range_max | Unknown |  |
| range_max_inclusive | Unknown |  |
| range_min | Unknown |  |
| range_min_inclusive | Unknown |  |
| value | Unknown |  |

### contact_list_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_list_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Instant |  |
| filter_type | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| version | Unknown |  |

### station

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| web_rtc_user_id | Unknown | FK |
| description | Unknown |  |
| line_appearance_id | Unknown |  |
| name | Unknown |  |
| primary_edge_id | Unknown |  |
| primary_edge_name | Unknown |  |
| primary_edge_self_uri | Unknown |  |
| secondary_edge | Unknown |  |
| secondary_edge_id | Unknown |  |
| secondary_edge_name | Unknown |  |
| secondary_edge_self_uri | Unknown |  |
| self_uri | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| web_rtc_call_appearances | Unknown |  |
| web_rtc_force_turn | Unknown |  |
| web_rtc_media_dscp | Unknown |  |
| web_rtc_persistent_enabled | Unknown |  |
| web_rtc_require_media_helper | Unknown |  |

### routing_skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_modified | Unknown |  |
| name | Unknown |  |
| self_uri | Unknown |  |
| state | Unknown |  |
| version | Unknown |  |

### group_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| group_id | Unknown | PK, FK |
| image_uri | Unknown |  |
| resolution | Unknown |  |

### group_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| group_id | Unknown | PK, FK |
| address | Unknown |  |
| display | Unknown |  |
| extension | Unknown |  |
| media_type | Unknown |  |
| type | Unknown |  |

### group_owner

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chat_jabber_id | Unknown |  |
| date_modified | Unknown |  |
| description | Unknown |  |
| member_count | Unknown |  |
| name | Unknown |  |
| rules_visible | Unknown |  |
| self_uri | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |
| visibility | Unknown |  |

### evaluation_form_published_version

| Column | Type | Keys |
| --- | --- | --- |
| context_id | Unknown | PK |
| id | Unknown | PK |
| evaluation_form_id | Unknown | PK, FK |
| modified_date | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |
| question_groups | Json |  |
| self_uri | Unknown |  |
| weight_mode | Unknown |  |

### evaluation_form_dispute_assignee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| evaluation_form_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| type | Unknown |  |

### evaluation_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| context_id | Unknown |  |
| evaluation_setting_disputes_allowed_per_evaluation | Unknown |  |
| evaluation_setting_disputes_enabled | Unknown |  |
| evaluation_setting_revisions_enabled | Unknown |  |
| modified_date | Unknown |  |
| name | Unknown |  |
| published | Unknown |  |
| self_uri | Unknown |  |
| weight_mode | Unknown |  |

### campaign_interaction_pending

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| queue_id | Unknown | FK |
| script_id | Unknown | FK |
| skill_id | Unknown | FK |
| active_preview_call | Unknown |  |
| agent_id | Unknown |  |
| agent_name | Unknown |  |
| agent_self_uri | Unknown |  |
| call_placed_time | Unknown |  |
| call_routed_time | Unknown |  |
| caller_address | Unknown |  |
| caller_name | Unknown |  |
| contact_id | Unknown |  |
| contact_name | Unknown |  |
| contact_self_uri | Unknown |  |
| conversation_id | Unknown |  |
| creation_time | Unknown |  |
| destination_address | Unknown |  |
| dialer_system_participant_id | Unknown |  |
| dialing_mode | Unknown |  |
| disposition | Unknown |  |
| last_active_preview_wrapup_time | Unknown |  |
| object_type | Unknown |  |
| parent_campaign_id | Unknown |  |
| preview_connected_time | Unknown |  |
| preview_pop_delivered_time | Unknown |  |
| self_uri | Unknown |  |

### campaign_interaction_proceed

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| queue_id | Unknown | FK |
| script_id | Unknown | FK |
| skill_id | Unknown | FK |
| active_preview_call | Unknown |  |
| agent_id | Unknown |  |
| agent_name | Unknown |  |
| agent_self_uri | Unknown |  |
| call_placed_time | Unknown |  |
| call_routed_time | Unknown |  |
| caller_address | Unknown |  |
| caller_name | Unknown |  |
| contact_id | Unknown |  |
| contact_name | Unknown |  |
| contact_self_uri | Unknown |  |
| conversation_id | Unknown |  |
| creation_time | Unknown |  |
| destination_address | Unknown |  |
| dialer_system_participant_id | Unknown |  |
| dialing_mode | Unknown |  |
| disposition | Unknown |  |
| last_active_preview_wrapup_time | Unknown |  |
| object_type | Unknown |  |
| parent_campaign_id | Unknown |  |
| preview_connected_time | Unknown |  |
| preview_pop_delivered_time | Unknown |  |
| self_uri | Unknown |  |

### campaign_interaction_previewing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| queue_id | Unknown | FK |
| script_id | Unknown | FK |
| skill_id | Unknown | FK |
| active_preview_call | Unknown |  |
| agent_id | Unknown |  |
| agent_name | Unknown |  |
| agent_self_uri | Unknown |  |
| call_placed_time | Unknown |  |
| call_routed_time | Unknown |  |
| caller_address | Unknown |  |
| caller_name | Unknown |  |
| contact_id | Unknown |  |
| contact_name | Unknown |  |
| contact_self_uri | Unknown |  |
| conversation_id | Unknown |  |
| creation_time | Unknown |  |
| destination_address | Unknown |  |
| dialer_system_participant_id | Unknown |  |
| dialing_mode | Unknown |  |
| disposition | Unknown |  |
| last_active_preview_wrapup_time | Unknown |  |
| object_type | Unknown |  |
| parent_campaign_id | Unknown |  |
| preview_connected_time | Unknown |  |
| preview_pop_delivered_time | Unknown |  |
| self_uri | Unknown |  |

### campaign_interaction_interacting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| queue_id | Unknown | FK |
| script_id | Unknown | FK |
| skill_id | Unknown | FK |
| active_preview_call | Unknown |  |
| agent_id | Unknown |  |
| agent_name | Unknown |  |
| agent_self_uri | Unknown |  |
| call_placed_time | Unknown |  |
| call_routed_time | Unknown |  |
| caller_address | Unknown |  |
| caller_name | Unknown |  |
| contact_id | Unknown |  |
| contact_name | Unknown |  |
| contact_self_uri | Unknown |  |
| conversation_id | Unknown |  |
| creation_time | Unknown |  |
| destination_address | Unknown |  |
| dialer_system_participant_id | Unknown |  |
| dialing_mode | Unknown |  |
| disposition | Unknown |  |
| last_active_preview_wrapup_time | Unknown |  |
| object_type | Unknown |  |
| parent_campaign_id | Unknown |  |
| preview_connected_time | Unknown |  |
| preview_pop_delivered_time | Unknown |  |
| self_uri | Unknown |  |

### campaign_interaction_scheduled

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| queue_id | Unknown | FK |
| script_id | Unknown | FK |
| skill_id | Unknown | FK |
| active_preview_call | Unknown |  |
| agent_id | Unknown |  |
| agent_name | Unknown |  |
| agent_self_uri | Unknown |  |
| call_placed_time | Unknown |  |
| call_routed_time | Unknown |  |
| caller_address | Unknown |  |
| caller_name | Unknown |  |
| contact_id | Unknown |  |
| contact_name | Unknown |  |
| contact_self_uri | Unknown |  |
| conversation_id | Unknown |  |
| creation_time | Unknown |  |
| destination_address | Unknown |  |
| dialer_system_participant_id | Unknown |  |
| dialing_mode | Unknown |  |
| disposition | Unknown |  |
| last_active_preview_wrapup_time | Unknown |  |
| object_type | Unknown |  |
| parent_campaign_id | Unknown |  |
| preview_connected_time | Unknown |  |
| preview_pop_delivered_time | Unknown |  |
| self_uri | Unknown |  |

### task_management_workitem_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_management_workitem_id | Unknown | PK, FK |
| task_management_workitem_workbin_id | Unknown | PK, FK |
| id | Unknown |  |

### task_management_workitem_score_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_management_workitem_id | Unknown | PK, FK |
| task_management_workitem_workbin_id | Unknown | PK, FK |
| agent | Unknown |  |
| score | Unknown |  |

### task_management_workitem_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | Unknown | PK |
| task_management_workitem_id | Unknown | PK, FK |
| workbin_id | Unknown | PK, FK |
| attribute_value | Unknown |  |

### task_management_workitem

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workbin_id | Unknown | PK |
| assignee_id | Unknown | FK |
| division_id | Unknown | FK |
| external_contact_id | Unknown | FK |
| queue_id | Unknown | FK |
| alert_timeout_seconds | Unknown |  |
| assignment_state | Unknown |  |
| auto_status_transition | Unknown |  |
| auto_status_transition_date_of_transition | Unknown |  |
| auto_status_transition_error_code | Unknown |  |
| auto_status_transition_error_message | Unknown |  |
| auto_status_transition_next_status | Unknown |  |
| date_assignment_state_changed | Unknown |  |
| date_closed | Unknown |  |
| date_created | Unknown |  |
| date_due | Unknown |  |
| date_expires | Unknown |  |
| date_modified | Unknown |  |
| date_status_changed | Unknown |  |
| description | Unknown |  |
| duration_seconds | Unknown |  |
| external_tag | Unknown |  |
| language_id | Unknown |  |
| modified_by_id | Unknown |  |
| name | Unknown |  |
| preferred_agents | Json |  |
| priority | Unknown |  |
| queue_name | Unknown |  |
| reporter_id | Unknown |  |
| reporter_name | Unknown |  |
| schema_id | Unknown |  |
| schema_name | Unknown |  |
| schema_version | Unknown |  |
| scored_agents | Unknown |  |
| self_uri | Unknown |  |
| status_category | Unknown |  |
| status_id | Unknown |  |
| status_name | Unknown |  |
| ttl | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| utilization_label_id | Unknown |  |

### historical_shrinkage_for_activity_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| end_date | Unknown | PK, FK |
| historical_shrinkage_activity_category_index | Unknown | PK, FK |
| management_unit_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| activity_code_id | Unknown |  |
| actual_shrinkage_percent | Unknown |  |
| actual_shrinkage_second | Unknown |  |
| paid_shrinkage_second | Unknown |  |
| planned_shrinkage_second | Unknown |  |
| scheduled_shrinkage_percent | Unknown |  |
| scheduled_shrinkage_second | Unknown |  |
| unpaid_shrinkage_second | Unknown |  |
| unplanned_shrinkage_second | Unknown |  |

### historical_shrinkage_activity_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| end_date | Unknown | PK, FK |
| management_unit_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| activity_category | Unknown |  |
| shrinkage_for_activity_category_actual_shrinkage_percent | Unknown |  |
| shrinkage_for_activity_category_actual_shrinkage_second | Unknown |  |
| shrinkage_for_activity_category_paid_shrinkage_second | Unknown |  |
| shrinkage_for_activity_category_planned_shrinkage_second | Unknown |  |
| shrinkage_for_activity_category_scheduled_shrinkage_percent | Unknown |  |
| shrinkage_for_activity_category_scheduled_shrinkage_second | Unknown |  |
| shrinkage_for_activity_category_unpaid_shrinkage_second | Unknown |  |
| shrinkage_for_activity_category_unplanned_shrinkage_second | Unknown |  |

### historical_shrinkage

| Column | Type | Keys |
| --- | --- | --- |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| management_unit_id | Unknown | PK, FK |
| aggregated_shrinkage_actual_shrinkage_percent | Unknown |  |
| aggregated_shrinkage_actual_shrinkage_second | Unknown |  |
| aggregated_shrinkage_paid_shrinkage_seconds | Unknown |  |
| aggregated_shrinkage_planned_shrinkage_second | Unknown |  |
| aggregated_shrinkage_scheduled_shrinkage_percent | Unknown |  |
| aggregated_shrinkage_scheduled_shrinkage_second | Unknown |  |
| aggregated_shrinkage_unpaid_shrinkage_second | Unknown |  |
| aggregated_shrinkage_unplanned_shrinkage_second | Unknown |  |
| business_unit_id | Json |  |
| total_logged_in_duration_second | Unknown |  |
| total_scheduled_duration_second | Unknown |  |

### analytics_conversation_details_division

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK, FK |
| division_id | Unknown | PK, FK |

### analytics_conversation_details_knowledge_base_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| knowledge_base_id | Unknown |  |

### analytics_conversation_details_evaluation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| assignee_id | Unknown | FK |
| conversation_id | Unknown | FK |
| division_id | Unknown | FK |
| evaluator_id | Unknown | FK |
| user_id | Unknown | FK |
| assignee_applicable | Unknown |  |
| calibration_id | Unknown |  |
| context_id | Unknown |  |
| deleted | Unknown |  |
| evaluation_id | Unknown |  |
| evaluation_status | Unknown |  |
| event_time | Unknown |  |
| form_id | Unknown |  |
| form_name | Unknown |  |
| queue_id | Unknown |  |
| released | Unknown |  |
| rescored | Unknown |  |
| total_critical_score | Unknown |  |
| total_score | Unknown |  |

### analytics_conversation_details_survey

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| queue_id | Unknown | FK |
| user_id | Unknown | FK |
| event_time | Unknown |  |
| o_survey_total_score | Unknown |  |
| survey_completed_date | Unknown |  |
| survey_form_context_id | Unknown |  |
| survey_form_id | Unknown |  |
| survey_form_name | Unknown |  |
| survey_id | Unknown |  |
| survey_promoter_score | Unknown |  |
| survey_status | Unknown |  |

### analytics_conversation_details_resolution

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| queue_id | Unknown | FK |
| user_id | Unknown | FK |
| event_time | Unknown |  |
| n_next_contact_avoided | Unknown |  |

### analytics_conversation_details_participant_session_callback_number

| Column | Type | Keys |
| --- | --- | --- |
| callback_number | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |

### analytics_conversation_details_participant_session_bcc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| bcc | Unknown |  |

### analytics_conversation_details_participant_session_cc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| cc | Unknown |  |

### analytics_conversation_details_participant_session_destination_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| destination_addresses | Unknown |  |

### analytics_conversation_details_participant_session_eligible_agent_count

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| eligible_agent_count | Unknown |  |

### analytics_conversation_details_participant_session_requested_routing

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| requested_routing | Unknown |  |

### analytics_conversation_details_participant_session_waiting_interaction_counts

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| waiting_interaction_count | Unknown |  |

### analytics_conversation_details_participant_session_proposed_agent

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| agent_rank | Unknown |  |
| proposed_agent_id | Unknown |  |

### analytics_conversation_details_participant_session_agent_group

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| agent_group_id | Unknown |  |
| agent_group_type | Unknown |  |

### analytics_conversation_details_participant_session_media_endpoint_stats

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| codecs | Json |  |
| discarded_packets | Unknown |  |
| duplicate_packets | Unknown |  |
| event_time | Unknown |  |
| invalid_packets | Unknown |  |
| max_latency_ms | Unknown |  |
| min_mos | Unknown |  |
| min_r_factor | Unknown |  |
| overrun_packets | Unknown |  |
| received_packets | Unknown |  |
| underrun_packets | Unknown |  |

### analytics_conversation_details_participant_session_flow_outcome

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| flow_outcome | Unknown |  |
| flow_outcome_end_timestamp | Unknown |  |
| flow_outcome_id | Unknown |  |
| flow_outcome_start_timestamp | Unknown |  |
| flow_outcome_value | Unknown |  |

### analytics_conversation_details_participant_session_metric

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| emit_date | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### analytics_conversation_details_participant_session_segment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| participant_id | Unknown | FK |
| session_id | Unknown | FK |
| audio_muted | Unknown |  |
| conference | Unknown |  |
| destination_conversation_id | Unknown |  |
| destination_session_id | Unknown |  |
| disconnect_type | Unknown |  |
| error_code | Unknown |  |
| group_id | Unknown |  |
| properties | Json |  |
| q_850_response_code | Json |  |
| queue_id | Unknown |  |
| requested_language_id | Unknown |  |
| requested_routing_skill_ids | Json |  |
| requested_routing_user_ids | Json |  |
| scored_agents | Json |  |
| segment_end | Unknown |  |
| segment_start | Unknown |  |
| segment_type | Unknown |  |
| sip_response_codes | Json |  |
| source_conversation_id | Unknown |  |
| source_session_id | Unknown |  |
| subject | Unknown |  |
| video_muted | Unknown |  |
| wrap_up_code | Unknown |  |
| wrap_up_note | Unknown |  |
| wrap_up_tags | Json |  |

### analytics_conversation_details_participant_session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| assigner_id | Unknown | FK |
| campaign_id | Unknown | FK |
| contact_list_id | Unknown | FK |
| script_id | Unknown | FK |
| acw_skipped | Unknown |  |
| address_from | Unknown |  |
| address_other | Unknown |  |
| address_self | Unknown |  |
| address_to | Unknown |  |
| agent_assistant_id | Unknown |  |
| agent_bullseye_ring | Unknown |  |
| agent_owned | Unknown |  |
| ani | Unknown |  |
| authenticated | Unknown |  |
| barged_participant_id | Unknown |  |
| callback_scheduled_time | Unknown |  |
| callback_user_name | Unknown |  |
| cleared | Unknown |  |
| coached_participant_id | Unknown |  |
| cobrowse_role | Unknown |  |
| cobrowse_room_id | Unknown |  |
| contact_id | Unknown |  |
| delivery_status | Unknown |  |
| delivery_status_change_date | Unknown |  |
| direction | Unknown |  |
| disposition_analyzer | Unknown |  |
| disposition_name | Unknown |  |
| dnis | Unknown |  |
| edge_id | Unknown |  |
| extended_delivery_status | Unknown |  |
| flow_in_type | Unknown |  |
| flow_out_type | Unknown |  |
| journey_action_id | Unknown |  |
| journey_action_map_id | Unknown |  |
| journey_action_map_version | Unknown |  |
| journey_customer_id | Unknown |  |
| journey_customer_id_type | Unknown |  |
| journey_customer_session_id | Unknown |  |
| journey_customer_session_id_type | Unknown |  |
| media_bridge_id | Unknown |  |
| media_count | Unknown |  |
| media_type | Unknown |  |
| message_type | Unknown |  |
| monitored_participant_id | Unknown |  |
| peer_id | Unknown |  |
| protocol_call_id | Unknown |  |
| provider | Unknown |  |
| recording | Unknown |  |
| remote | Unknown |  |
| remote_name_displayable | Unknown |  |
| room_id | Unknown |  |
| routing_ring | Unknown |  |
| routing_rule | Unknown |  |
| routing_rule_type | Unknown |  |
| screen_share_address_self | Unknown |  |
| screen_share_room_id | Unknown |  |
| selected_agent_id | Unknown |  |
| selected_agent_rank | Unknown |  |
| session_dnis | Unknown |  |
| sharing_screen | Unknown |  |
| skip_enabled | Unknown |  |
| timeout_seconds | Unknown |  |
| used_routing | Unknown |  |
| video_address_self | Unknown |  |
| video_room_id | Unknown |  |

### analytics_conversation_details_participant_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_name | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| attribute_value | Unknown |  |

### analytics_conversation_details_participant

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| external_contact_id | Unknown |  |
| external_organization_id | Unknown |  |
| flagged_reason | Unknown |  |
| participant_name | Unknown |  |
| purpose | Unknown |  |
| team_id | Unknown |  |

### analytics_conversation_details

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK |
| conference_start | Unknown |  |
| conversation_end | Unknown |  |
| conversation_initiator | Unknown |  |
| conversation_start | Unknown |  |
| customer_participation | Unknown |  |
| evaluation_form_context_id | Unknown |  |
| evaluation_form_id | Unknown |  |
| evaluation_form_modified_date | Unknown |  |
| evaluation_form_name | Unknown |  |
| evaluation_form_published | Unknown |  |
| evaluation_form_self_uri | Unknown |  |
| external_tag | Unknown |  |
| media_stats_min_conversation_mos | Unknown |  |
| media_stats_min_conversation_r_factor | Unknown |  |
| originating_direction | Unknown |  |
| self_served | Unknown |  |
| wrapup_code | Unknown |  |
| wrapup_duration_seconds | Unknown |  |
| wrapup_end_time | Unknown |  |
| wrapup_name | Unknown |  |
| wrapup_notes | Unknown |  |
| wrapup_provisional | Unknown |  |

### analytics_conversation_details_participant_session_skill_id

| Column | Type | Keys |
| --- | --- | --- |
| skill_id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| participant_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| object_type | Unknown |  |

### historical_adherence_exception_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| end_date | Unknown | PK, FK |
| management_unit_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| actual_activity_category | Unknown |  |
| actual_activity_code_id | Unknown |  |
| end_offset_second | Unknown |  |
| impact | Unknown |  |
| routing_status | Unknown |  |
| scheduled_activity_category | Unknown |  |
| scheduled_activity_code_id | Unknown |  |
| scheduled_secondary_presence_lookup_id | Json |  |
| secondary_presence_lookup_id | Unknown |  |
| start_offset_second | Unknown |  |
| system_presence | Unknown |  |

### historical_adherence_day_metrics

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| management_unit_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| actual_length_second | Unknown |  |
| adherence_percentage | Unknown |  |
| adherence_schedule_second | Unknown |  |
| conformance_actual_second | Unknown |  |
| conformance_percentage | Unknown |  |
| conformance_schedule_second | Unknown |  |
| day_start_offset_second | Unknown |  |
| exception_count | Unknown |  |
| exception_duration_second | Unknown |  |
| impact_second | Unknown |  |
| schedule_length_second | Unknown |  |

### historical_adherence_actual

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| end_date | Unknown | PK, FK |
| management_unit_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| actual_activity_category | Unknown |  |
| actual_secondary_presence_lookup_id | Unknown |  |
| end_offset_second | Unknown |  |
| start_offset_second | Unknown |  |

### historical_adherence

| Column | Type | Keys |
| --- | --- | --- |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| management_unit_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| adherence_percentage | Unknown |  |
| conformance_percentage | Unknown |  |
| impact | Unknown |  |

### analytic_user_detail_primary_presence

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | PK, FK |
| end_time | Unknown |  |
| organization_presence_id | Unknown |  |
| start_time | Unknown |  |
| system_presence | Unknown |  |

### analytic_user_detail_routing_status

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | PK, FK |
| end_time | Unknown |  |
| routing_status | Unknown |  |
| start_time | Unknown |  |

### analytic_user_detail

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK, FK |

### speech_and_text_analytics_transcript

| Column | Type | Keys |
| --- | --- | --- |
| transcript_id | Unknown | PK |
| communication_id | Unknown | PK, FK |
| conversation_id | Unknown | PK, FK |
| duration | Json |  |
| end_time | Unknown |  |
| engine_id | Unknown |  |
| engine_provider | Unknown |  |
| features | Json |  |
| languages | Unknown |  |
| phrases | Json |  |
| program_id | Unknown |  |
| start_time | Unknown |  |
| analytics_** |  |  |

### speech_and_text_analytics_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| communication_id | Unknown | PK, FK |
| conversation_id | Unknown | PK, FK |
| ani | Unknown |  |
| division_id | Unknown |  |
| dnis | Unknown |  |
| end_time_ms | Unknown |  |
| flow_id | Unknown |  |
| flow_version | Unknown |  |
| initial_direction | Unknown |  |
| participant_purpose | Unknown |  |
| queue_id | Unknown |  |
| start_time_ms | Unknown |  |
| user_id | Unknown |  |
| wrap_up_code | Unknown |  |
| wrap_up_notes | Unknown |  |

### speech_and_text_analytics

| Column | Type | Keys |
| --- | --- | --- |
| communication_id | Unknown | PK |
| conversation_id | Unknown | PK |
| conversation_duration | Unknown |  |
| conversation_start_time | Unknown |  |
| duration | Json |  |
| handle_time | Unknown |  |
| is_named_entities_analyzed | Unknown |  |
| media_type | Unknown |  |
| organization_id | Unknown |  |
| recording_id | Unknown |  |
| start_time | Unknown |  |

## Relationships

- user_skill_group_skill_condition_routing_skill_condition(user_skill_group_id) → user_skill_group(id)
- user_skill_group_skill_condition_routing_skill_condition(user_id) → user_skill_group(user_id)
- user_skill_group_skill_condition_language_skill_condition(user_skill_group_id) → user_skill_group(id)
- user_skill_group_skill_condition_language_skill_condition(user_id) → user_skill_group(user_id)
- user_skill_group(division_id) → division(id)
- user_skill_group(user_id) → users(id)
- user_call_forwarding_target(user_call_forwarding_id) → user_call_forwarding(id)
- user_call_forwarding_target(user_id) → user_call_forwarding(user_id)
- user_call_forwarding(user_id) → users(id)
- evaluation_answer_question_group_question_score(evaluation_id) → evaluation_answer_question_group_score(evaluation_id)
- evaluation_answer_question_group_question_score(evaluation_answer_question_group_score_question_group_id) → evaluation_answer_question_group_score(question_group_id)
- evaluation_answer_question_group_score(evaluation_id) → evaluation(id)
- evaluation_answer_transcript_topic(evaluation_id) → evaluation(id)
- evaluation(calibration_id) → calibration(id)
- evaluation(queue_id) → routing_queue(id)
- evaluation(assignee_id) → users(id)
- evaluation(evaluation_form_id) → evaluation_form(id)
- evaluation(evaluator_id) → users(id)
- evaluation(agent_team_division_id) → division(id)
- users_group(id) → groups(id)
- agent_activity_evaluator_list_contact_info(agent_activity_evaluator_list_index) → agent_activity_evaluator_list(index)
- agent_activity_evaluator_list_contact_info(agent_activity_fivetran_id) → agent_activity_evaluator_list(agent_activity_fivetran_id)
- agent_activity_evaluator_list(agent_id) → users(id)
- agent_activity_evaluator_list(evaluator_id) → users(id)
- agent_activity_evaluator_list(agent_activity_fivetran_id) → agent_activity(_fivetran_id)
- agent_activity(integration_presence_definition_id) → presence_definition(id)
- agent_activity(presence_definition_id) → presence_definition(id)
- agent_activity(agent_id) → users(id)
- aggregate_query_conversation_survey_answer_question_group_question_score(conversation_survey_id) → aggregate_query_conversation_survey_answer_question_group_score(conversation_survey_id)
- aggregate_query_conversation_survey_answer_question_group_question_score(conversation_id) → aggregate_query_conversation_survey_answer_question_group_score(conversation_id)
- aggregate_query_conversation_survey_answer_question_group_question_score(conversation_survey_answer_question_group_score_index) → aggregate_query_conversation_survey_answer_question_group_score(index)
- aggregate_query_conversation_survey_answer_question_group_score(conversation_survey_id) → aggregate_query_conversation_survey(id)
- aggregate_query_conversation_survey_answer_question_group_score(conversation_id) → aggregate_query_conversation_survey(conversation_id)
- aggregate_query_conversation_survey(queue_id) → user_queue(id)
- aggregate_query_conversation_survey(agent_id) → users(id)
- aggregate_query_conversation_survey(survey_form_id) → survey_form(id)
- flow_milestone(division_id) → division(id)
- campaign_diagnostic_dnc(dnc_id) → dnc(id)
- campaign_diagnostic_dnc(campaign_id) → campaign_diagnostic(campaign_id)
- campaign_diagnostic_rule_set(rule_set_id) → ruleset(id)
- campaign_diagnostic_rule_set(campaign_id) → campaign_diagnostic(campaign_id)
- campaign_rule_set_diagnostic(rule_set_id) → ruleset(id)
- campaign_rule_set_diagnostic(campaign_id) → campaign_diagnostic(campaign_id)
- campaign_diagnostic(attempt_limit_id) → attempt_limit(id)
- campaign_diagnostic(callable_time_set_id) → callable_timeset(id)
- campaign_diagnostic(queue_utilization_diagnostic_queue_id) → routing_queue(id)
- campaign_diagnostic(campaign_id) → campaign(id)
- intraday_planning_routepath(intraday_planning_id) → intraday_planning(id)
- intraday_planning_routepath(intraday_planning_date) → intraday_planning(date)
- intraday_planning_routepath(business_unit_id) → intraday_planning(business_unit_id)
- intraday_planning(business_unit_id) → business_unit(id)
- campaign_progress(contact_list_id) → contact_list(id)
- campaign_progress(campaign_id) → campaign(id)
- management_unit(business_unit_id) → business_unit(id)
- management_unit(modified_by_id) → users(id)
- management_unit(created_by_id) → users(id)
- messaging_campaign_dnc(dnc_id) → dnc(id)
- messaging_campaign_dnc(messaging_campaign_id) → messaging_campaign(id)
- messaging_campaign_contact_sort(messaging_campaign_id) → messaging_campaign(id)
- messaging_campaign_contact_list_filter(contact_list_filter_id) → contact_list_filter(id)
- messaging_campaign_contact_list_filter(messaging_campaign_id) → messaging_campaign(id)
- messaging_campaign_rule_set(rule_set_id) → ruleset(id)
- messaging_campaign_rule_set(messaging_campaign_id) → messaging_campaign(id)
- messaging_campaign_error(messaging_campaign_id) → messaging_campaign(id)
- messaging_campaign(contact_list_id) → contact_list(id)
- messaging_campaign(division_id) → division(id)
- messaging_campaign(callable_time_set_id) → callable_timeset(id)
- flow_data_table(division_id) → division(id)
- campaign_agent_mapping_review_result(user_id) → users(id)
- routing_queue_routing_rule(routing_queue_id) → routing_queue(id)
- routing_queue_conditional_group_routing_rule_group(group_id) → groups(id)
- routing_queue_conditional_group_routing_rule_group(index) → routing_queue_conditional_group_routing_rule(index)
- routing_queue_conditional_group_routing_rule_group(routing_queue_id) → routing_queue_conditional_group_routing_rule(routing_queue_id)
- routing_queue_conditional_group_routing_rule(routing_queue_id) → routing_queue(id)
- routing_queue_bulls_eye_ring_expansion_criteria(routing_queue_id) → routing_queue(id)
- routing_queue_bulls_eye_ring_skill_to_remove(routing_queue_id) → routing_queue(id)
- routing_queue_bulls_eye_ring_member_group(routing_queue_id) → routing_queue(id)
- routing_queue_member_group(routing_queue_id) → routing_queue(id)
- routing_queue_email_address_route_skill(routing_queue_id) → routing_queue(id)
- routing_queue_email_address_auto_bcc(routing_queue_id) → routing_queue(id)
- routing_queue(division_id) → division(id)
- conversation_call_history_participants(user_id) → users(id)
- conversation_call_history_participants(campaign_id) → campaign(id)
- conversation_call_history_participants(group_id) → groups(id)
- conversation_call_history_participants(queue_id) → routing_queue(id)
- conversation_call_history_participants(conversation_call_history_id) → conversation_call_history(id)
- schedule_campaign_interval(schedule_campaign_id) → schedule_campaign(id)
- schedule_campaign(campaign_id) → campaign(id)
- survey_form_published_version(survey_form_id) → survey_form(id)
- workforce_management_unit_agent(id) → users(id)
- workforce_management_unit_agent(work_plan_management_unit_id) → management_unit(id)
- campaign_stats(campaign_id) → campaign(id)
- user_queue_routing_rule(user_queue_id) → user_queue(id)
- user_queue_routing_rule(user_id) → user_queue(user_id)
- user_queue_conditional_group_routing_rule_group(index) → user_queue_conditional_group_routing_rule(index)
- user_queue_conditional_group_routing_rule_group(user_queue_id) → user_queue_conditional_group_routing_rule(user_queue_id)
- user_queue_conditional_group_routing_rule_group(user_id) → user_queue_conditional_group_routing_rule(user_id)
- user_queue_conditional_group_routing_rule(user_queue_id) → user_queue(id)
- user_queue_conditional_group_routing_rule(user_id) → user_queue(user_id)
- user_queue_bulls_eye_ring_expansion_criteria(user_queue_id) → user_queue(id)
- user_queue_bulls_eye_ring_expansion_criteria(user_id) → user_queue(user_id)
- user_queue_bulls_eye_ring_skill_to_remove(user_queue_id) → user_queue(id)
- user_queue_bulls_eye_ring_skill_to_remove(user_id) → user_queue(user_id)
- user_queue_bulls_eye_ring_member_group(user_queue_id) → user_queue(id)
- user_queue_bulls_eye_ring_member_group(user_id) → user_queue(user_id)
- user_queue_member_group(user_queue_id) → user_queue(id)
- user_queue_member_group(user_id) → user_queue(user_id)
- user_queue_email_address_route_skill(user_queue_id) → user_queue(id)
- user_queue_email_address_route_skill(user_id) → user_queue(user_id)
- user_queue_email_address_auto_bcc(user_queue_id) → user_queue(id)
- user_queue_email_address_auto_bcc(user_id) → user_queue(user_id)
- user_queue(division_id) → division(id)
- user_queue(user_id) → users(id)
- users_primary_contact_info(user_id) → users(id)
- users_address(user_id) → users(id)
- users_image(user_id) → users(id)
- users_certification(user_id) → users(id)
- users_biography_interest(user_id) → users(id)
- users_biography_hobby(user_id) → users(id)
- users_biography_education(user_id) → users(id)
- users_geo_location_location(id) → location(id)
- users_geo_location_location(users_geo_location_id) → users_geo_location(id)
- users_geo_location_location(user_id) → users_geo_location(user_id)
- users_geo_location(id) → location(id)
- users_geo_location(user_id) → users(id)
- users_profile_skill(user_id) → users(id)
- users_location(location_definition_id) → location(id)
- users_location(user_id) → users(id)
- users_skill(user_id) → users(id)
- users_language(user_id) → users(id)
- users_authorization_role(user_id) → users(id)
- users_authorization_unused_role(user_id) → users(id)
- users_authorization_permission(user_id) → users(id)
- users_authorization_permission_policy(user_id) → users(id)
- users(out_of_office_user_id) → users(id)
- users(routing_status_user_id) → users(id)
- users(manager_id) → users(id)
- users(division_id) → division(id)
- users(conversation_summary_user_id) → users(id)
- users(associated_station_user_id) → users(id)
- users(associated_station_location_id) → location(id)
- users(effective_station_user_id) → users(id)
- users(effective_station_location_id) → location(id)
- users(default_station_user_id) → users(id)
- users(default_station_location_id) → location(id)
- users(last_associated_station_user_id) → users(id)
- users(last_associated_station_location_id) → location(id)
- users(team_division_id) → division(id)
- users(associated_station_default_user) → users(id)
- users(effective_station_default_user) → users(id)
- users(default_station_default_user) → users(id)
- users(last_associated_station_default_user) → users(id)
- campaign_phone_column(campaign_id) → campaign(id)
- campaign_dnc(dnc_id) → dnc(id)
- campaign_dnc(campaign_id) → campaign(id)
- campaign_errors(campaign_id) → campaign(id)
- campaign_rule_set(rule_set_id) → ruleset(id)
- campaign_rule_set(campaign_id) → campaign(id)
- campaign_contact_sort(campaign_id) → campaign(id)
- campaign_contact_list_filter(contact_list_filter_id) → contact_list_filter(id)
- campaign_contact_list_filter(campaign_id) → campaign(id)
- campaign(script_id) → script(id)
- campaign(contact_list_id) → contact_list(id)
- campaign(division_id) → division(id)
- campaign(queue_id) → routing_queue(id)
- campaign(callable_time_set_id) → callable_timeset(id)
- flow_outcome_error_detail(flow_outcome_id) → flow_outcome(id)
- flow_outcome(division_id) → division(id)
- flow_outcome(current_operation_user_id) → users(id)
- user_routing_skill(user_id) → users(id)
- conversation_callback_participants_wrapup_tag(conversation_callback_participants_id) → conversation_callback_participants(id)
- conversation_callback_participants_wrapup_tag(conversation_callback_id) → conversation_callback_participants(conversation_callback_id)
- conversation_callback_participants_callback_number(conversation_callback_participants_id) → conversation_callback_participants(id)
- conversation_callback_participants_callback_number(conversation_callback_id) → conversation_callback_participants(conversation_callback_id)
- conversation_callback_participants_media_role(conversation_callback_participants_id) → conversation_callback_participants(id)
- conversation_callback_participants_media_role(conversation_callback_id) → conversation_callback_participants(conversation_callback_id)
- conversation_callback_participants(user_id) → users(id)
- conversation_callback_participants(queue_id) → routing_queue(id)
- conversation_callback_participants(conversation_callback_id) → conversation_callback(id)
- conversation_callback_other_media_uris(conversation_callback_id) → conversation_callback(id)
- conversation_callback_participants_recent_transfer(initiator_id) → users(id)
- conversation_callback_participants_recent_transfer(modified_by_id) → users(id)
- conversation_callback_participants_recent_transfer(destination_user_id) → users(id)
- conversation_callback_participants_recent_transfer(conversation_callback_id) → conversation_callback(id)
- schedule_message_severity_count(schedule_id) → schedule(id)
- schedule_message_severity_count(schedule_week_date) → schedule(week_date)
- schedule_message_severity_count(schedule_business_unit_id) → schedule(business_unit_id)
- schedule_management_unit_agent(schedule_week_date) → schedule_management_unit(schedule_week_date)
- schedule_management_unit_agent(schedule_id) → schedule_management_unit(schedule_id)
- schedule_management_unit_agent(schedule_management_unit_index) → schedule_management_unit(index)
- schedule_management_unit_agent(schedule_business_unit_id) → schedule_management_unit(schedule_business_unit_id)
- schedule_management_unit(management_unit_id) → management_unit(id)
- schedule_management_unit(schedule_id) → schedule(id)
- schedule_management_unit(schedule_week_date) → schedule(week_date)
- schedule_management_unit(schedule_business_unit_id) → schedule(business_unit_id)
- schedule(created_by_id) → users(id)
- conversation_survey_answer_question_group_question_score(conversation_survey_id) → conversation_survey_answer_question_group_score(conversation_survey_id)
- conversation_survey_answer_question_group_question_score(conversation_id) → conversation_survey_answer_question_group_score(conversation_id)
- conversation_survey_answer_question_group_question_score(conversation_survey_answer_question_group_score_index) → conversation_survey_answer_question_group_score(index)
- conversation_survey_answer_question_group_score(conversation_survey_id) → conversation_survey(id)
- conversation_survey_answer_question_group_score(conversation_id) → conversation_survey(conversation_id)
- conversation_survey(queue_id) → user_queue(id)
- conversation_survey(agent_id) → users(id)
- conversation_survey(survey_form_id) → survey_form(id)
- location_path(location_id) → location(id)
- location_profile_image(location_id) → location(id)
- location_floor_plan_image(location_id) → location(id)
- location(contact_user_id) → users(id)
- dnc_code(dnc_id) → dnc(id)
- dnc(campaign_id) → campaign(id)
- dnc(division_id) → division(id)
- activity_code_secondary_presence(activity_code_id) → activity_code(id)
- activity_code(modified_by_id) → users(id)
- user_routing_language(user_id) → users(id)
- business_unit(division_id) → division(id)
- script_page(script_id) → script(id)
- script(division_id) → division(id)
- evaluation_form_question_group_question_answer_option_assistance_condition(evaluation_form_id) → evaluation_form_question_group_question_answer_option(evaluation_form_id)
- evaluation_form_question_group_question_answer_option_assistance_condition(evaluation_form_question_group_index) → evaluation_form_question_group_question_answer_option(evaluation_form_question_group_index)
- evaluation_form_question_group_question_answer_option_assistance_condition(evaluation_form_question_group_question_index) → evaluation_form_question_group_question_answer_option(evaluation_form_question_group_question_index)
- evaluation_form_question_group_question_answer_option_assistance_condition(evaluation_form_question_group_question_answer_option_index) → evaluation_form_question_group_question_answer_option(index)
- evaluation_form_question_group_question_answer_option(evaluation_form_id) → evaluation_form_question_group_question(evaluation_form_id)
- evaluation_form_question_group_question_answer_option(evaluation_form_question_group_index) → evaluation_form_question_group_question(evaluation_form_question_group_index)
- evaluation_form_question_group_question_answer_option(evaluation_form_question_group_question_index) → evaluation_form_question_group_question(index)
- evaluation_form_question_group_question(evaluation_form_id) → evaluation_form_question_group(evaluation_form_id)
- evaluation_form_question_group_question(evaluation_form_question_group_index) → evaluation_form_question_group(index)
- campaign_rule_campaign(campaign_id) → campaign(id)
- campaign_rule_campaign(campaign_rule_id) → campaign_rule(id)
- campaign_rule_entity_sequence(id) → sequence(id)
- campaign_rule_entity_sequence(campaign_rule_id) → campaign_rule(id)
- campaign_rule_condition(campaign_rule_id) → campaign_rule(id)
- campaign_rule_action_campaign(campaign_id) → campaign(id)
- campaign_rule_action_campaign(campaign_rule_action_id) → campaign_rule_action(id)
- campaign_rule_action_campaign(campaign_rule_id) → campaign_rule_action(campaign_rule_id)
- campaign_rule_action_sequence(id) → sequence(id)
- campaign_rule_action_sequence(campaign_rule_action_id) → campaign_rule_action(id)
- campaign_rule_action_sequence(campaign_rule_id) → campaign_rule_action(campaign_rule_id)
- campaign_rule_action(campaign_rule_id) → campaign_rule(id)
- external_contact_identifier(external_contact_id) → external_contact(id)
- external_contact_line_id(user_id) → users(id)
- external_contact_line_id(external_contact_id) → external_contact(id)
- external_contact_facebook_id(external_contact_id) → external_contact(id)
- external_contact_external_data_source(external_contact_id) → external_contact(id)
- external_contact_external_id(external_contact_id) → external_contact(id)
- external_contact_attribute(external_contact_id) → external_contact(id)
- external_contact(organization_id) → organization(id)
- external_contact(canonical_contact_id) → contact_list(id)
- calibration(scoring_index_id) → evaluation(id)
- calibration(evaluator_id) → users(id)
- calibration(expert_evaluator_id) → users(id)
- calibration(agent_id) → users(id)
- calibration(evaluation_form_id) → evaluation_form(id)
- calibration(evaluation_id) → evaluation(id)
- calibration(calibrator_id) → users(id)
- calibration(manager_id) → users(id)
- analytics_conversation_aggregate_query_details_division(division_id) → division(id)
- analytics_conversation_aggregate_query_details_division(conversation_id) → analytics_conversation_aggregate_query_details(conversation_id)
- analytics_conversation_aggregate_query_details_knowledge_base_id(conversation_id) → analytics_conversation_aggregate_query_details(conversation_id)
- analytics_conversation_aggregate_query_details_evaluation(user_id) → users(id)
- analytics_conversation_aggregate_query_details_evaluation(evaluator_id) → users(id)
- analytics_conversation_aggregate_query_details_evaluation(assignee_id) → users(id)
- analytics_conversation_aggregate_query_details_evaluation(division_id) → division(id)
- analytics_conversation_aggregate_query_details_evaluation(conversation_id) → analytics_conversation_aggregate_query_details(conversation_id)
- analytics_conversation_aggregate_query_details_survey(user_id) → users(id)
- analytics_conversation_aggregate_query_details_survey(queue_id) → routing_queue(id)
- analytics_conversation_aggregate_query_details_survey(conversation_id) → analytics_conversation_aggregate_query_details(conversation_id)
- analytics_conversation_aggregate_query_details_resolution(user_id) → users(id)
- analytics_conversation_aggregate_query_details_resolution(queue_id) → routing_queue(id)
- analytics_conversation_aggregate_query_details_resolution(conversation_id) → analytics_conversation_aggregate_query_details(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_callback_number(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_callback_number(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_callback_number(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_bcc(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_bcc(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_bcc(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_cc(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_cc(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_cc(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_destination_address(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_destination_address(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_destination_address(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_eligible_agent_count(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_eligible_agent_count(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_eligible_agent_count(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_requested_routing(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_requested_routing(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_requested_routing(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_waiting_interaction_counts(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_waiting_interaction_counts(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_waiting_interaction_counts(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_proposed_agent(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_proposed_agent(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_proposed_agent(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_agent_group(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_agent_group(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_agent_group(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_media_endpoint_stats(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_media_endpoint_stats(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_media_endpoint_stats(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_flow_outcome(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_flow_outcome(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_flow_outcome(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_metric(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_metric(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_metric(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_segment(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_segment(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_segment(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session(assigner_id) → users(id)
- analytics_conversation_aggregate_query_details_participant_session(campaign_id) → campaign(id)
- analytics_conversation_aggregate_query_details_participant_session(script_id) → script(id)
- analytics_conversation_aggregate_query_details_participant_session(contact_list_id) → contact_list(id)
- analytics_conversation_aggregate_query_details_participant_session(participant_id) → analytics_conversation_aggregate_query_details_participant(participant_id)
- analytics_conversation_aggregate_query_details_participant_session(conversation_id) → analytics_conversation_aggregate_query_details_participant(conversation_id)
- analytics_conversation_aggregate_query_details_participant(user_id) → users(id)
- analytics_conversation_aggregate_query_details_participant(participant_id) → users(id)
- analytics_conversation_aggregate_query_details_participant(conversation_id) → analytics_conversation_aggregate_query_details(conversation_id)
- analytics_conversation_aggregate_query_details_participant_session_skill_id(session_id) → analytics_conversation_aggregate_query_details_participant_session(session_id)
- analytics_conversation_aggregate_query_details_participant_session_skill_id(participant_id) → analytics_conversation_aggregate_query_details_participant_session(participant_id)
- analytics_conversation_aggregate_query_details_participant_session_skill_id(conversation_id) → analytics_conversation_aggregate_query_details_participant_session(conversation_id)
- messaging_campaign_progress(campaign_id) → campaign(id)
- messaging_campaign_progress(contact_list_id) → contact_list(id)
- messaging_campaign_progress(messaging_campaign_id) → messaging_campaign(id)
- organization_ticker(organization_id) → organization(id)
- organization_external_data_source(organization_id) → organization(id)
- organization_attribute(organization_id) → organization(id)
- organization(trustor_id) → organization(id)
- organization(created_by_id) → users(id)
- contact_list_column_name(contact_list_id) → contact_list(id)
- contact_list_phone_column(contact_list_id) → contact_list(id)
- contact_list_email_column(contact_list_id) → contact_list(id)
- contact_list_preview_mode_accepted_value(contact_list_id) → contact_list(id)
- column_data_type_specification(contact_list_id) → contact_list(id)
- contact_list(attempt_limit_id) → attempt_limit(id)
- contact_list(division_id) → division(id)
- workforce_management_intraday_group(start_date) → workforce_management_intraday(start_date)
- workforce_management_intraday_group(end_date) → workforce_management_intraday(end_date)
- workforce_management_intraday_group(business_unit_id) → workforce_management_intraday(business_unit_id)
- workforce_management_intraday(business_unit_id) → business_unit(id)
- routing_wrapup_code(division_id) → division(id)
- rule_condition_field_mapping(index) → rule_condition(index)
- rule_condition_field_mapping(rule_id) → rule_condition(rule_id)
- rule_condition_field_mapping(ruleset_id) → rule_condition(ruleset_id)
- rule_condition_predicate(index) → rule_condition(index)
- rule_condition_predicate(rule_id) → rule_condition(rule_id)
- rule_condition_predicate(ruleset_id) → rule_condition(ruleset_id)
- rule_condition(rule_id) → rule(id)
- rule_condition(ruleset_id) → rule(ruleset_id)
- rule_action_field_mapping(index) → rule_action(index)
- rule_action_field_mapping(rule_id) → rule_action(rule_id)
- rule_action_field_mapping(ruleset_id) → rule_action(ruleset_id)
- rule_action(rule_id) → rule(id)
- rule_action(ruleset_id) → rule(ruleset_id)
- rule(ruleset_id) → ruleset(id)
- ruleset(contact_list_id) → contact_list(id)
- ruleset(queue_id) → routing_queue(id)
- sequence_campaign(campaign_id) → campaign(id)
- sequence_campaign(sequence_id) → sequence(id)
- survey_form_question_group_question(survey_form_id) → survey_form_question_group(survey_form_id)
- survey_form_question_group_question(survey_form_question_group_id) → survey_form_question_group(id)
- survey_form_question_group(survey_form_id) → survey_form(id)
- contact_list_filter_clause_predicate(contact_list_filter_id) → contact_list_filter(id)
- contact_list_filter(contact_list_id) → contact_list(id)
- station(user_id) → users(id)
- station(web_rtc_user_id) → users(id)
- group_image(group_id) → groups(id)
- group_address(group_id) → groups(id)
- group_owner(user_id) → users(id)
- group_owner(group_id) → groups(id)
- evaluation_form_published_version(evaluation_form_id) → evaluation_form(id)
- evaluation_form_dispute_assignee(user_id) → users(id)
- evaluation_form_dispute_assignee(evaluation_form_id) → evaluation_form(id)
- campaign_interaction_pending(campaign_id) → campaign(id)
- campaign_interaction_pending(script_id) → script(id)
- campaign_interaction_pending(queue_id) → routing_queue(id)
- campaign_interaction_pending(skill_id) → users_skill(id)
- campaign_interaction_proceed(campaign_id) → campaign(id)
- campaign_interaction_proceed(script_id) → script(id)
- campaign_interaction_proceed(queue_id) → routing_queue(id)
- campaign_interaction_proceed(skill_id) → users_skill(id)
- campaign_interaction_previewing(campaign_id) → campaign(id)
- campaign_interaction_previewing(script_id) → script(id)
- campaign_interaction_previewing(queue_id) → routing_queue(id)
- campaign_interaction_previewing(skill_id) → users_skill(id)
- campaign_interaction_interacting(campaign_id) → campaign(id)
- campaign_interaction_interacting(script_id) → script(id)
- campaign_interaction_interacting(queue_id) → routing_queue(id)
- campaign_interaction_interacting(skill_id) → users_skill(id)
- campaign_interaction_scheduled(campaign_id) → campaign(id)
- campaign_interaction_scheduled(script_id) → script(id)
- campaign_interaction_scheduled(queue_id) → routing_queue(id)
- campaign_interaction_scheduled(skill_id) → users_skill(id)
- task_management_workitem_skill(task_management_workitem_id) → task_management_workitem(id)
- task_management_workitem_skill(task_management_workitem_workbin_id) → task_management_workitem(workbin_id)
- task_management_workitem_score_agent(task_management_workitem_id) → task_management_workitem(id)
- task_management_workitem_score_agent(task_management_workitem_workbin_id) → task_management_workitem(workbin_id)
- task_management_workitem_attribute(task_management_workitem_id) → task_management_workitem(id)
- task_management_workitem_attribute(workbin_id) → task_management_workitem(workbin_id)
- task_management_workitem(external_contact_id) → external_contact(id)
- task_management_workitem(division_id) → division(id)
- task_management_workitem(assignee_id) → users(id)
- task_management_workitem(queue_id) → user_queue(id)
- historical_shrinkage_for_activity_code(start_date) → historical_shrinkage_activity_category(start_date)
- historical_shrinkage_for_activity_code(end_date) → historical_shrinkage_activity_category(end_date)
- historical_shrinkage_for_activity_code(management_unit_id) → historical_shrinkage_activity_category(management_unit_id)
- historical_shrinkage_for_activity_code(historical_shrinkage_activity_category_index) → historical_shrinkage_activity_category(index)
- historical_shrinkage_activity_category(start_date) → historical_shrinkage(start_date)
- historical_shrinkage_activity_category(end_date) → historical_shrinkage(end_date)
- historical_shrinkage_activity_category(management_unit_id) → historical_shrinkage(management_unit_id)
- historical_shrinkage(management_unit_id) → management_unit(id)
- analytics_conversation_details_division(division_id) → division(id)
- analytics_conversation_details_division(conversation_id) → analytics_conversation_details(conversation_id)
- analytics_conversation_details_knowledge_base_id(conversation_id) → analytics_conversation_details(conversation_id)
- analytics_conversation_details_evaluation(user_id) → users(id)
- analytics_conversation_details_evaluation(evaluator_id) → users(id)
- analytics_conversation_details_evaluation(assignee_id) → users(id)
- analytics_conversation_details_evaluation(division_id) → division(id)
- analytics_conversation_details_evaluation(conversation_id) → analytics_conversation_details(conversation_id)
- analytics_conversation_details_survey(user_id) → users(id)
- analytics_conversation_details_survey(queue_id) → routing_queue(id)
- analytics_conversation_details_survey(conversation_id) → analytics_conversation_details(conversation_id)
- analytics_conversation_details_resolution(user_id) → users(id)
- analytics_conversation_details_resolution(queue_id) → routing_queue(id)
- analytics_conversation_details_resolution(conversation_id) → analytics_conversation_details(conversation_id)
- analytics_conversation_details_participant_session_callback_number(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_callback_number(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_callback_number(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_bcc(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_bcc(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_bcc(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_cc(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_cc(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_cc(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_destination_address(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_destination_address(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_destination_address(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_eligible_agent_count(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_eligible_agent_count(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_eligible_agent_count(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_requested_routing(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_requested_routing(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_requested_routing(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_waiting_interaction_counts(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_waiting_interaction_counts(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_waiting_interaction_counts(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_proposed_agent(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_proposed_agent(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_proposed_agent(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_agent_group(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_agent_group(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_agent_group(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_media_endpoint_stats(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_media_endpoint_stats(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_media_endpoint_stats(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_flow_outcome(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_flow_outcome(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_flow_outcome(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_metric(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_metric(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_metric(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session_segment(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_segment(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_segment(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- analytics_conversation_details_participant_session(assigner_id) → users(id)
- analytics_conversation_details_participant_session(campaign_id) → campaign(id)
- analytics_conversation_details_participant_session(script_id) → script(id)
- analytics_conversation_details_participant_session(contact_list_id) → contact_list(id)
- analytics_conversation_details_participant_session(participant_id) → analytics_conversation_details_participant(participant_id)
- analytics_conversation_details_participant_session(conversation_id) → analytics_conversation_details_participant(conversation_id)
- analytics_conversation_details_participant_attribute(participant_id) → analytics_conversation_details_participant(participant_id)
- analytics_conversation_details_participant_attribute(conversation_id) → analytics_conversation_details_participant(conversation_id)
- analytics_conversation_details_participant(participant_id) → users(id)
- analytics_conversation_details_participant(user_id) → users(id)
- analytics_conversation_details_participant(conversation_id) → analytics_conversation_details(conversation_id)
- analytics_conversation_details_participant_session_skill_id(session_id) → analytics_conversation_details_participant_session(session_id)
- analytics_conversation_details_participant_session_skill_id(participant_id) → analytics_conversation_details_participant_session(participant_id)
- analytics_conversation_details_participant_session_skill_id(conversation_id) → analytics_conversation_details_participant_session(conversation_id)
- historical_adherence_exception_info(start_date) → historical_adherence(start_date)
- historical_adherence_exception_info(end_date) → historical_adherence(end_date)
- historical_adherence_exception_info(management_unit_id) → historical_adherence(management_unit_id)
- historical_adherence_exception_info(user_id) → historical_adherence(user_id)
- historical_adherence_day_metrics(management_unit_id) → historical_adherence(management_unit_id)
- historical_adherence_day_metrics(user_id) → historical_adherence(user_id)
- historical_adherence_actual(start_date) → historical_adherence(start_date)
- historical_adherence_actual(end_date) → historical_adherence(end_date)
- historical_adherence_actual(management_unit_id) → historical_adherence(management_unit_id)
- historical_adherence_actual(user_id) → historical_adherence(user_id)
- historical_adherence(user_id) → users(id)
- historical_adherence(management_unit_id) → management_unit(id)
- analytic_user_detail_primary_presence(user_id) → analytic_user_detail(user_id)
- analytic_user_detail_routing_status(user_id) → analytic_user_detail(user_id)
- analytic_user_detail(user_id) → users(id)
- speech_and_text_analytics_transcript(conversation_id) → speech_and_text_analytics(conversation_id)
- speech_and_text_analytics_transcript(communication_id) → speech_and_text_analytics(communication_id)
- speech_and_text_analytics_participant(conversation_id) → speech_and_text_analytics(conversation_id)
- speech_and_text_analytics_participant(communication_id) → speech_and_text_analytics(communication_id)