Description: Child table derived from the nested structure of management_unit_adherences extracted from Genesys Cloud.
Loading diagram…
erDiagram
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
}
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
}
MANAGEMENT_UNIT_ADHERENCES__ACTIVE_QUEUES }o--|| QUEUES : id
| Source column |
Target table |
Target column |
id |
queues |
id |
| Source table |
Source column |
Target column |
| - |
- |
- |