Genesys
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 | PKFK |
evaluation_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
agent_activity_evaluator_list_contact_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agent_activity_evaluator_list_index | Unknown | PKFK |
agent_activity_fivetran_id | Unknown | PKFK |
address | Unknown | |
media_type | Unknown | |
type | Unknown |
agent_activity_evaluator_list
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agent_activity_fivetran_id | Unknown | PKFK |
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 | PKFK |
conversation_survey_answer_question_group_score_index | Unknown | PKFK |
conversation_survey_id | Unknown | PKFK |
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 | PKFK |
conversation_survey_id | Unknown | PKFK |
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 | PKFK |
intraday_planning_date | Unknown | PKFK |
intraday_planning_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
messaging_campaign_id | Unknown | PKFK |
messaging_campaign_contact_sort
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
messaging_campaign_id | Unknown | PKFK |
direction | Unknown | |
field_name | Unknown | |
numeric | Unknown |
messaging_campaign_contact_list_filter
| Column | Type | Keys |
|---|---|---|
contact_list_filter_id | Unknown | PKFK |
messaging_campaign_id | Unknown | PKFK |
messaging_campaign_rule_set
| Column | Type | Keys |
|---|---|---|
messaging_campaign_id | Unknown | PKFK |
rule_set_id | Unknown | PKFK |
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 | PKFK |
index | Unknown | PKFK |
routing_queue_id | Unknown | PKFK |
routing_queue_conditional_group_routing_rule
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
routing_queue_id | Unknown | PKFK |
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 | PKFK |
name | Unknown | |
self_uri | Unknown |
routing_queue_bulls_eye_ring_member_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
routing_queue_id | Unknown | PKFK |
member_count | Unknown | |
name | Unknown | |
self_uri | Unknown | |
type | Unknown |
routing_queue_member_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
routing_queue_id | Unknown | PKFK |
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 | PKFK |
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 |
|---|---|---|
participant_id | Unknown | PK |
conversation_id | Unknown | |
attributes_** |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
user_queue_id | Unknown | PKFK |
user_queue_conditional_group_routing_rule
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
user_queue_id | Unknown | PKFK |
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 | PKFK |
user_queue_id | Unknown | PKFK |
name | Unknown | |
self_uri | Unknown |
user_queue_bulls_eye_ring_member_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
user_queue_id | Unknown | PKFK |
member_count | Unknown | |
name | Unknown | |
self_uri | Unknown | |
type | Unknown |
user_queue_member_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
user_queue_id | Unknown | PKFK |
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 | PKFK |
user_queue_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
image_uri | Unknown | |
resolution | Unknown |
users_certification
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
certifications | Unknown |
users_biography_interest
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
interests | Unknown |
users_biography_hobby
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
hobbies | Unknown |
users_biography_education
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
date_end | Unknown | |
date_start | Unknown | |
field_of_study | Unknown | |
notes | Unknown | |
school | Unknown |
users_geo_location_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
users_geo_location_id | Unknown | PKFK |
users_geo_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
users_profile_skill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
profile_skill | Unknown |
users_location
| Column | Type | Keys |
|---|---|---|
location_definition_id | Unknown | PKFK |
user_id | Unknown | PKFK |
coordinates | Json | |
floorplan_id | Unknown | |
id | Unknown | |
notes | Unknown |
users_skill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
name | Unknown | |
proficiency | Unknown | |
self_uri | Unknown | |
skill_uri | Unknown | |
state | Unknown |
users_language
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
language_uri | Unknown | |
name | Unknown | |
proficiency | Unknown | |
self_uri | Unknown | |
state | Unknown |
users_authorization_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
name | Unknown |
users_authorization_unused_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
name | Unknown |
users_authorization_permission
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
permission | Unknown |
users_authorization_permission_policy
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
user_id | Unknown | PKFK |
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 | PKFK |
dnc_id | Unknown | PKFK |
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 | PKFK |
rule_set_id | Unknown | PKFK |
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 | PKFK |
contact_list_filter_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
conversation_callback_participants_id | Unknown | PKFK |
tag_name | Unknown |
conversation_callback_participants_callback_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_callback_id | Unknown | PKFK |
conversation_callback_participants_id | Unknown | PKFK |
callback_number | Unknown |
conversation_callback_participants_media_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_callback_id | Unknown | PKFK |
conversation_callback_participants_id | Unknown | PKFK |
media_role | Unknown |
conversation_callback_participants
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conversation_callback_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
schedule_id | Unknown | PKFK |
schedule_week_date | Unknown | PKFK |
count | Unknown | |
severity | Unknown |
schedule_management_unit_agent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_business_unit_id | Unknown | PKFK |
schedule_id | Unknown | PKFK |
schedule_management_unit_index | Unknown | PKFK |
schedule_week_date | Unknown | PKFK |
self_uri | Unknown |
schedule_management_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schedule_business_unit_id | Unknown | PKFK |
schedule_id | Unknown | PKFK |
schedule_week_date | Unknown | PKFK |
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 | PKFK |
conversation_survey_answer_question_group_score_index | Unknown | PKFK |
conversation_survey_id | Unknown | PKFK |
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 | PKFK |
conversation_survey_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
evaluation_form_question_group_index | Unknown | PKFK |
evaluation_form_question_group_question_answer_option_index | Unknown | PKFK |
evaluation_form_question_group_question_index | Unknown | PKFK |
operator | Unknown | |
topic_ids | Json |
evaluation_form_question_group_question_answer_option
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
evaluation_form_id | Unknown | PKFK |
evaluation_form_question_group_index | Unknown | PKFK |
evaluation_form_question_group_question_index | Unknown | PKFK |
id | Unknown | |
text | Unknown | |
value | Unknown |
evaluation_form_question_group_question
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
evaluation_form_id | Unknown | PKFK |
evaluation_form_question_group_index | Unknown | PKFK |
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 | PKFK |
campaign_rule_id | Unknown | PKFK |
campaign_rule_entity_sequence
| Column | Type | Keys |
|---|---|---|
campaign_rule_id | Unknown | PKFK |
id | Unknown | PKFK |
campaign_rule_condition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_rule_id | Unknown | PKFK |
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 | PKFK |
campaign_rule_action_id | Unknown | PKFK |
campaign_rule_id | Unknown | PKFK |
campaign_rule_action_sequence
| Column | Type | Keys |
|---|---|---|
campaign_rule_action_id | Unknown | PKFK |
campaign_rule_id | Unknown | PKFK |
id | Unknown | PKFK |
campaign_rule_action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_rule_id | Unknown | PKFK |
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 | PKFK |
date_created | Unknown | |
type | Unknown | |
value | Unknown |
external_contact_line_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
external_contact_id | Unknown | PKFK |
user_id | Unknown | FK |
external_contact_facebook_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
external_contact_id | Unknown | PKFK |
scoped_id | Unknown |
external_contact_external_data_source
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
external_contact_id | Unknown | PKFK |
platform | Unknown | |
url | Unknown |
external_contact_external_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
external_contact_id | Unknown | PKFK |
external_source_active | Unknown | |
external_source_id | Unknown | |
external_source_link_configuration_uri_template | Unknown | |
external_source_name | Unknown | |
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 | |
custom_field_** |
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 | PKFK |
division_id | Unknown | PKFK |
analytics_conversation_aggregate_query_details_knowledge_base_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_id | Unknown | PKFK |
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 | PKFK |
participant_id | Unknown | PKFK |
session_id | Unknown | PKFK |
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 | PKFK |
participant_id | Unknown | PKFK |
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 | PKFK |
participant_id | Unknown | PKFK |
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 | PKFK |
participant_id | Unknown | PKFK |
session_id | Unknown | PKFK |
object_type | Unknown |
messaging_campaign_progress
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
messaging_campaign_id | Unknown | PKFK |
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 | PKFK |
exchange | Unknown | |
symbol | Unknown |
organization_external_data_source
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
platform | Unknown | |
url | 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 | |
custom_field_** |
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 | PKFK |
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 | PKFK |
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 | PKFK |
end_date | Unknown | PKFK |
start_date | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
ruleset_id | Unknown | PKFK |
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 | PKFK |
ruleset_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
sequence_id | Unknown | PKFK |
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 | PKFK |
survey_form_question_group_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
image_uri | Unknown | |
resolution | Unknown |
group_address
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
group_id | Unknown | PKFK |
address | Unknown | |
display | Unknown | |
extension | Unknown | |
media_type | Unknown | |
type | Unknown |
group_owner
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
task_management_workitem_workbin_id | Unknown | PKFK |
id | Unknown |
task_management_workitem_score_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
task_management_workitem_id | Unknown | PKFK |
task_management_workitem_workbin_id | Unknown | PKFK |
agent | Unknown | |
score | 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 | |
custom_** |
historical_shrinkage_for_activity_code
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
end_date | Unknown | PKFK |
historical_shrinkage_activity_category_index | Unknown | PKFK |
management_unit_id | Unknown | PKFK |
start_date | Unknown | PKFK |
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 | PKFK |
management_unit_id | Unknown | PKFK |
start_date | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
division_id | Unknown | PKFK |
analytics_conversation_details_knowledge_base_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_id | Unknown | PKFK |
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 | PKFK |
participant_id | Unknown | PKFK |
session_id | Unknown | PKFK |
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 | PKFK |
participant_id | Unknown | PKFK |
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
| Column | Type | Keys |
|---|---|---|
conversation_id | Unknown | PKFK |
participant_id | Unknown | PKFK |
user_id | Unknown | FK |
external_contact_id | Unknown | |
external_organization_id | Unknown | |
flagged_reason | Unknown | |
participant_name | Unknown | |
purpose | Unknown | |
team_id | Unknown | |
attributes_** |
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 | PKFK |
participant_id | Unknown | PKFK |
session_id | Unknown | PKFK |
object_type | Unknown |
historical_adherence_exception_info
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
end_date | Unknown | PKFK |
management_unit_id | Unknown | PKFK |
start_date | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
management_unit_id | Unknown | PKFK |
start_date | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
adherence_percentage | Unknown | |
conformance_percentage | Unknown | |
impact | Unknown |
analytic_user_detail_primary_presence
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
user_id | Unknown | PKFK |
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 | PKFK |
end_time | Unknown | |
routing_status | Unknown | |
start_time | Unknown |
analytic_user_detail
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PKFK |
speech_and_text_analytics_transcript
| Column | Type | Keys |
|---|---|---|
transcript_id | Unknown | PK |
communication_id | Unknown | PKFK |
conversation_id | Unknown | PKFK |
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 | PKFK |
conversation_id | Unknown | PKFK |
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 |