Zoom
Explore the interactive ERD
Table & Field Reference
channel
| Column | Type | Keys |
|---|---|---|
id | String | PK |
channel_settings_allow_to_add_external_users | Long | |
channel_settings_new_members_can_see_previous_messages_files | Boolean | |
channel_settings_posting_permissions | Long | |
jid | String | |
name | String | |
type | String |
meeting_report_custom_key
| Column | Type | Keys |
|---|---|---|
key | String | PK |
meeting_report_uuid | String | PKFK |
value | String |
meeting_report_tracking
| Column | Type | Keys |
|---|---|---|
field | String | PK |
meeting_report_uuid | String | PKFK |
value | String |
meeting_report
| Column | Type | Keys |
|---|---|---|
uuid | String | PKFK |
dept | String | |
duration | Long | |
end_time | Instant | |
meeting_id | Long | |
participants_count | Long | |
start_time | Instant | |
topic | String | |
total_minutes | Long | |
type | String | |
user_email | String | |
user_name | String |
meeting
| Column | Type | Keys |
|---|---|---|
uuid | String | PK |
host_id | String | FK |
created_at | Instant | |
duration | Long | |
id | Long | |
join_url | String | |
start_time | Instant | |
timezone | String | |
topic | String | |
type | Long |
event_survey_report_question_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
event_survey_report_fivetran_id | Unknown | PKFK |
answer | Unknown | |
question | Unknown |
event_survey_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
event_id | Unknown | PKFK |
email | Unknown | |
session_id | Unknown | |
session_name | Unknown |
account_parent_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_team_id | Unknown | PKFK |
name | Unknown |
account_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
leaf | Unknown | |
member_size | Unknown | |
name | Unknown | |
supervisor_size | Unknown | |
type | Unknown |
event_attendance_report_ticket_question
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_attendance_fivetran_id | Unknown | PKFK |
event_attendance_report_ticket_index | Unknown | PKFK |
event_id | Unknown | PKFK |
answer | Unknown | |
title | Unknown |
event_attendance_report_ticket
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_attendance_fivetran_id | Unknown | PKFK |
event_id | Unknown | PKFK |
ticket_id | Unknown | |
ticket_type_id | Unknown | |
ticket_type_name | Unknown |
event_attendance_report_session_attendance
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_attendance_report_fivetran_id | Unknown | PKFK |
event_id | Unknown | PKFK |
chat_messages_sent | Unknown | |
duration_spent_in_session | Unknown | |
live_streaming_view | Unknown | |
live_streaming_view_duration | Unknown | |
material_download | Unknown | |
recording_view | Unknown | |
recording_view_duration | Unknown | |
session_attendance | Unknown | |
session_id | Unknown | |
session_name | Unknown |
event_attendance_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
event_id | Unknown | PKFK |
attendance_type | Json | |
connection_made | Unknown | |
display_name | Unknown | |
email | Unknown | |
event_attendance | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
lobby_attendance | Unknown | |
lobby_chat_sent | Unknown | |
marketing_consent_prechecked | Unknown | |
number_of_tickets | Unknown | |
opt_in_marketing | Unknown | |
personal_chats | Unknown | |
profile_created | Unknown | |
role | Unknown | |
survey_taken | Unknown | |
total_sessions_joined | Unknown |
user_meeting_report
| Column | Type | Keys |
|---|---|---|
uuid | Unknown | PK |
user_id | String | PKFK |
host_id | Unknown | FK |
duration | Unknown | |
end_time | Unknown | |
has_chat | Unknown | |
host_email | Unknown | |
host_organization | Unknown | |
id | Unknown | |
join_time | Unknown | |
join_waiting_room_time | Unknown | |
leave_time | Unknown | |
meeting_encryption_status | Unknown | |
participants_count | Unknown | |
participants_count_my_account | Unknown | |
schedule_time | Unknown | |
session_key | Unknown | |
source | Unknown | |
start_time | Unknown | |
topic | Unknown | |
total_minutes | Unknown | |
type | Unknown |
webinar_participant
| Column | Type | Keys |
|---|---|---|
user_id | String | PKFK |
webinar_uuid | String | PKFK |
participant_user_id | String | FK |
customer_key | String | |
duration | Long | |
failover | Boolean | |
join_time | Instant | |
leave_time | Instant | |
name | String | |
registrant_id | String | |
status | String | |
user_email | String |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
access_level | Unknown | |
attendance_type | Unknown | |
blocked_countries | Json | |
calendar | Json | |
categories | Json | |
contact_email | Unknown | |
contact_name | Unknown | |
description | Unknown | |
end_time | Instant | |
event_status_type | Unknown | |
event_type | Unknown | |
event_url | Unknown | |
hub_id | Unknown | |
lobby_end_time | Instant | |
lobby_start_time | Instant | |
meeting_type | Unknown | |
name | Unknown | |
physical_location | Unknown | |
recurrence_duration | Unknown | |
recurrence_end_date_time | Unknown | |
recurrence_end_times | Unknown | |
recurrence_monthly_days | Unknown | |
recurrence_monthly_week | Unknown | |
recurrence_monthly_week_day | Unknown | |
recurrence_repeat_interval | Unknown | |
recurrence_type | Unknown | |
recurrence_weekly_days | Unknown | |
role_type | Unknown | |
start_time | Instant | |
status | Unknown | |
tagline | Unknown | |
tags | Json | |
timezone | Unknown |
webinar_question_and_answer_question_detail
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
webinar_question_and_answer_id | Long | FK |
webinar_question_and_answer_question_index | Unknown | FK |
webinar_uuid | String | FK |
answer | Unknown | |
question | Unknown |
webinar_question_and_answer_question
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
webinar_question_and_answer_id | Long | PKFK |
webinar_uuid | String | PKFK |
email | Unknown | |
name | Unknown |
webinar_question_and_answer
| Column | Type | Keys |
|---|---|---|
id | Long | PK |
webinar_uuid | String | PKFK |
start_time | Instant | |
uuid | String |
webinar_absentee
| Column | Type | Keys |
|---|---|---|
registrant_id | String | PKFK |
webinar_uuid | String | PKFK |
email | Unknown | FK |
phone_sms_mms_charge_usage_report
| Column | Type | Keys |
|---|---|---|
message_id | Unknown | PK |
session_id | Unknown | PK |
billing_number | Unknown | |
cost_center | Unknown | |
currency | Unknown | |
department | Unknown | |
from_display_name | Unknown | |
from_extension_number | Unknown | |
from_number | Unknown | |
message_type | Unknown | |
rate | Unknown | |
sent_time | Unknown | |
to_display_name | Unknown | |
to_extension_number | Unknown | |
to_number | Unknown | |
total_charge | Unknown |
webinar_panelist
| Column | Type | Keys |
|---|---|---|
user_id | String | PKFK |
webinar_uuid | String | PKFK |
email | String | |
join_url | String | |
name | String | |
name_tag_description | String | |
name_tag_id | String | |
name_tag_name | String | |
name_tag_pronouns | String | |
virtual_background_id | String |
event_registration_ticket_question
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
event_registration_fivetran_id | Unknown | PKFK |
event_registration_index | Unknown | PKFK |
answer | Unknown | |
title | Unknown |
event_registration_ticket
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
event_registration_fivetran_id | Unknown | PKFK |
authentication_method | Unknown | |
external_ticket_id | Unknown | |
ticket_id | Unknown | |
ticket_type_id | Unknown | |
ticket_type_name | Unknown |
event_registration
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
event_id | Unknown | PKFK |
attendance_type | Json | |
display_name | Unknown | |
email | Unknown | |
event_attendance | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
marketing_consent_prechecked | Unknown | |
opt_in_marketing | Unknown | |
register_date | Unknown | |
registration_method | Unknown | |
registration_source | Unknown |
disposition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
modified_by | Unknown | FK |
disposition_description | Unknown | |
disposition_name | Unknown | |
disposition_type | Unknown | |
last_modified_time | Instant | |
queue_count | Unknown | |
status | Unknown |
webinar_poll_question
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
webinar_poll_id | String | PKFK |
webinar_uuid | String | PKFK |
answer_max_character | Long | |
answer_min_character | Long | |
answer_required | Boolean | |
answers | Json | |
case_sensitive | Boolean | |
name | String | |
prompts | Json | |
rating_max_label | String | |
rating_max_value | Long | |
rating_min_label | String | |
rating_min_value | Long | |
right_answers | Json | |
show_as_dropdown | Boolean | |
type | String |
webinar_poll
| Column | Type | Keys |
|---|---|---|
id | String | PK |
webinar_uuid | String | PKFK |
anonymous | Boolean | |
poll_type | Long | |
status | String | |
title | String |
webinar_registrant_custom_question
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | String | PKFK |
webinar_uuid | String | PKFK |
title | String | |
value | String |
webinar_registrant
| Column | Type | Keys |
|---|---|---|
user_id | String | PKFK |
webinar_uuid | String | PKFK |
email | Unknown | FK |
address | String | |
city | String | |
comments | String | |
country | String | |
create_time | Instant | |
industry | String | |
job_title | String | |
join_url | String | |
no_of_employees | String | |
org | String | |
phone | String | |
purchasing_time_frame | String | |
role_in_purchase_process | String | |
state | String | |
zip | String |
phone_call_path
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
phone_call_history_id | Unknown | PKFK |
callee_country_code | Unknown | |
callee_country_iso_code | Unknown | |
callee_device_type | Unknown | |
callee_did_number | Unknown | |
callee_email | Unknown | |
callee_ext_id | Unknown | |
callee_ext_number | Unknown | |
callee_ext_type | Unknown | |
callee_name | Unknown | |
callee_number_type | Unknown | |
caller_country_code | Unknown | |
caller_country_iso_code | Unknown | |
caller_device_type | Unknown | |
caller_did_number | Unknown | |
caller_email | Unknown | |
caller_ext_number | Unknown | |
caller_ext_type | Unknown | |
caller_name | Unknown | |
caller_number_type | Unknown | |
client_code | Unknown | |
cost_center | Unknown | |
device_private_ip | Unknown | |
device_public_ip | Unknown | |
event | Unknown | |
hold_time | Unknown | |
is_node | Unknown | |
node | Unknown | |
operator_ext_id | Unknown | |
operator_ext_number | Unknown | |
operator_ext_type | Unknown | |
operator_name | Unknown | |
press_key | Unknown | |
recording_id | Unknown | |
recording_type | Unknown | |
result | Unknown | |
result_reason | Unknown | |
segment | Unknown | |
voicemail_id | Unknown | |
wait_time | Unknown |
webinar_tracking_source
| Column | Type | Keys |
|---|---|---|
id | String | PK |
webinar_uuid | String | PKFK |
registration_count | Long | |
source_name | String | |
tracking_url | String | |
visitor_count | Long |
phone_call_history
| Column | Type | Keys |
|---|---|---|
call_id | Unknown | PK |
id | Unknown | PK |
group_id | Unknown | FK |
answer_time | Unknown | |
call_result | Unknown | |
call_type | Unknown | |
callee_country_code | Unknown | |
callee_country_iso_code | Unknown | |
callee_device_type | Unknown | |
callee_did_number | Unknown | |
callee_email | Unknown | |
callee_ext_id | Unknown | |
callee_ext_number | Unknown | |
callee_ext_type | Unknown | |
callee_name | Unknown | |
callee_number_type | Unknown | |
caller_country_code | Unknown | |
caller_country_iso_code | Unknown | |
caller_device_type | Unknown | |
caller_did_number | Unknown | |
caller_email | Unknown | |
caller_ext_id | Unknown | |
caller_ext_number | Unknown | |
caller_ext_type | Unknown | |
caller_name | Unknown | |
caller_number_type | Unknown | |
client_code | Unknown | |
connect_type | Unknown | |
cost_center | Unknown | |
department | Unknown | |
direction | Unknown | |
duration | Unknown | |
end_time | Instant | |
international | Unknown | |
recording_status | Unknown | |
sbc_id | Unknown | |
sbc_name | Unknown | |
sip_group_id | Unknown | |
sip_group_name | Unknown | |
site_id | Unknown | |
site_name | Unknown | |
spam | Unknown | |
start_time | Instant |
webinar
| Column | Type | Keys |
|---|---|---|
uuid | String | PK |
host_id | String | FK |
created_at | Instant | |
duration | Long | |
id | Long | |
join_url | String | |
start_time | Instant | |
timezone | String | |
topic | String | |
type | Long |
user_group
| Column | Type | Keys |
|---|---|---|
group_id | String | PK |
user_id | String | PKFK |
user_im_group
| Column | Type | Keys |
|---|---|---|
im_group_id | String | PK |
user_id | String | PKFK |
user_custom_attribute
| Column | Type | Keys |
|---|---|---|
key | String | PK |
user_id | String | PKFK |
name | String | |
value | String |
users
| Column | Type | Keys |
|---|---|---|
id | String | PK |
created_at | Instant | |
dept | String | |
email | String | |
employee_unique_id | String | |
first_name | String | |
host_key | String | |
languages | String | |
last_client_version | String | |
last_login_time | Instant | |
last_name | String | |
phone_number | String | |
plan_united_type | String | |
pmi | Long | |
role_id | String | |
status | String | |
timezone | String | |
type | Long | |
verified | Long |
webinar_report_custom_key
| Column | Type | Keys |
|---|---|---|
key | String | PK |
webinar_report_fivetran_id | Unknown | PKFK |
value | String |
webinar_report_tracking
| Column | Type | Keys |
|---|---|---|
field | String | PK |
webinar_report_fivetran_id | Unknown | PKFK |
value | String |
webinar_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
uuid | String | FK |
dept | String | |
duration | Long | |
end_time | Instant | |
id | Unknown | |
participants_count | Long | |
start_time | Instant | |
topic | String | |
total_minutes | Long | |
type | String | |
user_email | String | |
user_name | String |
phone_call_charge_usage_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
billing_number | Unknown | |
call_id | Unknown | |
call_log_id | Unknown | |
call_type | Unknown | |
callee_billing_number | Unknown | |
callee_number | Unknown | |
caller_billing_number | Unknown | |
caller_number | Unknown | |
calling_party_name | Unknown | |
charge_mode | Unknown | |
cost_center | Unknown | |
currency | Unknown | |
department | Unknown | |
duration | Unknown | |
employee_id | Unknown | |
end_time | Instant | |
forward_number_billing | Unknown | |
rate | Unknown | |
service_type | Unknown | |
total_charge | Unknown |
meeting_participant
| Column | Type | Keys |
|---|---|---|
user_id | String | PKFK |
user_meeting_report_uuid | Unknown | PKFK |
participant_user_id | String | FK |
bo_mtg_id | String | |
customer_key | String | |
duration | Long | |
failover | Boolean | |
join_time | Instant | |
leave_time | Instant | |
name | String | |
registrant_id | String | |
status | String | |
user_email | String |
room
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_type | Unknown | |
calender_name | Unknown | |
camera | Unknown | |
device_ip | Unknown | |
email | Unknown | |
health | Unknown | |
issues | Json | |
last_start_time | Unknown | |
location | Unknown | |
location_id | Unknown | |
microphone | Unknown | |
room_name | Unknown | |
speaker | Unknown | |
status | Unknown |
voice_historical_detail_report_channel
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
channel | Unknown | |
channel_source | Unknown |
voice_historical_detail_report_flow
| Column | Type | Keys |
|---|---|---|
flow_id | Unknown | PK |
engagement_id | Unknown | PKFK |
flow_name | Unknown | |
flow_version | Unknown |
voice_historical_detail_report_queue
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PKFK |
engagement_id | Unknown | PKFK |
queue_name | Unknown |
voice_historical_detail_report_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
display_name | Unknown | |
user_id | Unknown |
voice_historical_detail_report_required_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
voice_historical_detail_report_optional_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
voice_historical_detail_report_agent_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
voice_historical_detail_report
| Column | Type | Keys |
|---|---|---|
engagement_id | Unknown | PK |
disposition_id | Unknown | FK |
agent_first_message_speed | Unknown | |
callback_pending_duration | Unknown | |
callback_waiting_duration | Unknown | |
channel | Unknown | |
consumer_id | Unknown | |
consumer_name | Unknown | |
consumer_number | Unknown | |
dialed_numbers | Json | |
direction | Unknown | |
disposition_name | Unknown | |
handling_duration | Unknown | |
hold_duration | Unknown | |
ivr_duration | Unknown | |
last_widget_name | Unknown | |
queue_wait_type | Unknown | |
results | Unknown | |
ring_duration | Unknown | |
start_time | Instant | |
talking_duration | Unknown | |
total_duration | Unknown | |
total_flow_duration | Unknown | |
waiting_duration | Unknown | |
wrap_up_duration | Unknown |
voice_historical_queue_report
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PK |
queue_name | Unknown | |
total_completed | Unknown | |
total_inbound | Unknown | |
total_transferred_in | Unknown | |
total_transferred_out | Unknown | |
voice_average_outbound_answer_duration | Unknown | |
voice_average_outbound_hold_duration | Unknown | |
voice_average_outbound_wrap_up_duration | Unknown | |
voice_end_time_interval | Unknown | |
voice_hangup_outbound | Unknown | |
voice_hold_abandoned | Unknown | |
voice_inbound_average_talking_duration | Unknown | |
voice_inbound_average_waiting_duration | Unknown | |
voice_inbound_average_wrap_up_duration | Unknown | |
voice_inbound_longest_talking_duration | Unknown | |
voice_inbound_longest_waiting_duration | Unknown | |
voice_inbound_longest_wrap_up_duration | Unknown | |
voice_inbound_shortest_talking_duration | Unknown | |
voice_inbound_shortest_waiting_duration | Unknown | |
voice_inbound_shortest_wrap_up_duration | Unknown | |
voice_long_abandoned | Unknown | |
voice_long_outbound | Unknown | |
voice_service_level | Unknown | |
voice_short_abandoned | Unknown | |
voice_short_outbound | Unknown | |
voice_start_time_interval | Unknown | |
voice_total_abandoned_duration | Unknown | |
voice_total_answer_duration | Unknown | |
voice_total_answered_users | Unknown | |
voice_total_hold_duration | Unknown | |
voice_total_missed | Unknown | |
voice_total_outbound | Unknown | |
voice_total_outbound_answer_duration | Unknown | |
voice_total_outbound_hold_duration | Unknown | |
voice_total_outbound_wrap_up_duration | Unknown | |
voice_total_overflowed | Unknown | |
voice_total_queue_wait_duration | Unknown | |
voice_total_wrap_up_duration | Unknown | |
voice_upgraded_to_video_call | Unknown |
phone_sms_session_participant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
phone_sms_session_id | Unknown | PKFK |
display_name | Unknown | |
extension_deleted_time | Unknown | |
extension_status | Unknown | |
is_session_owner | Unknown | |
owner_id | Unknown | |
owner_type | Unknown | |
phone_number | Unknown |
phone_sms_session
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_access_time | Unknown | |
session_type | Unknown |
messaging_historical_queue_report
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PK |
messaging_average_agent_first_message_speed | Unknown | |
messaging_average_outbound_answer_duration | Unknown | |
messaging_average_outbound_wrap_up_duration | Unknown | |
messaging_average_sent | Unknown | |
messaging_channel_sources | Json | |
messaging_end_time_interval | Unknown | |
messaging_inbound_average_messaging_duration | Unknown | |
messaging_inbound_average_waiting_duration | Unknown | |
messaging_inbound_longest_messaging_duration | Unknown | |
messaging_inbound_longest_waiting_duration | Unknown | |
messaging_inbound_shortest_messaging_duration | Unknown | |
messaging_inbound_shortest_waiting_duration | Unknown | |
messaging_longest_agent_first_message_speed | Unknown | |
messaging_service_level | Unknown | |
messaging_shortest_agent_first_message_speed | Unknown | |
messaging_start_time_interval | Unknown | |
messaging_total_abandoned | Unknown | |
messaging_total_auto_closed | Unknown | |
messaging_total_outbound | Unknown | |
messaging_total_outbound_answer_duration | Unknown | |
messaging_total_outbound_wrap_up_duration | Unknown | |
messaging_total_overflowed | Unknown | |
messaging_total_released | Unknown | |
messaging_total_sent | Unknown | |
messaging_upgraded_to_video_call | Unknown | |
messaging_upgraded_to_voice_call | Unknown | |
queue_name | Unknown | |
total_completed | Unknown | |
total_inbound | Unknown | |
total_transferred_in | Unknown | |
total_transferred_out | Unknown |
video_historical_queue_report
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PK |
queue_name | Unknown | |
total_completed | Unknown | |
total_inbound | Unknown | |
total_transferred_in | Unknown | |
total_transferred_out | Unknown | |
video_average_talking_duration | Unknown | |
video_average_waiting_duration | Unknown | |
video_average_wrap_up_duration | Unknown | |
video_end_time_interval | Unknown | |
video_hold_abandoned | Unknown | |
video_long_abandoned | Unknown | |
video_longest_talking_duration | Unknown | |
video_longest_waiting_duration | Unknown | |
video_longest_wrap_up_duration | Unknown | |
video_service_level | Unknown | |
video_short_abandoned | Unknown | |
video_shortest_talking_duration | Unknown | |
video_shortest_waiting_duration | Unknown | |
video_shortest_wrap_up_duration | Unknown | |
video_start_time_interval | Unknown | |
video_total_missed | Unknown | |
video_total_overflowed | Unknown |
phone_call_log
| Column | Type | Keys |
|---|---|---|
call_id | Unknown | PK |
callee_codec | Unknown | |
callee_device_private_ip | Unknown | |
callee_device_public_ip | Unknown | |
callee_device_type | Unknown | |
callee_extension_number | Unknown | |
callee_headset | Unknown | |
callee_isp | Unknown | |
callee_microphone | Unknown | |
callee_phone_number | Unknown | |
callee_site_id | Unknown | |
caller_codec | Unknown | |
caller_device_private_ip | Unknown | |
caller_device_public_ip | Unknown | |
caller_device_type | Unknown | |
caller_extension_number | Unknown | |
caller_headset | Unknown | |
caller_isp | Unknown | |
caller_microphone | Unknown | |
caller_phone_number | Unknown | |
caller_site_id | Unknown | |
date_time | Unknown | |
direction | Unknown | |
duration | Unknown | |
mos | Unknown |
agent_status_history
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
user_id | Unknown | FK |
display_name | Unknown | |
duration | Unknown | |
end_time | Instant | |
occupied_engagements | Json | |
start_time | Instant | |
status_id | Unknown | |
status_name | Unknown | |
sub_status_id | Unknown | |
sub_status_name | Unknown |
deal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_id | Unknown | FK |
account_name | Unknown | |
account_type | Unknown | |
amount | Unknown | |
close_date | Unknown | |
create_time | Instant | |
currency_type | Unknown | |
description | Unknown | |
is_closed | Unknown | |
is_private | Unknown | |
last_activity_time | Instant | |
name | Unknown | |
number_of_conversations | Unknown | |
owner_email | Unknown | |
owner_name | Unknown | |
stage | Unknown | |
time_in_stage | Unknown |
messaging_agent_leg_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
cc_queue_id | Unknown | FK |
disposition_id | Unknown | FK |
engagement_id | Unknown | FK |
agent_end_time | Unknown | |
agent_first_response_duration | Unknown | |
agent_offered | Unknown | |
agent_start_time | Unknown | |
channel | Unknown | |
channel_source | Unknown | |
conference_count | Unknown | |
conference_duration | Unknown | |
conversation_duration | Unknown | |
direct_transfer | Unknown | |
display_name | Unknown | |
disposition_name | Unknown | |
handle_duration | Unknown | |
handled_engagement | Unknown | |
hold_count | Unknown | |
hold_duration | Unknown | |
queue_name | Unknown | |
refused_engagement | Unknown | |
ring_duration | Unknown | |
user_email | Unknown | |
user_id | Unknown | |
warm_conference | Unknown | |
warm_conference_duration | Unknown | |
warm_transfer_completed | Unknown | |
warm_transfer_duration | Unknown | |
warm_transfer_initiated | Unknown | |
wrap_up_duration | Unknown |
agent_time_sheet
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
user_id | Unknown | FK |
average_video_call_talking_duration | Unknown | |
average_wrap_up_duration | Unknown | |
display_name | Unknown | |
end_time_interval | Unknown | |
inbound_average_voice_call_talking_duration | Unknown | |
not_ready_duration | Unknown | |
not_ready_percentage | Unknown | |
occupied_duration | Unknown | |
occupied_percentage | Unknown | |
offline_duration | Unknown | |
online_duration | Unknown | |
ready_duration | Unknown | |
ready_percentage | Unknown | |
start_time_interval | Unknown | |
total_inbound_voice_call | Unknown | |
total_inbound_voice_call_duration | Unknown | |
total_outbound_voice_call | Unknown | |
total_outbound_voice_call_duration | Unknown |
voice_agent_leg_report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
cc_queue_id | Unknown | FK |
disposition_id | Unknown | FK |
engagement_id | Unknown | FK |
agent_end_time | Unknown | |
agent_first_response_duration | Unknown | |
agent_offered | Unknown | |
agent_start_time | Unknown | |
channel | Unknown | |
channel_source | Unknown | |
conference_count | Unknown | |
conference_duration | Unknown | |
conversation_duration | Unknown | |
direct_transfer | Unknown | |
display_name | Unknown | |
disposition_name | Unknown | |
handle_duration | Unknown | |
handled_engagement | Unknown | |
hold_count | Unknown | |
hold_duration | Unknown | |
queue_name | Unknown | |
refused_engagement | Unknown | |
ring_duration | Unknown | |
user_email | Unknown | |
user_id | Unknown | |
warm_conference | Unknown | |
warm_conference_duration | Unknown | |
warm_transfer_completed | Unknown | |
warm_transfer_duration | Unknown | |
warm_transfer_initiated | Unknown | |
wrap_up_duration | Unknown |
conversation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deal_id | Unknown | FK |
host_id | Unknown | FK |
conversation_topic | Unknown | |
conversation_type | Unknown | |
duration | Unknown | |
duration_sec | Unknown | |
engagement_score | Unknown | |
engaging_questions_count | Unknown | |
filler_words_count | Unknown | |
iq_processed_time | Unknown | |
meeting_id | Unknown | |
meeting_start_time | Unknown | |
meeting_uuid | Unknown | |
next_steps_count | Unknown | |
processing_analysis | Unknown | |
sentiment_score | Unknown | |
topic | Unknown |
email_historical_queue_report
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PK |
email_end_time_interval | Unknown | |
email_inbound_average_agent_first_reply_duration | Unknown | |
email_inbound_average_agent_reply_duration | Unknown | |
email_inbound_average_inactive_duration | Unknown | |
email_inbound_average_messaging_duration | Unknown | |
email_inbound_average_waiting_duration | Unknown | |
email_inbound_longest_agent_first_reply_duration | Unknown | |
email_inbound_longest_agent_reply_duration | Unknown | |
email_inbound_longest_inactive_duration | Unknown | |
email_inbound_longest_messaging_duration | Unknown | |
email_inbound_longest_waiting_duration | Unknown | |
email_inbound_shortest_agent_first_reply_duration | Unknown | |
email_inbound_shortest_agent_reply_duration | Unknown | |
email_inbound_shortest_inactive_duration | Unknown | |
email_inbound_shortest_messaging_duration | Unknown | |
email_inbound_shortest_waiting_duration | Unknown | |
email_service_level | Unknown | |
email_start_time_interval | Unknown | |
email_total_auto_closed | Unknown | |
email_total_handled | Unknown | |
email_total_offered | Unknown | |
email_total_offers | Unknown | |
email_total_offers_acd | Unknown | |
email_total_offers_answered | Unknown | |
email_total_offers_declined | Unknown | |
email_total_offers_missed | Unknown | |
email_total_offers_non_acd | Unknown | |
email_total_overflowed | Unknown | |
email_total_released | Unknown | |
email_total_transferred_in_to_agent | Unknown | |
email_total_transferred_in_to_queue | Unknown | |
email_total_transferred_out_of_queue | Unknown | |
email_total_transferred_out_within_queue | Unknown | |
queue_name | Unknown | |
total_completed | Unknown | |
total_inbound | Unknown | |
total_transferred_in | Unknown | |
total_transferred_out | Unknown |
email_historical_detail_report_channel
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
channel | Unknown | |
channel_source | Unknown |
email_historical_detail_report_flow
| Column | Type | Keys |
|---|---|---|
flow_id | Unknown | PK |
engagement_id | Unknown | PKFK |
flow_name | Unknown | |
flow_version | Unknown |
email_historical_detail_report_queue
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PKFK |
engagement_id | Unknown | PKFK |
queue_name | Unknown |
email_historical_detail_report_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
display_name | Unknown | |
user_id | Unknown |
email_historical_detail_report_required_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
email_historical_detail_report_optional_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
email_historical_detail_report_agent_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
email_historical_detail_report
| Column | Type | Keys |
|---|---|---|
engagement_id | Unknown | PK |
disposition_id | Unknown | FK |
agent_first_message_speed | Unknown | |
callback_pending_duration | Unknown | |
callback_waiting_duration | Unknown | |
channel | Unknown | |
consumer_id | Unknown | |
consumer_name | Unknown | |
consumer_number | Unknown | |
dialed_numbers | Json | |
direction | Unknown | |
disposition_name | Unknown | |
handling_duration | Unknown | |
hold_duration | Unknown | |
ivr_duration | Unknown | |
last_widget_name | Unknown | |
queue_wait_type | Unknown | |
results | Unknown | |
ring_duration | Unknown | |
start_time | Instant | |
talking_duration | Unknown | |
total_duration | Unknown | |
total_flow_duration | Unknown | |
waiting_duration | Unknown | |
wrap_up_duration | Unknown |
video_historical_detail_report_channel
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
channel | Unknown | |
channel_source | Unknown |
video_historical_detail_report_flow
| Column | Type | Keys |
|---|---|---|
flow_id | Unknown | PK |
engagement_id | Unknown | PKFK |
flow_name | Unknown | |
flow_version | Unknown |
video_historical_detail_report_queue
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PKFK |
engagement_id | Unknown | PKFK |
queue_name | Unknown |
video_historical_detail_report_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
display_name | Unknown | |
user_id | Unknown |
video_historical_detail_report_required_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
video_historical_detail_report_optional_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
video_historical_detail_report_agent_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
video_historical_detail_report
| Column | Type | Keys |
|---|---|---|
engagement_id | Unknown | PK |
disposition_id | Unknown | FK |
agent_first_message_speed | Unknown | |
callback_pending_duration | Unknown | |
callback_waiting_duration | Unknown | |
channel | Unknown | |
consumer_id | Unknown | |
consumer_name | Unknown | |
consumer_number | Unknown | |
dialed_numbers | Json | |
direction | Unknown | |
disposition_name | Unknown | |
handling_duration | Unknown | |
hold_duration | Unknown | |
ivr_duration | Unknown | |
last_widget_name | Unknown | |
queue_wait_type | Unknown | |
results | Unknown | |
ring_duration | Unknown | |
start_time | Instant | |
talking_duration | Unknown | |
total_duration | Unknown | |
total_flow_duration | Unknown | |
waiting_duration | Unknown | |
wrap_up_duration | Unknown |
messaging_historical_detail_report_channel
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
channel | Unknown | |
channel_source | Unknown |
messaging_historical_detail_report_flow
| Column | Type | Keys |
|---|---|---|
flow_id | Unknown | PK |
engagement_id | Unknown | PKFK |
flow_name | Unknown | |
flow_version | Unknown |
messaging_historical_detail_report_queue
| Column | Type | Keys |
|---|---|---|
cc_queue_id | Unknown | PKFK |
engagement_id | Unknown | PKFK |
queue_name | Unknown |
messaging_historical_detail_report_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
display_name | Unknown | |
user_id | Unknown |
messaging_historical_detail_report_required_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
messaging_historical_detail_report_optional_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
messaging_historical_detail_report_agent_skill
| Column | Type | Keys |
|---|---|---|
skill_id | Unknown | PK |
engagement_id | Unknown | PKFK |
minimum_proficiency_level | Unknown | |
skill_name | Unknown |
messaging_historical_detail_report
| Column | Type | Keys |
|---|---|---|
engagement_id | Unknown | PK |
disposition_id | Unknown | FK |
agent_first_message_speed | Unknown | |
callback_pending_duration | Unknown | |
callback_waiting_duration | Unknown | |
channel | Unknown | |
consumer_id | Unknown | |
consumer_name | Unknown | |
consumer_number | Unknown | |
dialed_numbers | Json | |
direction | Unknown | |
disposition_name | Unknown | |
handling_duration | Unknown | |
hold_duration | Unknown | |
ivr_duration | Unknown | |
last_widget_name | Unknown | |
queue_wait_type | Unknown | |
results | Unknown | |
ring_duration | Unknown | |
start_time | Instant | |
talking_duration | Unknown | |
total_duration | Unknown | |
total_flow_duration | Unknown | |
waiting_duration | Unknown | |
wrap_up_duration | Unknown |
deal_activity
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
deal_id | Unknown | PKFK |
conversation_id | Unknown | FK |
host_id | Unknown | FK |
activity_type | Unknown | |
conversation_topic | Unknown | |
direction | Unknown | |
duration | Unknown | |
engagement_score | Unknown | |
message_id | Unknown | |
number_of_message_in_thread | Unknown | |
processing_analysis | Unknown | |
sentiment_score | Unknown | |
stage | Unknown | |
stage_during_conversation | Unknown | |
start_date | Instant |
conversation_scorecard_question
| Column | Type | Keys |
|---|---|---|
question_id | Unknown | PK |
conversation_id | Unknown | PKFK |
conversation_scorecard_id | Unknown | PKFK |
max_score_label | Unknown | |
min_score_label | Unknown | |
question_comment | Unknown | |
question_description | Unknown | |
question_title | Unknown | |
score | Unknown |
conversation_scorecard
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conversation_id | Unknown | PKFK |
user_id | Unknown | FK |
average_score | Unknown | |
rate_time | Unknown | |
rater_display_name | Unknown | |
rater_email | Unknown | |
rater_user_id | Unknown | |
scorecard_description | Unknown | |
scorecard_name | Unknown |
engagement_survey_result
| Column | Type | Keys |
|---|---|---|
question_id | Unknown | PK |
engagement_id | Unknown | PKFK |
survey_id | Unknown | PKFK |
answer | Unknown | |
date_time | Unknown | |
file_url | Unknown | |
question_name | Unknown | |
question_order | Unknown | |
question_type | Unknown |
engagement_survey
| Column | Type | Keys |
|---|---|---|
survey_id | Unknown | PK |
engagement_id | Unknown | PKFK |
flow_id | Unknown | FK |
queue_id | Unknown | FK |
flow_name | Unknown | |
queue_name | Unknown | |
survey_name | Unknown | |
survey_trigger_level | Unknown |
engagement_channel
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
channel | Unknown | |
channel_source | Unknown |
engagement_consumer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
consumer_display_name | Unknown | |
consumer_id | Unknown | |
consumer_number | Unknown |
engagement_flow
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
flow_id | Unknown | |
flow_name | Unknown | |
flow_version | Unknown |
engagement_queues
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
cc_queue_id | Unknown | |
queue_name | Unknown |
engagement_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
id | Unknown | FK |
display_name | Unknown | |
user_id | Unknown |
engagement_event_skill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_event_index | Unknown | PKFK |
engagement_id | Unknown | PKFK |
skill_category_id | Unknown | |
skill_category_name | Unknown | |
skill_id | Unknown | |
skill_name | Unknown | |
skill_proficiency_level | Unknown |
engagement_event
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
transfer_to_user_id | Unknown | FK |
user_id | Unknown | FK |
accept_type | Unknown | |
cc_queue_id | Unknown | |
channel | Unknown | |
channel_source | Unknown | |
conference_type | Unknown | |
consumer_display_name | Unknown | |
consumer_id | Unknown | |
crm_call_status | Unknown | |
crm_type | Unknown | |
direction | Unknown | |
duration | Unknown | |
email_reply_bcc | Json | |
email_reply_cc | Json | |
email_reply_to | Json | |
event_type | Unknown | |
flow_id | Unknown | |
flow_name | Unknown | |
inbox_id | Unknown | |
inbox_name | Unknown | |
invitee | Unknown | |
invitee_type | Unknown | |
queue_name | Unknown | |
start_time | Unknown | |
supervisor_display_name | Unknown | |
supervisor_id | Unknown | |
transfer_to_cc_queue_id | Unknown | |
transfer_to_flow_id | Unknown | |
transfer_to_flow_name | Unknown | |
transfer_to_number | Unknown | |
transfer_to_queue_name | Unknown | |
transfer_to_user_display_name | Unknown | |
transfer_type | Unknown | |
upgraded_to_channel_type | Unknown | |
user_display_name | Unknown |
engagement_disposition
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
id | Unknown | FK |
disposition_id | Unknown | |
disposition_name | Unknown |
engagement_notes
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | Unknown | PKFK |
last_modified_time | Unknown | |
note | Unknown | |
note_id | Unknown | |
user_id | Unknown |
engagement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
channel_types | Unknown | |
direction | Unknown | |
duration | Unknown | |
end_time | Unknown | |
flow_duration | Unknown | |
handling_duration | Unknown | |
queue_wait_type | Unknown | |
start_time | Unknown | |
survey_id | Unknown | |
talk_duration | Unknown | |
transcript_url | Unknown | |
transfer_count | Unknown | |
voice_mail | Unknown | |
waiting_duration | Unknown | |
wrap_up_duration | Unknown |