Staffing requirements for volume workloads field specifications
These tables show the field specifications for volume workloads.
Fields with the asterisk (*) symbol are required.
Volume workload
This table shows the field specifications for the volume workload table SO_VOLUME_WORKLOAD.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | Import_type* | Varchar2 | 3 |
Use DRV for Driver. 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:
|
| 2 | SKDGRP_ID* | Varchar2 | 22 |
Location name.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 3 | DIST_ID* | Varchar2 | 22 | Distribution Name. |
| 4 | WRKLD_STDVOL_HOUR* | Varchar2 | 22 | Volume per hour or volume per day.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 5 | WRKLD_DESC* | Varchar2 | 100 | Workload Description.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 6 | WRKLD_FLAG1 | Char | 1 | One-character flag for general use. |
| 7 | WRKLD_FLAG2 | Char | 1 | One-character flag for general use. |
| 8 | WRKLD_FLAG3 | Char | 1 | One-character flag for general use. |
| 9 | WRKLD_FLAG4 | Char | 1 | One-character flag for general use. |
| 10 | WRKLD_FLAG5 | Char | 1 | One-character flag for general use. |
| 11 | WRKLD_UDF1 | Varchar2 | 40 | User defined field. |
| 12 | WRKLD_UDF2 | Varchar2 | 40 | User defined field. |
| 13 | WRKLD_UDF3 | Varchar2 | 40 | User defined field. |
| 14 | WRKLD_UDF4 | Varchar2 | 40 | User defined field. |
| 15 | WRKLD_UDF5 | Varchar2 | 40 | User defined field. |
| 16 | Varchar2 | 10 |
Action. This value determines the action for the import. The values for this field are:
|
Volume workload productivity time
This table shows the field specifications for the volume workload table SO_VOLWRKLD_PROD_TIME_OVR.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | Import_type* | Varchar2 | 5 |
Use PRODT for Productivity Time. 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:
|
| 2 | TPODTL_DAY_ID* | Number | 22 | Day of the week.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 3 | TPODTL_START_TIME* | Date | 7 | Start time.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 4 | TPODTL_END_TIME* | Date | 7 | End time.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 5 | TPODTL_STDVOL_HOUR* | Number | 22 | Volume per hour or volume per day.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 6 | Varchar2 | 10 |
Action. This value determines the action for the import. The values for this field are:
|
Volume workload productivity volume
This table shows the field specifications for the volume workload table SO_VOLWRKLD_PROD_VOL_OVR.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | Import_type* | Varchar2 | 5 |
Use PRODV for Productivity Volume. 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:
|
| 2 | VPODTL_VOL_FROM* | Number | 22 | Volume from.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 3 | VPODTL_VOL_TO* | Number | 22 | Volume to.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 4 | VPODTL_STDVOL_HOUR* | Number | 22 | Volume per hour or volume per day.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 5 | Varchar2 | 10 |
Action This value determines the action for the import. The values for this field are:
|
Volume workload distribution
This table shows the field specifications for the volume workload table SO_VOLUME_DIST_OVR.
| 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:
|
| 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:
|
Volume Interval
This table shows the field specifications for the volume workload table SO_INTERVAL_OVER.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | Import_type* | Varchar2 | 3 |
Use INT for Volume interval. 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:
|
| 2 | INTOVR_DAY_APPLIES | Number | 22 | Day. |
| 3 | INTOVR_START_TIME* | Date | 7 | Start time.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 4 | INTOVR_END_TIME* | Date | 7 | End time.
Note: While the data default is null, this value is required because this field is non-nullable.
|
| 5 | INTOVR_MIN_REQ | Number | 22 | Minimum required. |
| 6 | Varchar2 | 10 |
Action This value determines the action for the import. The values for this field are:
|