Description: Business units in Genesys Cloud Workforce Management.
Loading diagram…
erDiagram
BUSINESS_UNITS {
string id PK
string name
boolean authorized
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
INTRADAY {
string id
string business_unit_id
string planning_group_id
datetime start_date
datetime end_date
string short_term_forecast__id
string short_term_forecast__week_date
string schedule__id
string schedule__week_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
MANAGEMENT_UNIT {
string id PK
string name
string business_unit__id
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
}
INTRADAY }o--|| BUSINESS_UNITS : business_unit_id
MANAGEMENT_UNIT }o--|| BUSINESS_UNITS : business_unit__id
MANAGEMENT_UNIT_WEEK_SHIFT_TRADES }o--|| BUSINESS_UNITS : schedule__business_unit__id
MANAGEMENTUNIT_AGENT_SHIFT_TRADES }o--|| BUSINESS_UNITS : schedule__business_unit__id
| Source column |
Target table |
Target column |
| - |
- |
- |