Description: WFM work plans.
Loading diagram…
erDiagram
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_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
}
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
}
WORK_PLANS }o--|| MANAGEMENT_UNIT : managment_unit_id
MANAGEMENT_UNIT_AGENT }o--|| WORK_PLANS : work_plan__id
WORK_PLANS_ROTATIONS__PATTERN__WORK_PLANS }o--|| WORK_PLANS : id
| Source column |
Target table |
Target column |
managment_unit_id |
management_unit |
id |