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: STF: Staffing Requirement DRV: Driver DIST: Distribution PRODV: Productivity Volume PRODT: Productivity Time INT: Volume interval
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: ADD UPDATE DELETE Blank (for child record manipulation)

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: STF: Staffing Requirement DRV: Driver DIST: Distribution PRODV: Productivity Volume PRODT: Productivity Time INT: Volume interval
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: ADD UPDATE DELETE

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: STF: Staffing Requirement DRV: Driver DIST: Distribution PRODV: Productivity Volume PRODT: Productivity Time INT: Volume interval
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: ADD UPDATE DELETE

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: 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

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: STF: Staffing Requirement DRV: Driver DIST: Distribution PRODV: Productivity Volume PRODT: Productivity Time INT: Volume interval
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: ADD UPDATE DELETE