Khoros Care

Explore the interactive ERD

Table & Field Reference

team

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`name`	Unknown
`number_of_members`	Unknown
`uuid`	Unknown

response_report

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Unknown	FK
`responding_agent_display_id`	Unknown	FK
`agent_response_order`	Unknown
`assistant_rht`	Unknown
`auto_tag`	Unknown
`bot_response_order`	Unknown
`date_claimed`	Unknown
`expert_rht`	Unknown
`external_response_id`	Unknown
`handle_time_approving_agent`	Unknown
`handle_time_other_agent`	Unknown
`handle_time_responding_agent`	Unknown
`handle_time_total_response`	Unknown
`lsw_conversation_link`	Unknown
`lsw_responded_post_in_business_hour`	Unknown
`lsw_responded_to_external_post_id`	Unknown
`lsw_responded_to_post_author_uuid`	Unknown
`lsw_responded_to_post_content`	Unknown
`lsw_responded_to_post_published_time`	Unknown
`lsw_responded_to_post_received_time`	Unknown
`manual_tag`	Unknown
`responding_agent_email`	Unknown
`response_content`	Unknown
`response_handle`	Unknown
`response_language`	Unknown
`response_location`	Unknown
`response_order`	Unknown
`response_provider`	Unknown
`response_published_date`	Unknown
`response_sentiment`	Unknown
`response_tag`	Unknown
`response_tar`	Unknown
`response_type`	Unknown
`sentiment_conversion`	Unknown
`source_tag`	Unknown
`unique_id`	Unknown

combined_report

Column	Type	Keys
`_fivetran_id`	String	PK
`assignee_author_display_id`	Unknown	FK
`conversation_id`	Unknown	FK
`approver_response_handle_time`	Unknown
`assignee_author_email`	Unknown
`assignee_team`	Unknown
`assistant_response_handle_time`	Unknown
`author_tag`	Unknown
`author_uuid`	Unknown
`average_tar_minutes`	Unknown
`close_note`	Unknown
`closed_date`	Unknown
`closer_wrap_or_close_handle_time`	Unknown
`content`	Unknown
`conversation_post_tag`	Unknown
`conversation_response_handle_time`	Unknown
`created_date`	Unknown
`date_claimed`	Unknown
`expert_response_handle_time`	Unknown
`external_id`	Unknown
`languages`	Unknown
`other_wrap_or_close_handle_time`	Unknown
`published_date`	Unknown
`received_during_business_hour`	Unknown
`responder_response_handle_time`	Unknown
`sentiment`	Unknown
`source`	Unknown
`status`	Unknown
`survey_comment`	Unknown
`survey_completed_time`	Unknown
`survey_response`	Unknown
`survey_sent_time`	Unknown
`survey_type`	Unknown
`total_in_progress_time`	Unknown
`total_posts_order_in_convo`	Unknown
`total_posts_post_order`	Unknown
`total_responses_response_order`	Unknown
`total_wrap_or_close_handle_time`	Unknown
`type`	Unknown
`unique_id`	Unknown

team_performance_report

Column	Type	Keys
`_fivetran_id`	String	PK
`agent_display_id`	Unknown	FK
`team_name`	Unknown	FK
`agent_activities_active_time_in_focus`	Unknown
`agent_activities_active_time_out_of_focus`	Unknown
`agent_activities_avg_responder_rht`	Unknown
`agent_activities_idle_time_in_focus`	Unknown
`agent_activities_idle_time_out_of_focus`	Unknown
`agent_activities_in_app_time_in_focus`	Unknown
`agent_activities_in_app_time_out_of_focus`	Unknown
`agent_activities_inactive_time_in_focus`	Unknown
`agent_activities_inactive_time_out_of_focus`	Unknown
`agent_activities_non_agent_time_in_focus`	Unknown
`agent_activities_non_agent_time_out_of_focus`	Unknown
`agent_activities_total_approval_sent`	Unknown
`agent_activities_total_approver_rht`	Unknown
`agent_activities_total_assistant_rht`	Unknown
`agent_activities_total_case_note_added`	Unknown
`agent_activities_total_close_ht`	Unknown
`agent_activities_total_closer_close_ht`	Unknown
`agent_activities_total_closer_wrap_ht`	Unknown
`agent_activities_total_expert_rht`	Unknown
`agent_activities_total_in_progress_time`	Unknown
`agent_activities_total_other_close_ht`	Unknown
`agent_activities_total_other_wrap_ht`	Unknown
`agent_activities_total_responder_rht`	Unknown
`agent_activities_total_response_ht`	Unknown
`agent_activities_total_review_closed_time`	Unknown
`agent_activities_total_wrap_ht`	Unknown
`agent_reroute`	Unknown
`agent_unassign`	Unknown
`agent_utilization`	Unknown
`average_conversation_handle_time`	Unknown
`average_first_response_tar`	Unknown
`average_response_handle_time`	Unknown
`average_subsequent_response_tar`	Unknown
`average_tar`	Unknown
`average_time_in_available_queue`	Unknown
`claim`	Unknown
`conversation_closed`	Unknown
`conversation_closed_with_engagement`	Unknown
`conversation_closed_without_engagement`	Unknown
`conversations_acted_on`	Unknown
`conversations_handled`	Unknown
`conversations_in_assigned`	Unknown
`conversations_in_pending`	Unknown
`conversations_pushed`	Unknown
`conversations_responded_to`	Unknown
`conversations_snoozed`	Unknown
`email`	Unknown
`first_response`	Unknown
`interval_end_date`	Unknown
`interval_start_date`	Unknown
`median_tar`	Unknown
`other_unassign`	Unknown
`primary_responder_csat_score`	Unknown
`primary_responder_csat_survey`	Unknown
`primary_responder_nps_score`	Unknown
`primary_responder_nps_survey`	Unknown
`re_opened`	Unknown
`reassign`	Unknown
`responded_to_avg_case_handle_time`	Unknown
`responded_to_avg_response_handle_time`	Unknown
`response`	Unknown
`responses_handled`	Unknown
`subsequent_responses`	Unknown
`total_assigned`	Unknown
`total_first_claim`	Unknown
`total_handle_time`	Unknown
`total_snooze_action`	Unknown
`total_time_logged_in`	Unknown

