Description: Child table derived from the nested structure of work_plans_rotations extracted from Genesys Cloud.
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
}
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_ROTATIONS__PATTERN__WORK_PLANS }o--|| WORK_PLANS : id
WORK_PLANS_ROTATIONS__PATTERN__WORK_PLANS }o--|| MANAGEMENT_UNIT : management_unit__id
| Source table |
Source column |
Target column |
| - |
- |
- |