Description: Weekly WFM schedules.
Loading diagram…
erDiagram
AGENT_SCHEDULES {
string user_id
string schedule_id
string week_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
BU_AGENT_SCHEDULES {
string user_id
string schedule_id
string week_date
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
}
SCHEDULING_RUNS {
string id
string scheduler_run_id
boolean intraday_rescheduling
string state
float week_count
float percent_complete
string target_week
string schedule__id
string schedule__week_date
string schedule_description
datetime scheduling_start_time
string scheduling_started_by__id
datetime scheduling_completed_time
float message_count
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SHORT_TERM_FORECASTS {
string id PK
string week_date
float week_count
string creation_method
string description
boolean legacy
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WEEK_SCHEDULES {
string id PK
string week_date
float week_count
string description
boolean published
string short_term_forecast__id
boolean generation_results__failed
string generation_results__run_id
float generation_results__message_count
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
WEEK_SCHEDULES }o--|| SHORT_TERM_FORECASTS : short_term_forecast__id
AGENT_SCHEDULES }o--|| WEEK_SCHEDULES : schedule_id
BU_AGENT_SCHEDULES }o--|| WEEK_SCHEDULES : schedule_id
INTRADAY }o--|| WEEK_SCHEDULES : schedule__id
SCHEDULING_RUNS }o--|| WEEK_SCHEDULES : schedule__id