conversation_action_history_report

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Unknown	FK
`acting_agent`	Unknown
`acting_agent_email`	Unknown
`acting_agent_sso_id`	Unknown
`acting_agent_state`	Unknown
`action_performed`	Unknown
`action_performed_date`	Unknown
`author`	Unknown
`cc_email`	Unknown
`comment`	Unknown
`community_response`	Unknown
`content_filter`	Unknown
`current_disposition`	Unknown
`current_priority`	Unknown
`history_action`	Unknown
`merged_conversation_id`	Unknown
`note`	Unknown
`post`	Unknown
`post_date`	Unknown
`response`	Unknown
`snooze_duration`	Unknown
`snooze_duration_unit`	Unknown
`source`	Unknown
`tags`	Unknown
`to_email`	Unknown
`workqueue_current`	Unknown

incoming_post_report

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Unknown	FK
`all_author_tags`	Unknown
`all_post_tags`	Unknown
`author_auto_tags`	Unknown
`author_handle`	Unknown
`author_manual_tags`	Unknown
`author_uuid`	Unknown
`auto_tag_num_tags`	Unknown
`auto_tag_tags`	Unknown
`conversation_priority`	Unknown
`conversation_work_queue`	Unknown
`date_post_published`	Unknown
`date_post_received`	Unknown
`external_author_handle_id`	Unknown
`external_post_id`	Unknown
`lsw_conversation_link`	Unknown
`manual_tag_num_tags`	Unknown
`manual_tag_tags`	Unknown
`post_content`	Unknown
`post_language`	Unknown
`post_location`	Unknown
`post_order`	Unknown
`post_permalink`	Unknown
`post_provider`	Unknown
`post_sentiment`	Unknown
`post_source_tag`	Unknown
`post_type`	Unknown
`received_during_business_hours`	Unknown
`unique_id`	Unknown
`work_queue_at_time_of_event`	Unknown

conversation_report

Column	Type	Keys
`_fivetran_id`	String	PK
`assigned_agent_display_id`	Unknown	FK
`all_author_tag`	Unknown
`all_custom_tag`	Unknown
`approver_rht`	Unknown
`assigned_agent_email`	Unknown
`assistant_rht`	Unknown
`author`	Unknown
`author_handle`	Unknown
`author_responded`	Unknown
`author_uuid`	Unknown
`auto_tag`	Unknown
`close_note`	Unknown
`closed_date`	Unknown
`conversation_id`	Unknown
`conversation_other_wcht`	Unknown
`conversation_source`	Unknown
`conversation_wcht`	Unknown
`created_date`	Unknown
`expert_rht`	Unknown
`handle_time_average_conversation_approval`	Unknown
`handle_time_average_conversation_response`	Unknown
`handle_time_conversation_assigned_agent`	Unknown
`handle_time_conversation_total`	Unknown
`handle_time_conversation_wrap_up`	Unknown
`language_tag`	Unknown
`location_tag`	Unknown
`manual_tag`	Unknown
`num_negative_post`	Unknown
`num_neutral_post`	Unknown
`num_positive_post`	Unknown
`num_private_post`	Unknown
`num_private_response`	Unknown
`responder_rht`	Unknown
`response_handles_used`	Unknown
`response_ht`	Unknown
`sentiment_conversion`	Unknown
`source_tag`	Unknown
`status`	Unknown
`survey_comment`	Unknown
`survey_completed_time`	Unknown
`survey_response`	Unknown
`survey_sent_time`	Unknown
`survey_type`	Unknown
`system_tag`	Unknown
`total_in_progress_time`	Unknown
`total_post`	Unknown
`total_response`	Unknown
`work_queue_at_time_of_event`	Unknown

