Employee Job Interface field specification

This table lists the field-column specifications of the Employee Job 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	JOB_NAME*	Varchar2	40	Identifies the employee job.
3	EMPJOB_RATE_INDEX*	Number	22	The job rate index. The default is 0.
4	EMPJOB_RATE*	Number	22	The job rate. The default is 0.
5	START_DATE*	Date	MM/DD/YYYY	Specifies the start date of the employee's job assignment.
6	END_DATE*	Date	MM/DD/YYYY	Specifies the end date of the employee's job assignment.
7	ADJ_START_DATE	Date	MM/DD/YYYY	Specifies the adjusted start date of the employee's job assignment.
8	ADJ_END_DATE	Date	MM/DD/YYYY	Specifies the adjusted end date of the employee's job assignment.
9	ACTION*			Specifies the action: ADD, UPDATE, or DELETE. See Employee Job Import Interface logic.
10	EMPJOB_PREFERRED	Varchar2	1	This distinguishes between preferred and non-preferred jobs. Defaults to null in database.
11	EMPJOB_WORKASSIGNMENT	Number	22	This field can be used by any source system to reference their own job assignments. This is primarily used for integrating with Infor HR Talent.
12	EMPJOB_FLAG	Varchar2	5	This is a string of employee job flags 1 to 5.
13	EMPJOB_UDF1	Varchar2	200	Employee job UDF 1
14	EMPJOB_UDF2	Varchar2	200	Employee job UDF 2
15	EMPJOB_UDF3	Varchar2	200	Employee job UDF 3
16	EMPJOB_UDF4	Varchar2	200	Employee job UDF 4
17	EMPJOB_UDF5	Varchar2	200	Employee job UDF 5