Work Summary Import Interface field specification

This table lists the field-column specifications of the Work Summary Import Interface. Fields with the asterisk symbol (*) are required.

Col.	Field Name	Type	Size/Format	Description
1	EMP_NAME*	Varchar2	40	Identifies the employee.
2	WORK_DATE*	Date	YYYYMMDD	Specifies the work date of the Work Summary Import detail.
3	OVERRIDE_TYPE*	Numeric	The digits 300-399. Negative numbers are not allowed.	Specifies the override type for the Work Summary Import detail. The numeric value provided 300-399 should correspond with the configured override type numeric value in WFM.
4	WRKS_ERROR	Varchar2	1000	Specifies the error message for the work summary override that is displayed on the timesheet.
5	WRKS_ERROR_STATUS	Yes / No	Y / N	Flag to generate an error on the timesheet day. If null, then do not change existing error status.
6	WRKS_AUTHORIZED	Yes / No	Y / N	Flag to authorize or unauthorize the timesheet day. If null, then do not change existing authorized state.
7	WRKS_MESSAGES	Varchar2	1000	Specifies the work summary override message that is displayed on the timesheet.
8	WRKS_COMMENTS	Varchar2	1000	Specifies the comment for the work summary override that is displayed on the timesheet.
9	CALCGRP_NAME	Varchar2	40	Specifies the calculation group name for the work summary override.
10-19	WRKS_UDF[1..10]	Varchar2	40	User defined fields. Use a space character in the field position to indicate no processing is to be done for that field. An ampersand (&) in the field position indicates the field is to be blanked.
20-24	WRKS_FLAG[1..5]	Varchar2	40	User defined flags. Use a space character in the flag position to indicate no processing is to be done for that flag. An ampersand (&) in the flag position indicates the flag is to be blanked.