response_approval_report

Column	Type	Keys
`_fivetran_id`	String	PK
`approver_display_id`	Unknown	FK
`conversation_id`	Unknown	FK
`submitter_display_id`	Unknown	FK
`approval_date`	Unknown
`approval_decision`	Unknown
`approval_disposition`	Unknown
`approval_edited_response`	Unknown
`approval_handle_time`	Unknown
`approval_note`	Unknown
`approver_email`	Unknown
`approver_team`	Unknown
`response_draft_id`	Unknown
`submission_content`	Unknown
`submission_date`	Unknown
`submitter_email`	Unknown
`submitter_response_handle_time`	Unknown
`submitter_team`	Unknown
`total_approval_time`	Unknown

help_request_report

Column	Type	Keys
`_fivetran_id`	String	PK
`conversation_id`	Unknown	FK
`help_requester_display_id`	Unknown	FK
`responding_expert_display_id`	Unknown	FK
`available_expert`	Unknown
`help_request_end_reason`	Unknown
`help_requester_comment`	Unknown
`help_requester_email`	Unknown
`help_requester_team`	Unknown
`link_to_conversation`	Unknown
`link_to_response`	Unknown
`responding_expert_comment`	Unknown
`responding_expert_email`	Unknown
`responding_expert_team`	Unknown
`response_content`	Unknown
`time_awaiting_help_min`	Unknown
`time_of_expert_response`	Unknown
`time_of_help_request`	Unknown
`total_response_handle_time_min`	Unknown

user_report

Column	Type	Keys
`_fivetran_id`	String	PK
`team_name`	Unknown	FK
`agent_display_id`	Unknown
`email`	Unknown
`last_login_time`	Unknown
`total_console_logged_in_time`	Unknown
`total_green_state_time`	Unknown
`total_mobile_time`	Unknown
`total_red_state_time`	Unknown
`total_yellow_state_time`	Unknown
`user_type`	Unknown

team_performance_interval

Column	Type	Keys
`_fivetran_id`	String	PK
`agent_display_id`	Unknown	FK
`team_name`	Unknown	FK
`agent_activities_total_review_closed_time`	Unknown
`agent_activities_v_2_active_time_in_focus`	Unknown
`agent_activities_v_2_active_time_out_of_focus`	Unknown
`agent_activities_v_2_avg_responder_rht`	Unknown
`agent_activities_v_2_idle_time_in_focus`	Unknown
`agent_activities_v_2_idle_time_out_of_focus`	Unknown
`agent_activities_v_2_in_app_time_in_focus`	Unknown
`agent_activities_v_2_in_app_time_out_of_focus`	Unknown
`agent_activities_v_2_inactive_time_in_focus`	Unknown
`agent_activities_v_2_inactive_time_out_of_focus`	Unknown
`agent_activities_v_2_non_agent_time_in_focus`	Unknown
`agent_activities_v_2_non_agent_time_out_of_focus`	Unknown
`agent_activities_v_2_total_in_progress`	Unknown
`agent_activities_v_2_total_response_ht`	Unknown
`agent_reroute`	Unknown
`agent_unassign`	Unknown
`agent_utilization`	Unknown
`average_conversation_handle_time`	Unknown
`average_first_response_tar`	Unknown
`average_response_handle_time`	Unknown
`average_subsequent_response_tar`	Unknown
`average_tar`	Unknown
`average_time_in_available_queue`	Unknown
`claim`	Unknown
`conversation_closed`	Unknown
`conversation_closed_with_engagement`	Unknown
`conversation_closed_without_engagement`	Unknown
`conversation_pushed`	Unknown
`conversations_acted_on`	Unknown
`conversations_handled`	Unknown
`conversations_in_assigned`	Unknown
`conversations_in_pending`	Unknown
`conversations_responded_to`	Unknown
`conversations_snoozed`	Unknown
`email`	Unknown
`first_response`	Unknown
`interval_end_date`	Unknown
`interval_start_date`	Unknown
`median_tar`	Unknown
`other_unassign`	Unknown
`primary_responder_csat_score`	Unknown
`primary_responder_csat_survey`	Unknown
`re_opened`	Unknown
`reassign`	Unknown
`responded_to_avg_case_handle_time`	Unknown
`responded_to_avg_response_handle_time`	Unknown
`response`	Unknown
`responses_handled`	Unknown
`subsequent_response`	Unknown
`total_assigned`	Unknown
`total_first_claim`	Unknown
`total_handle_time`	Unknown
`total_snooze_action`	Unknown
`total_time_logged_in`	Unknown