Description: Unidades de gerenciamento do 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
}
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 {
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_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
}
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
}
WEEK_SCHEDULE_METADATA__MANAGEMENT_UNITS {
string management_unit__id
float agent_count
boolean exported
string _sdc_source_key_id
string _sdc_source_key_week_date
bigint _sdc_sequence
bigint _sdc_level_0_id
}
WORK_PLANS {
string id PK
string name
boolean enabled
boolean valid
boolean constrain_weekly_paid_time
boolean flexible_weekly_paid_time
float weekly_exact_paid_minutes
float weekly_minimum_paid_minutes
float weekly_maximum_paid_minutes
boolean constrain_paid_time_granularity
float paid_time_granularity_minutes
boolean constrain_minimum_time_between_shifts
float minimum_time_between_shifts_minutes
float maximum_days
string start_day_of_weekend
float minimum_consecutive_non_working_minutes_per_week
boolean constrain_maximum_consecutive_working_weekends
float maximum_consecutive_working_weekends
float minimum_working_days_per_week
boolean constrain_maximum_consecutive_working_days
float maximum_consecutive_working_days
float minimum_shift_start_distance_minutes
float minimum_days_off_per_planning_period
float maximum_days_off_per_planning_period
float minimum_paid_minutes_per_planning_period
float maximum_paid_minutes_per_planning_period
string shift_start_variance_type
float agent_count
string managment_unit_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WORK_PLANS_ROTATIONS__PATTERN__WORK_PLANS {
string id
string management_unit__id
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
MANAGEMENT_UNIT }o--|| BUSINESS_UNITS : business_unit__id
HISTORICAL_ADHERENCE }o--|| MANAGEMENT_UNIT : management_unit_id
MANAGEMENT_UNIT_ADHERENCES }o--|| MANAGEMENT_UNIT : management_unit_id
MANAGEMENT_UNIT_AGENT }o--|| MANAGEMENT_UNIT : work_plan__management_unit__id
MANAGEMENT_UNIT_USERS }o--|| MANAGEMENT_UNIT : management_unit_id
USER_ADHERENCE }o--|| MANAGEMENT_UNIT : management_unit__id
WEEK_SCHEDULE_METADATA__MANAGEMENT_UNITS }o--|| MANAGEMENT_UNIT : management_unit__id
WORK_PLANS }o--|| MANAGEMENT_UNIT : managment_unit_id
WORK_PLANS_ROTATIONS__PATTERN__WORK_PLANS }o--|| MANAGEMENT_UNIT : management_unit__id
| Source column |
Target table |
Target column |
business_unit__id |
business_units |
id |