External Workload Feed and the SO_PLAN_WORKLOAD database table

Schedules created for locations using the External Workload Feed forecast method have their interval requirements determined by the workload data recorded in the SO_PLAN_WORKLOAD database table.

The workload data is imported by an external system for each department daily, and distributed evenly across the department’s hours of operation. Forecast generation is not required because the forecast data is already provided.

The Historical data is contained within sub-locations for this location check box on the Locations Properties page must not be selected to generate data for a department. If you select the check box, you will generate data for the driver instead.

You must specify the same Forecast Interval Type for all locations and its sub-locations (that is, the department and its drivers).

For the External Workload Feed to function properly, you must provide at least 1 record for each Forecast Interval for a 24 hour period.

For example, if you specify a Forecast Interval of 15 minutes, you must provide at least 1 record for each 15 minute interval. Therefore, for a 24 hour period, you must provide at least 96 records in total (4 records per hour x 24 hours = 96). Similarly, if you specify an interval of 30 minutes, you must provide at least 1 record for each 30 minute interval, and therefore, at least 48 records in total (2 records per hour X 24 hours = 48).