Forecast Driver Import field specifications

This table lists the field-column specifications in the Forecast Driver import interface. Fields marked with an asterisk (*) are required.

Col. Field Name Type Size/Format Description
1/A Action* Specify an action for the imported forecast driver information. You can select among ADD, UPDATE, or DELETE
2/B Driver* Varchar 40 Specify a unique driver name. An error is displayed if you specify an invalid or non-existing value in this field.
3/C Description Varchar 100 Specify a description for the forecast driver.
4/D Team* Number 8 The team ID number from the WORKBRAIN_TEAM table. An error is displayed if you specify an invalid or non-existing value in this field.
5/E Driver Type* Number 8 The forecast driver type ID number from the FORECAST_DRIVER_TYPE table. An error is displayed if you specify an invalid or non-existing value in this field.
6/F Granularity Interval* Number 8 The forecast granularity ID number from the FORECAST_GRANULARITY table. An error is displayed if you specify an invalid or non-existing value in this field.
7/G Facility Sector* Number 8 The facility sector ID from the FORECAST_FACILITY table. An error is displayed if you specify an invalid or non-existing value in this field.
8/H Calculation Method* Varchar 40 This value is local to the driver. Specify calculation method for the forecast driver. Select between Aggregation or Average. If left blank, the default value is Aggregation.
9/I Category* Varchar 40
When specified, related driver categories are grouped into the same category group. Select from these options:
  • Overtime
  • Census
  • Vacant Shifts
  • Other out of box or custom values

This field is blank by default.
10/J Data Source Number 8 The data source ID from the FORECAST_DRIVER_QUERY_SOURCE table.

If left blank, it is assumed that Historical Data Import is used to import data to the forecasting engine.
11/K Generate Events Char 1 Specify Y or N. If left blank, the default value is N and insights are not generated. If you enable this field, insights are automatically generated for the driver upon relevant forecast data or data update.
12/L FSDR_FLAG1 Char 1 One-character flag for general use.
13/M FSDR_FLAG2 Char 1 One-character flag for general use.
14/N FSDR_FLAG3 Char 1 One-character flag for general use.
15/O FSDR_FLAG4 Char 1 One-character flag for general use.
16/P FSDR_FLAG5 Char 1 One-character flag for general use.
17/Q FSDR_UDF1 Varchar 40 User defined field.
18/R FSDR_UDF2 Varchar 40 User defined field.
19/S FSDR_UDF3 Varchar 40 User defined field.
20/T FSDR_UDF4 Varchar 40 User defined field.
21/U FSDR_UDF5 Varchar 40 User defined field.