Staffing requirements for non-volume workloads field specifications

This table shows the field specifications for non-volume workloads table SO_STFDEF_DIST_OVR.

Fields with the asterisk (*) symbol are required.

Col. Field Name Type Size/Format Description
1 Import_type* Varchar2 4

Use DIST for Distribution.

This is used to determine whether the row must be added to Staffing requirements, Driver, or a child table.

Note: This is a required field.

The values for this field are:

  • STF: Staffing Requirement
  • DRV: Driver
  • DIST: Distribution
  • PRODV: Productivity Volume
  • PRODT: Productivity Time
  • INT: Volume interval
2 DIST_ID* Number 22 Distribution name.
Note: While the data default is null, this value is required because this field is non-nullable.
3 VDO_DAY* Number 22 Day.
Note: While the data default is null, this value is required because this field is non-nullable.
4 Varchar2 10

Action.

This value determines the action for the import.

The values for this field are:

  • ADD
  • UPDATE
  • DELETE