Description: Genesys Cloud ACD queues.
Loading diagram…
erDiagram
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
}
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
}
MANAGEMENT_UNIT_ADHERENCES__ACTIVE_QUEUES {
string id
boolean exported
string _sdc_source_key_user_id
string _sdc_source_key_management_unit_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
PLANNING_GROUP__ROUTE_PATHS {
string queue__id
string media_type
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
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
}
QUEUES {
string id PK
string name
string division__id
string division__name
float member_count
float media_settings__call__alerting_timeout_seconds
float media_settings__call__service_level__percentage
float media_settings__call__service_level__duration_ms
float media_settings__socialexpression__alerting_timeout_seconds
float media_settings__socialexpression__service_level__percentage
float media_settings__socialexpression__service_level__duration_ms
float media_settings__chat__alerting_timeout_seconds
float media_settings__chat__service_level__percentage
float media_settings__chat__service_level__duration_ms
float media_settings__callback__alerting_timeout_seconds
float media_settings__callback__service_level__percentage
float media_settings__callback__service_level__duration_ms
float media_settings__message__alerting_timeout_seconds
float media_settings__message__service_level__percentage
float media_settings__message__service_level__duration_ms
float media_settings__videocomm__alerting_timeout_seconds
float media_settings__videocomm__service_level__percentage
float media_settings__videocomm__service_level__duration_ms
float media_settings__email__alerting_timeout_seconds
float media_settings__email__service_level__percentage
float media_settings__email__service_level__duration_ms
datetime date_created
datetime date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SHORT_TERM_FORECAST_PLANNING_GROUPS__ROUTE_PATHS {
string queue__id
string media_type
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
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_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
}
USER_ADHERENCE__ACTIVE_QUEUES {
string id
boolean exported
string _sdc_source_key_user_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
QUEUES }o--|| DIVISIONS : division__id
CONVERSATION_UNI_YYYY_MM }o--|| QUEUES : queue_id
MANAGEMENT_UNIT_ADHERENCES__ACTIVE_QUEUES }o--|| QUEUES : id
PLANNING_GROUP__ROUTE_PATHS }o--|| QUEUES : queue__id
QUEUE_MEMBERSHIP }o--|| QUEUES : queue_id
SHORT_TERM_FORECAST_PLANNING_GROUPS__ROUTE_PATHS }o--|| QUEUES : queue__id
SPEECH_PARTICIPANTS }o--|| QUEUES : queue_id
SPEECH_TRANSCRIPTS }o--|| QUEUES : agent_queue_id
USER_ADHERENCE__ACTIVE_QUEUES }o--|| QUEUES : id
| Source column |
Target table |
Target column |
division__id |
divisions |
id |