Description: Genesys Cloud users.
Loading diagram…
erDiagram
AGENT_SCHEDULES {
string user_id
string schedule_id
string week_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
AGENTS_SCHEDULES {
string user_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
BU_AGENT_SCHEDULES {
string user_id
string schedule_id
string week_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CALIBRATIONS {
string id PK
string calibrator__id
string agent__id
string conversation__id
string evaluation_form__id
float average_score
float high_score
float low_score
datetime created_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CALIBRATIONS__EVALUATIONS {
string id
string conversation__id
string evaluation_form__id
string evaluator__id
string agent__id
string calibration__id
float calibration__average_score
float calibration__high_score
float calibration__low_score
string status
float answers__total_score
float answers__total_critical_score
float answers__total_non_critical_score
boolean agent_has_read
datetime assigned_date
datetime created_date
boolean never_release
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
CONVERSATION_UNI_YYYY_MM {
string id
string conversation_id
string session_id
datetime conversation_start
datetime conversation_end
datetime segment_start
string external_tag
datetime segment_end
string participant_id
string participant_name
string user_id
string purpose
string direction
string media_type
string disconnect_type
string queue_id
string queue_name
string wrap_up_code
string wrap_up_note
string flow_id
string flow_name
string outbound_campaign_id
string outbound_contact_id
string outbound_contact_list_id
float alert
float callback
float coaching
float contacting
float converting
float delay
float dialing
float hold
float interact
float ivr
float monitoring
float scheduled
float sharing
float system
float transmitting
float unknown
float uploading
float voicemail
float wrapup
float total
string ani
string dnis
string sip_response_codes
string transfer_target_address
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CONVERSATIONS_MESSAGES__MESSAGING_TRANSCRIPT {
string id
string pcfrom
string to
datetime timestamp
string message_text
string from_user__id
string from_user__name
string from_user__username
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
CONVERSATIONS_MESSAGES__TRANSCRIPT {
string id
string chat
string body_type
string body
string message
string utc
string participant_purpose
string pcfrom
string sender_communication_id
string to
string type
string user__id
string user__name
string user__display_name
string user__username
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
DIVISIONS {
string id PK
string name
boolean home_division
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
EVALUATION {
string evaluation_id PK
string evaluator_id
string agent_id
string conversation_id
boolean agent_reviewed
datetime assigned_date
string media_type
string evaluation_form_id
string evaluation_form_name
float total_score
string comments
string status
string agent_comments
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
datetime changed_date
}
HISTORICAL_ADHERENCE {
string userid
datetime startdate
datetime enddate
string impact
string management_unit_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_ADHERENCES {
string user_id
string management_unit_id
string team__id
string team__name
string team__description
datetime team__date_modified
float team__member_count
string scheduled_activity_category
string system_presence
string organization_secondary_presence_id
string routing_status
string actual_activity_category
boolean is_out_of_office
datetime time_of_adherence_change
datetime presence_update_time
datetime active_queues_modified_time
boolean removed_from_management_unit
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_AGENT {
string id
string user__id
string work_plan__id
string work_plan__management_unit__id
string work_plan_rotation__id
boolean accept_direct_shift_trades
boolean schedulable
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_USERS {
string management_unit_id PK
string user_id PK
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES {
string id
string week_date
string schedule__id
string schedule__week_date
string schedule__business_unit__id
string state
string initiating_user__id
string initiating_shift_id
datetime initiating_shift_start
datetime initiating_shift_end
string receiving_user__id
string receiving_shift_id
datetime receiving_shift_start
datetime receiving_shift_end
datetime expiration
boolean one_sided
string reviewed_by__id
datetime reviewed_date
float metadata__version
string metadata__modified_by__id
datetime metadata__date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENTUNIT_AGENT_SHIFT_TRADES {
string id
string week_date
string schedule__id
string schedule__week_date
string schedule__business_unit__id
string state
string initiating_user__id
string initiating_shift_id
datetime initiating_shift_start
datetime initiating_shift_end
string receiving_user__id
string receiving_shift_id
datetime receiving_shift_start
datetime receiving_shift_end
datetime expiration
boolean one_sided
string reviewed_by__id
datetime reviewed_date
float metadata__version
string metadata__modified_by__id
datetime metadata__date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
PRESENCE {
string id PK
string language_labels__en_us
string language_labels__en
string language_labels__pt_br
boolean language_labels__exported
datetime created_date
datetime modified_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
QUEUE_MEMBERSHIP {
string id PK
string queue_id
string user_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_AGENTS_EMPATHY {
string conversation_id
string transcript_id
string agent_user_id
float agent_empathy_score
string conversation_start_time
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_PARTICIPANTS {
string id PK
string conversation_id
string participant_id
string user_id
string purpose
string direction
string queue_id
float empathy_score
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_TRANSCRIPT_TEXT {
string conversation_id
string communication_id
string transcript_id
bigint utterance_index
string participant_purpose
string user_id
bigint start_ms
datetime start_time
bigint duration_ms
float confidence
string text
string decorated_text
string language
string engine_provider
string engine_id
string extracted_at
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_TRANSCRIPTS {
string conversation_id PK
datetime conversation_start_time
float conversation_sentiment_score
float conversation_sentiment_trend
float conversation_empathy_score
bigint conv_duration_ms
bigint handle_time_ms
bigint cust_speech_ms
bigint agent_speech_ms
bigint overtalk_ms
bigint overtalk_instances
bigint silence_ms
bigint ivr_ms
bigint other_ms
bigint queue_acd_ms
float cust_speech_pct
float agent_speech_pct
float overtalk_pct
float silence_pct
float ivr_pct
float other_pct
float queue_acd_pct
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
string agent_user_id
string agent_queue_id
}
SUPERIORS {
string agent_id
string id
string name
string department
string email
string state
string title
string manager__id
float version
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
USER_ADHERENCE {
string user_id
string management_unit__id
string scheduled_activity_category
string system_presence
string organization_secondary_presence_id
string routing_status
string actual_activity_category
boolean is_out_of_office
string adherence_state
string impact
datetime time_of_adherence_change
datetime presence_update_time
datetime active_queues_modified_time
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
USER_STATE {
string id PK
string user_id
datetime start_time
datetime end_time
string state
string state_id
string duration
string type
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
USERS {
string id PK
string name
string division__id
string department
string email
string state
string title
string username
string manager__id
float version
string employer_info__official_name
string employer_info__employee_id
string employer_info__employee_type
string employer_info__date_hire
string routing_status__status
datetime routing_status__start_time
string presence__id
string presence__name
string presence__source
boolean presence__primary
string presence__presence_definition__id
string presence__presence_definition__system_presence
string presence__message
datetime presence__modified_date
string team__id
string team__name
string team__description
datetime team__date_modified
float team__member_count
boolean acd_auto_answer
string language_preference
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WORK_PLANS_ROTATIONS__AGENTS {
string user__id
string date_range__start_business_unit_date
string date_range__end_business_unit_date
float position
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
USERS }o--|| DIVISIONS : division__id
USERS }o--|| USERS : manager__id
USERS }o--|| PRESENCE : presence__id
AGENT_SCHEDULES }o--|| USERS : user_id
AGENTS_SCHEDULES }o--|| USERS : user_id
BU_AGENT_SCHEDULES }o--|| USERS : user_id
CALIBRATIONS }o--|| USERS : agent__id
CALIBRATIONS }o--|| USERS : calibrator__id
CALIBRATIONS__EVALUATIONS }o--|| USERS : agent__id
CALIBRATIONS__EVALUATIONS }o--|| USERS : evaluator__id
CONVERSATION_UNI_YYYY_MM }o--|| USERS : user_id
CONVERSATIONS_MESSAGES__MESSAGING_TRANSCRIPT }o--|| USERS : from_user__id
CONVERSATIONS_MESSAGES__TRANSCRIPT }o--|| USERS : user__id
EVALUATION }o--|| USERS : agent_id
EVALUATION }o--|| USERS : evaluator_id
HISTORICAL_ADHERENCE }o--|| USERS : userid
MANAGEMENT_UNIT_ADHERENCES }o--|| USERS : user_id
MANAGEMENT_UNIT_AGENT }o--|| USERS : user__id
MANAGEMENT_UNIT_USERS }o--|| USERS : user_id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| USERS : initiating_user__id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| USERS : receiving_user__id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| USERS : reviewed_by__id
MANAGEMENTUNIT_AGENT_SHIFT_TRADES }o--|| USERS : initiating_user__id
MANAGEMENTUNIT_AGENT_SHIFT_TRADES }o--|| USERS : receiving_user__id
MANAGEMENTUNIT_AGENT_SHIFT_TRADES }o--|| USERS : reviewed_by__id
QUEUE_MEMBERSHIP }o--|| USERS : user_id
SPEECH_AGENTS_EMPATHY }o--|| USERS : agent_user_id
SPEECH_PARTICIPANTS }o--|| USERS : user_id
SPEECH_TRANSCRIPT_TEXT }o--|| USERS : user_id
SPEECH_TRANSCRIPTS }o--|| USERS : agent_user_id
SUPERIORS }o--|| USERS : agent_id
SUPERIORS }o--|| USERS : id
SUPERIORS }o--|| USERS : manager__id
USER_ADHERENCE }o--|| USERS : user_id
USER_STATE }o--|| USERS : user_id
WORK_PLANS_ROTATIONS__AGENTS }o--|| USERS : user__id
| Source column |
Target table |
Target column |
division__id |
divisions |
id |
manager__id |
users |
id |
presence__id |
presence |
id |