Description: WFM planning groups.
Loading diagram…
erDiagram
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
}
PLANNING_GROUP {
string id PK
string name
string service_goal_template__id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
PLANNING_GROUP_RESULTS {
string planning_group_id
string forecast_id
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SERVICE_GOAL_TEMPLATE {
string id PK
string name
boolean service_level__include
float service_level__percent
float service_level__seconds
boolean average_speed_of_answer__include
float average_speed_of_answer__seconds
boolean abandon_rate__include
float abandon_rate__percent
datetime date_modified
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SHORT_TERM_FORECASTS_DATA {
string planning_group_id
datetime reference_start_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
PLANNING_GROUP }o--|| SERVICE_GOAL_TEMPLATE : service_goal_template__id
INTRADAY }o--|| PLANNING_GROUP : planning_group_id
PLANNING_GROUP_RESULTS }o--|| PLANNING_GROUP : planning_group_id
SHORT_TERM_FORECASTS_DATA }o--|| PLANNING_GROUP : planning_group_id