# Khoros Care schema ERD

Table and field reference for the Fivetran Khoros Care connector.

## 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 |  |

## Relationships

- response_report(conversation_id) → conversation_report(conversation_id)
- response_report(responding_agent_display_id) → user_report(agent_display_id)
- combined_report(assignee_author_display_id) → user_report(agent_display_id)
- combined_report(conversation_id) → conversation_report(conversation_id)
- team_performance_report(team_name) → team(name)
- team_performance_report(agent_display_id) → user_report(agent_display_id)
- conversation_action_history_report(conversation_id) → conversation_report(conversation_id)
- incoming_post_report(conversation_id) → conversation_report(conversation_id)
- conversation_report(assigned_agent_display_id) → user_report(agent_display_id)
- response_approval_report(submitter_display_id) → user_report(agent_display_id)
- response_approval_report(conversation_id) → conversation_report(conversation_id)
- response_approval_report(approver_display_id) → user_report(agent_display_id)
- help_request_report(conversation_id) → conversation_report(conversation_id)
- help_request_report(responding_expert_display_id) → user_report(agent_display_id)
- help_request_report(help_requester_display_id) → user_report(agent_display_id)
- user_report(team_name) → team(name)
- team_performance_interval(team_name) → team(name)
- team_performance_interval(agent_display_id) → user_report(agent_display_id)