Employee data element definitions

Field Name	Type	Size/ Format	Description
Calcgrp_Name	String	40	Calculation group factor string. The factors are separated by tilde (`~`) symbols and map to a calculation group. Up to ten factors can be used to map to a single calculation group. This import value must be filled if the import value is creating a new record. Do not process if the import value is `{empty}` and is writing to an existing record. See Field mappings.
Default_Timesheet	String	10	Assigns/updates an employee's default timesheet type. The type can be set to either Daily or Weekly. The assignments are to be effective based on the OVR_START_DATE value. Timesheet type and effective dates are provided in the import file. Employees are not assigned a timesheet type if the column in the import file is blank. If the data provided is invalid, an "Invalid timesheet type" exception is raised. Valid values for this field are Daily or Weekly
Default_Timezone	String	10	Assigns/updates an employee time zone setting. The time zone string is resolved against the TIMEZONE table. If the column in the import file is blank, the employee is assigned to a time zone of "None". If the data provided does not match a time zone that has been defined in the TIMEZONE table, a "Time Zone not found" exception is raised. To assign an employee's time zone, specify the Java time zone name (TZ_JAVA_NAME) in this field. For example, America/New York or Canada/Eastern.
Embal_Delta	Number	10	Employee balance. Embal_Delta1 to Embal_Delta10 are used to change or cancel employee balances. See Effective dating. Do not process if the import value is {empty}. See Employee balances.
Emp_Base_Rate	Number	20	Base pay rate. Defaults to 0.00 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Birth_Date	Date	MM/DD/YYYY	Birth date. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Day_Start_Time	Date	MM/DD/YYYY	Day start time. Defaults to 00:00 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Def_Lab	Varchar2	200	Employee default labor allocation. The import value has this format: `{percentage}~{docket}~{hour type}~{job}~{time code}~{project}~{department}` Do not process if the import value is {empty}. See Default labor allocation.
Emp_Def_Minutes and Emp_Retail_Avail	Varchar2	22 / minutes~ mode	Default shift length and employee retail mode. String format: `Emp_Def_Minutes~Emp_Retail_Avail` Example: `500~Y` Emp_Def_Minutes defaults to 480 (minutes) if the import value is {empty} and is creating a new record. Emp_Retail_Avail is Y for Schedule Optimization. This field is not processed if the import value is {empty} and is writing to an existing record.
Emp_Effective_Date	Date	MM/DD/YYYY	Employee's effective date. This field is optional. When the USE_EMPLOYEE_EFFECTIVE_DATE registry is enabled, this behavior is applied: When creating an employee, the employee's effective date is set to the value in this field. If this field is left blank, the value provided in the Ovr_Start_Date field is used as the employee's effective date. When updating an employee: If the value provided in this field is before the employee's existing effective date, the employee's effective date is updated with the new value. If the value provided in this field is on or after the employee's existing effective date, the value is ignored. The employee's effective date cannot be changed to a future date. If this field is left blank and the new Ovr_Start_Date is before the employee's existing effective date, then the employee's effective date is updated with the Ovr_Start_Date value. If this field is left blank and the new Ovr_Start_Date is on or after the employee's existing effective date, then the employee's effective date is not updated. When the USE_EMPLOYEE_EFFECTIVE_DATE registry is disabled, this behavior is applied: When creating an employee, the value provided in the Ovr_Create_Date field is used as the employee's effective date. Any value provided in this field is ignored. When updating an employee, the employee's effective date cannot be changed. Any value provided in this field is ignored. See "USE_EMPLOYEE_EFFECTIVE_DATE" in the Infor Workforce Management Registry Parameter Reference Guide.
Emp_Firstname	Varchar2	40	Employee first name. This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Flag[1..20]	Varchar2	20	Flag string. 20 one-character flags for general use. A `{space}` in one of the flag positions indicates no processing is to be done for that flag. An ampersand (`&`) in one of the flag positions indicates the flag is to be "blanked". See Employee flags.
Emp_Fte	Number	22	Employee Full Time Equivalent. A numerical value representing the full time equivalent of an employee. For example, an employee with 1.0 FTE could represent a full-time worker, whereas an employee with 0.5 FTE represents a half-time worker. Defaults to 0 if the import value is {empty} and is creating a new record.
Emp_Fullname	String	80	This field is optional and must be manually added to your interface layout. You must also fully implement the configuration of EMP_FULLNAME to use this field in your interface layout. See EMP_FULLNAME field configuration overview for more information and implementation details. After implementing the configuration of EMP_FULLNAME in your environment: This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Fulltime			Assigns and updates an employee's full-time status flag. If the flag is not set, the assumption is that the employee is a part-timer. The column accepts these values: Y, N, &. Y = full time, N = part time, and & resets the flag.
Emp_Hire_Date	Date	MM/DD/YYYY	Hire date. Defaults to the system date if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Job	Varchar2	200	Employee job. The import value contains a list of job codes separated by tilde (`~`) symbols, representing the skills that an employee is capable of performing. Do not process if the import value is {empty}. See Jobs.
Emp_Job_Level	Varchar2	200	Employee job rate level. The import value contains a list of job rate levels separated by tilde (`~`) symbols, corresponding to the job list specified in Emp_Job. The number of job rate levels matches the number of jobs listed in Emp_Job. Otherwise, the entire record is rejected and an error message is generated. See Job rate indices.
Emp_Job_Preferred	Varchar2	200	Designates an employee's preferred job. If the employee is not currently assigned the specified job, the import will assign the job to the employee for the period being imported and flag the job as preferred. If the employee is already assigned the specified job, the assignment will be updated to include the preferred flag for the period being imported. If another job is already flagged as preferred, the job specified in this field will become preferred and the other job will no longer be flagged as preferred for the period being imported. If this field is left blank, then the employee's existing preferred job, if any, will remain unchanged. To remove the employee's existing preferred job, specify an ampersand (&) in this field. This will ensure that the employee has no preferred jobs for the period being imported.
Emp_Job_Work_Assignment	Varchar2	1000	The work assignment number of the employee job. The work assignment number field is reserved to be used in integrations between Infor HR Talent and Workforce Management. The import value contains a list of employee job work assignment numbers separated by tilde (~) symbols, corresponding to the job list specified in Emp_Job. The number of employee job work assignment numbers must match the number of jobs listed in Emp_Job. Otherwise, the entire record is rejected and an error message is generated. If the import field is empty, work assignment numbers are not assigned to the jobs listed in Emp_Job. The work assignment numbers are defaulted to null.
Emp_Lastname	Varchar2	40	Employee last name. This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Name*	Varchar2	40	Employee identification. This import value must always be filled. Placing this data element in the 3/C column is mandatory.
Emp_Reader_Group	Varchar2	10	Adds/removes a reader group assignment for an employee. Reader groups are used by the system to grant employees access to a set of clock readers that have been deployed within the organization. The import value has this format: `reader group 1~reader group 2~reader group 3` Employee reader group assignments are not effective dated. See Employee reader group assignments
Emp_Seniority_Date	Date	MM/DD/YYYY	Seniority date. Default to system date if the import value is `{empty}` and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Seniority_Number	Number	10	The employee's seniority rank amongst all the company's employees.
Emp_Shftpat_Offset	Number	22	Shift pattern offset. Employees start day in a cyclical shift pattern. Defaults to 0 if the import value is `{empty}` and is creating a new record. Do not process if the import value is `{empty}` and is writing to an existing record.
Emp_SIN	Varchar2	40	Employee ID. This import value must be filled if a new record is being created. Do not process if the import value is `{empty}` and is writing to an existing record.
Emp_Skill	Varchar	200	Name of the skill. The import value contains a list of skill codes separated by tilde (~) symbols, representing the skills that an employee is capable of performing. Do not process if the import value is {empty}. Each skill name can be up to 40 characters.
Emp_Skill_Type	Varchar	200	Skill type name. The import value contains a list of skill type codes separated by tilde (`~`) symbols, corresponding to the skills list specified in Emp_Skill. Do not process if the import value is {empty}. The number of skill types should match the number of skills listed in Emp_Skill. Otherwise, the entire record is rejected and an error message is generated. Each skill type can be up to 40 characters.
Emp_Skill_Weight	Integer	40	A skill weight value. The import value contains a list of skill weight codes separated by tilde (`~`) symbols, corresponding to the skills list specified in Emp_Skill. The number of skill weights should match the number of skills listed in Emp_Skill. Otherwise, the entire record is rejected and an error message is generated. Each skill weight can be up to 4 characters. The default value is 0.
EMP_SYSTEM_SCHEDULING_ENABLED	String	1	Specifies the default value for the `EMP_SYSTEM_SCHEDULING_ENABLED` column. The `EMP_SYSTEM_SCHEDULING_ENABLED` column controls the default value for the System Scheduling Enabled field in the employee record. The System Scheduling Enabled field determines whether the employee will be auto-scheduled in the scheduling module that is being used, either LFSO or MVS. For details on how to change this field directly in the employee record, see "Viewing employee details" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.
Emp_Status	Varchar2	1	Employee status. Defaults to A if the import value is {empty} and is creating a new record. Do not process if the import value is `{empty}` and is writing to an existing record.
Emp_Termination_Date	Date	MM/DD/YYYY	Termination date. Defaults to 01/01/3000 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record. See Termination date.
Emp_UDF_Data	Varchar2	100	User defined field (UDF). The import value has the value only. If you are importing data for a defined ADDRESS employee data field, the imported data should contain only the actual address value (for example, 641 Avenue of the Americas, New York, NY, 10011). Do not process if the import value is `{empty}`. See Employee User Defined Fields (UDFs).
Emp_Val1	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val2	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val3	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val4	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val5	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val6	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val7	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val8	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val9	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val10	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val11	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val12	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val13	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Va14	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val15	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val16	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val17	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val18	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val19	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Emp_Val20	Varchar2	40	Free field. An ampersand (`&`) indicates the field is to be "blanked". User defined, do not process if the import value is `{empty}`.
Empbdg_Badge_Number and Wbu_Badge_Number	Varchar2	40	Employee badge number. Do not process if the import value is `{empty}`. See Employee badges.
EMP_BADGE_PIN	Number	1000	Employe badge number PIN. This field is optional. See Employee badge PIN.
EmpJob_Rank	String	1000	Employee job rank. The import value contains a list of job rank indices separated by tilde (`~`) symbols, corresponding to the job list specified in EMP_JOB. The number of job rank indices should match the number of jobs listed in EMP_JOB. Otherwise, the entire record is rejected and an error message is generated. See Job rank indices.
Empt_Hierarchy	String	1000	Team hash string. Defaults to Unassigned Team if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record. The Employee Team field (Empt_Hierarchy) is handled in one of these ways, depending on the format of the input value If the field has a single input value such as team A, team A is assigned to the employee as their home team. If the field input value was in the format `~Team1~Team2~…~TeamN`, the employee is assigned `TeamN`. Upon termination, employees (those employees assigned a termination date other than 1/1/3000) is put into a TERMINATED TEAM with a date range of `{termination date}` to 1/1/3000. This automatically removes the employee from hierarchy visibility for terminated dates. If the value of this field does not match an existing team, the record is marked with an error.
Emptyp_name	String	40	Employment type name. Indicates the type of employment relationship an employee has with the employer. The system provides a default list of employment types that includes EMPLOYEE, CONTRACTOR, SEASONAL, INTERN, and TRAINEE. A pre-defined list of employment types is available in the EMPLOYMENT_TYPE table and is referenced in the Employee Interface. Do not process if the import value is {empty}.
Empwrktyp_Name	String	40	Work type name. A more granular classification of Emp_Fulltime that indicates the work nature of the employment. The system provides a default list of work types that includes FULL TIME, PART TIME, CASUAL, and FLEX. A pre-defined list of work types is available in the EMPLOYEE_WORK_TYPE table and is referenced in the Employee Interface. Do not process if the import value is {empty}.
Ent_Policy	String	1000	Entitlement policy name or factor string. The input value supports these options: No field mapping More than one policy can be supplied by using the tilde (`~`) symbol. For example, `POLICY1~POLICY2`. Default entitlement policy mapping Only one policy can be passed in, which matches policy name. The default mapping definition (Default Entitlement Policy Mapping) must be selected for this field in the employee layout. See Field mappings. Custom policy mapping Can match multiple policies separated by a pipe (\|) symbol, where each policy is assigned by matching external fields (factors) separated by tilde (~) symbols. Up to 10 factors can be used to map to a single entitlement policy. For example, `(CA~EXEMPT~FULLTIME~\|CA~EXEMPT~PARTTIME~)`. The custom mapping definition must be selected for this field in the employee layout. See Field mappings. Do not process if the import value is {empty}. See Overlapping entitlement policy assignments.
Ovr_End_Date	Date	MM/DD/YYYY	Effective end date. End of effective period. Defaults to 01/01/3000 if the import value is {empty}. This data element must be placed in the 2/B column. See Effective dating.
Ovr_Start_Date	Date	MM/DD/YYYY	Effective start date. Start of effective period. Defaults to the system date if the import value is {empty}. Placing this data element in the 1/A column is mandatory. See Effective dating.
Paygrp_Name	String	40	Pay group factor string. The factors are separated by tilde (~) symbols and map to a payroll group. Up to ten factors can be used to map to a single payroll group. Defaults to 0 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record. See Field mappings.
SEMP_DAYMAX_HRS	Number	20	Maximum hours per day.
SEMP_EFF_DATE	Date	10	Effective date of the employee's schedule settings.
SEMP_EXEMPT_STAT	Number	1	The employee's exempt status (H=Hourly and M=Management).
SEMP_IS_MINOR	Number	1	Indicates if the employee is a minor (0=No and 1=Yes).
SEMP_IS_SALARY	Number	1	Indicates if the employee is salaried (0=No and 1=Yes).
SEMP_ ISKEYHOLDER	Number	1	Indicates if the employee holds keys to the location (0=No and 1=Yes).
SEMP_MAX2NT_RULE	Number	1	Indicates whether the maximum 2 nights per week rule will be applied (0 = No, 1 = Yes).
SEMP_MAXSHFTDAY	Number	1	Indicates whether the maximum number of shifts per day rule will be applied (0 = No, 1 = Yes).
SEMP_ONFIXED_SKD	Number 1		Indicates whether the employee is on a fixed schedule (0 = None, 1 = Only, 2 = Partial).
SEMP_SEASONAL_REG	Number	1	Indicates whether the employee is a regular employee or a seasonal employee (R=Regular and S=Seasonal).
SEMP_SHFTMIN_HRS	Number	20	Minimum hours per shift.
SEMP_SKDMAX_HRS	Number	20	Maximum hours per schedule.
SEMP_SKDMIN_HRS	Number	20	Minimum hours per schedule.
SEMP_X_IN_DATE	Date	10	Currently unused.
SEMP_X_OUT_DATE	Date	10	Currently unused.
Shftpat_Name	String	40	Shift pattern factor string. The factors are separated by tilde (`~`) symbols and that map to a shift pattern. Up to ten factors can be used to map to a single shift pattern. Defaults to NULL - ALL OFFS if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record. See Field mappings.
Team			The name of the team to which the employee belongs.
Team_Desc	String	10	Updates the description of teams according to employee roles. Team description changes are triggered by employee role changes.
User_Role	String	10	Assigns a set of roles associated with an employee(s) and updates the description of teams (see Team_Desc) in which an employee occupies a role. Role assignments are effective dated using the OVR_START_DATE and OVR_END_DATE fields. The input value has this format: `Team Name 1~Role Name 1~Action 1\|Team Name 2~ Role Name 2~ Action 2\| Team Name N~ Role Name N~ Action N.` The available actions are ADD, UPDATE, and DELETE. See User roles.
User_Status	String	10	Updates the account status of employees. Specify I for Inactive and A for Active.
Wbg_ID	Number	10	Security group factor string. The factors are separated by tilde (~) symbols and map to a security group. Up to ten factors can be used to map to a single security group. Do not process if the import value is {empty}. This data definition is inactivated by default. See Field mappings.
Wbll_ID	Varchar2	40	Language locale. Defaults to ENGLISH if the import value is `{empty}` and is creating a new record. Do not process if the import value is `{empty}` and is writing to an existing record.
Wbu_Can_Proxy	Char	1	Indicates whether the user can proxy to other users.
Wbu_Cansee_Self	Char	1	Indicates whether the user can see their own timesheet and themselves in general throughout the Workforce Management application.
Wbu_Email	Varchar2	100	E-mail address. Do not process if the import value is {empty}.
Wbu_Flag[1..10]	Varchar	1	User defined flag string. 10 one-character flags for general use. A `{space}` in one of the flag positions indicates no processing is to be done for that flag. An ampersand (`&`) in one of the flag position indicates the flag is to be 'blanked'. See User flags.
Wbu_Identity2	String	100	This optional field contains the global user identity string (GUID), which is shared across all products in Infor CloudSuite. Infor OS Portal will pass this value to Workforce Management during login so that the user is uniquely identified across the system.
Wbu_Ip	Varchar	100	If populated, this field will restrict access to the system for this IP only.
Wbu_Is_Power	Char	1	In general, a power user means that the user has access to the first three levels of the team security hierarchy in an environment with more than 30,000 employees. For more information, see "System security" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.
Wbu_Name	String	40	User name. When WFM and HRT are integrated, the Wbu_Name field must be the ActorID from Infor HR Talent. If the import value is `{empty}`, do not process this and the next six (6) field columns: Wbu_Password Wbu_Email Wbll_ID Wbg_ID Wbu_Pwd_Changed_Date Wbu_Identity2
Wbu_Password	String	100	Password. Defaults to the Employee ID (Emp_SIN) if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Wbu_Pwd_Changed_Date	Date	MM/DD/YYYY	Password change date. Default to 1/1/1900 if the import value is {empty} and is creating a new record. This ensures passwords for new users are expired upon initial login. If the user already exists in the system, the password will not expire.
Wbu_Udf1	Varchar	100	User defined, do not process if the import value is `{empty}`. An ampersand (`&`) indicates the field is to be "blanked".
Wbu_Udf2	Varchar	100	User defined, do not process if the import value is `{empty}`. An ampersand (`&`) indicates the field is to be "blanked".
Wbu_Udf3	Varchar	100	User defined, do not process if the import value is `{empty}`. An ampersand (`&`) indicates the field is to be "blanked".
Wbu_Udf4	Varchar	100	User defined, do not process if the import value is `{empty}`. An ampersand (`&`) indicates the field is to be "blanked".
Wbu_Udf5	Varchar	100	User defined, do not process if the import value is `{empty}`. An ampersand (`&`) indicates the field is to be "blanked".

Calcgrp_Name

String

40

Calculation group factor string. The factors are separated by tilde (~) symbols and map to a calculation group. Up to ten factors can be used to map to a single calculation group. This import value must be filled if the import value is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

See Field mappings.

Default_Timesheet

String

10

Assigns/updates an employee's default timesheet type. The type can be set to either Daily or Weekly. The assignments are to be effective based on the OVR_START_DATE value.

Timesheet type and effective dates are provided in the import file. Employees are not assigned a timesheet type if the column in the import file is blank. If the data provided is invalid, an "Invalid timesheet type" exception is raised.

Valid values for this field are Daily or Weekly

Default_Timezone

String

10

Assigns/updates an employee time zone setting. The time zone string is resolved against the TIMEZONE table. If the column in the import file is blank, the employee is assigned to a time zone of "None". If the data provided does not match a time zone that has been defined in the TIMEZONE table, a "Time Zone not found" exception is raised.

To assign an employee's time zone, specify the Java time zone name (TZ_JAVA_NAME) in this field. For example, America/New York or Canada/Eastern.

Embal_Delta

Number

10

Employee balance.

Embal_Delta1 to Embal_Delta10 are used to change or cancel employee balances.

See Effective dating.

Do not process if the import value is {empty}.

See Employee balances.

Emp_Base_Rate

Number

20

Base pay rate.

Defaults to 0.00 if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Birth_Date

Date

MM/DD/YYYY

Birth date.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Day_Start_Time

Date

MM/DD/YYYY

Day start time.

Defaults to 00:00 if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Def_Lab

Varchar2

200

Employee default labor allocation.

The import value has this format:

{percentage}~{docket}~{hour type}~{job}~{time code}~{project}~{department}

Do not process if the import value is {empty}.

See Default labor allocation.

Emp_Def_Minutes and Emp_Retail_Avail

Varchar2

22 / minutes~ mode

Default shift length and employee retail mode.

String format:

Emp_Def_Minutes~Emp_Retail_Avail

Example:

500~Y

Emp_Def_Minutes defaults to 480 (minutes) if the import value is {empty} and is creating a new record.

Emp_Retail_Avail is Y for Schedule Optimization.

This field is not processed if the import value is {empty} and is writing to an existing record.

Emp_Effective_Date

Date

MM/DD/YYYY

Employee's effective date. This field is optional.

When the USE_EMPLOYEE_EFFECTIVE_DATE registry is enabled, this behavior is applied:

When creating an employee, the employee's effective date is set to the value in this field. If this field is left blank, the value provided in the Ovr_Start_Date field is used as the employee's effective date.
When updating an employee:
- If the value provided in this field is before the employee's existing effective date, the employee's effective date is updated with the new value.
- If the value provided in this field is on or after the employee's existing effective date, the value is ignored. The employee's effective date cannot be changed to a future date.
- If this field is left blank and the new Ovr_Start_Date is before the employee's existing effective date, then the employee's effective date is updated with the Ovr_Start_Date value.
- If this field is left blank and the new Ovr_Start_Date is on or after the employee's existing effective date, then the employee's effective date is not updated.

When the USE_EMPLOYEE_EFFECTIVE_DATE registry is disabled, this behavior is applied:

When creating an employee, the value provided in the Ovr_Create_Date field is used as the employee's effective date. Any value provided in this field is ignored.
When updating an employee, the employee's effective date cannot be changed. Any value provided in this field is ignored.

See "USE_EMPLOYEE_EFFECTIVE_DATE" in the Infor Workforce Management Registry Parameter Reference Guide.

Emp_Firstname

Varchar2

40

Employee first name.

This import value must be filled if a new record is being created.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Flag[1..20]

Varchar2

20

Flag string.

20 one-character flags for general use.

A {space} in one of the flag positions indicates no processing is to be done for that flag.

An ampersand (&) in one of the flag positions indicates the flag is to be "blanked".

See Employee flags.

Emp_Fte

Number

22

Employee Full Time Equivalent.

A numerical value representing the full time equivalent of an employee. For example, an employee with 1.0 FTE could represent a full-time worker, whereas an employee with 0.5 FTE represents a half-time worker.

Defaults to 0 if the import value is {empty} and is creating a new record.

Emp_Fullname

String

80

This field is optional and must be manually added to your interface layout. You must also fully implement the configuration of EMP_FULLNAME to use this field in your interface layout. See EMP_FULLNAME field configuration overview for more information and implementation details.

After implementing the configuration of EMP_FULLNAME in your environment:

This import value must be filled if a new record is being created.
Do not process if the import value is {empty} and is writing to an existing record.

Emp_Fulltime

Assigns and updates an employee's full-time status flag. If the flag is not set, the assumption is that the employee is a part-timer. The column accepts these values: Y, N, &.

Y = full time, N = part time, and & resets the flag.

Emp_Hire_Date

Date

MM/DD/YYYY

Hire date.

Defaults to the system date if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Job

Varchar2

200

Employee job.

The import value contains a list of job codes separated by tilde (~) symbols, representing the skills that an employee is capable of performing.

Do not process if the import value is {empty}.

See Jobs.

Emp_Job_Level

Varchar2

200

Employee job rate level.

The import value contains a list of job rate levels separated by tilde (~) symbols, corresponding to the job list specified in Emp_Job.

The number of job rate levels matches the number of jobs listed in Emp_Job. Otherwise, the entire record is rejected and an error message is generated.

See Job rate indices.

Emp_Job_Preferred

Varchar2

200

Designates an employee's preferred job.

If the employee is not currently assigned the specified job, the import will assign the job to the employee for the period being imported and flag the job as preferred.

If the employee is already assigned the specified job, the assignment will be updated to include the preferred flag for the period being imported.

If another job is already flagged as preferred, the job specified in this field will become preferred and the other job will no longer be flagged as preferred for the period being imported.

If this field is left blank, then the employee's existing preferred job, if any, will remain unchanged.

To remove the employee's existing preferred job, specify an ampersand (&) in this field. This will ensure that the employee has no preferred jobs for the period being imported.

Emp_Job_Work_Assignment

Varchar2

1000

The work assignment number of the employee job. The work assignment number field is reserved to be used in integrations between Infor HR Talent and Workforce Management.

The import value contains a list of employee job work assignment numbers separated by tilde (~) symbols, corresponding to the job list specified in Emp_Job.

The number of employee job work assignment numbers must match the number of jobs listed in Emp_Job. Otherwise, the entire record is rejected and an error message is generated.

If the import field is empty, work assignment numbers are not assigned to the jobs listed in Emp_Job. The work assignment numbers are defaulted to null.

Emp_Lastname

Varchar2

40

Employee last name.

This import value must be filled if a new record is being created.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Name*

Varchar2

40

Employee identification.

This import value must always be filled. Placing this data element in the 3/C column is mandatory.

Emp_Reader_Group

Varchar2

10

Adds/removes a reader group assignment for an employee. Reader groups are used by the system to grant employees access to a set of clock readers that have been deployed within the organization.

The import value has this format:

reader group 1~reader group 2~reader group 3

Employee reader group assignments are not effective dated.

See Employee reader group assignments

Emp_Seniority_Date

Date

MM/DD/YYYY

Seniority date.

Default to system date if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Seniority_Number

Number

10

The employee's seniority rank amongst all the company's employees.

Emp_Shftpat_Offset

Number

22

Shift pattern offset.

Employees start day in a cyclical shift pattern.

Defaults to 0 if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_SIN

Varchar2

40

Employee ID.

This import value must be filled if a new record is being created.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Skill

Varchar

200

Name of the skill.

The import value contains a list of skill codes separated by tilde (~) symbols, representing the skills that an employee is capable of performing.

Do not process if the import value is {empty}.

Each skill name can be up to 40 characters.

Emp_Skill_Type

Varchar

200

Skill type name.

The import value contains a list of skill type codes separated by tilde (~) symbols, corresponding to the skills list specified in Emp_Skill.

Do not process if the import value is {empty}.

The number of skill types should match the number of skills listed in Emp_Skill. Otherwise, the entire record is rejected and an error message is generated.

Each skill type can be up to 40 characters.

Emp_Skill_Weight

Integer

40

A skill weight value.

The import value contains a list of skill weight codes separated by tilde (~) symbols, corresponding to the skills list specified in Emp_Skill.

The number of skill weights should match the number of skills listed in Emp_Skill. Otherwise, the entire record is rejected and an error message is generated.

Each skill weight can be up to 4 characters. The default value is 0.

EMP_SYSTEM_SCHEDULING_ENABLED

String

1

Specifies the default value for the EMP_SYSTEM_SCHEDULING_ENABLED column. The EMP_SYSTEM_SCHEDULING_ENABLED column controls the default value for the System Scheduling Enabled field in the employee record.

The System Scheduling Enabled field determines whether the employee will be auto-scheduled in the scheduling module that is being used, either LFSO or MVS.

For details on how to change this field directly in the employee record, see "Viewing employee details" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.

Emp_Status

Varchar2

1

Employee status.

Defaults to A if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Emp_Termination_Date

Date

MM/DD/YYYY

Termination date.

Defaults to 01/01/3000 if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

See Termination date.

Emp_UDF_Data

Varchar2

100

User defined field (UDF).

The import value has the value only. If you are importing data for a defined ADDRESS employee data field, the imported data should contain only the actual address value (for example, 641 Avenue of the Americas, New York, NY, 10011).

Do not process if the import value is {empty}.

See Employee User Defined Fields (UDFs).

Emp_Val1

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val2

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val3

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val4

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val5

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val6

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val7

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val8

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val9

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val10

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val11

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val12

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val13

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Va14

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val15

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val16

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val17

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val18

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val19

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Emp_Val20

Varchar2

40

Free field.

An ampersand (&) indicates the field is to be "blanked".

User defined, do not process if the import value is {empty}.

Empbdg_Badge_Number and Wbu_Badge_Number

Varchar2

40

Employee badge number.

Do not process if the import value is {empty}.

See Employee badges.

EMP_BADGE_PIN

Number

1000

Employe badge number PIN. This field is optional.

See Employee badge PIN.

EmpJob_Rank

String

1000

Employee job rank.

The import value contains a list of job rank indices separated by tilde (~) symbols, corresponding to the job list specified in EMP_JOB.

The number of job rank indices should match the number of jobs listed in EMP_JOB.

Otherwise, the entire record is rejected and an error message is generated.

See Job rank indices.

Empt_Hierarchy

String

1000

Team hash string.

Defaults to Unassigned Team if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

The Employee Team field (Empt_Hierarchy) is handled in one of these ways, depending on the format of the input value

If the field has a single input value such as team A, team A is assigned to the employee as their home team.
If the field input value was in the format ~Team1~Team2~…~TeamN, the employee is assigned TeamN.
Upon termination, employees (those employees assigned a termination date other than 1/1/3000) is put into a TERMINATED TEAM with a date range of {termination date} to 1/1/3000. This automatically removes the employee from hierarchy visibility for terminated dates.

If the value of this field does not match an existing team, the record is marked with an error.

Emptyp_name

String

40

Employment type name.

Indicates the type of employment relationship an employee has with the employer. The system provides a default list of employment types that includes EMPLOYEE, CONTRACTOR, SEASONAL, INTERN, and TRAINEE.

A pre-defined list of employment types is available in the EMPLOYMENT_TYPE table and is referenced in the Employee Interface.

Do not process if the import value is {empty}.

Empwrktyp_Name

String

40

Work type name.

A more granular classification of Emp_Fulltime that indicates the work nature of the employment. The system provides a default list of work types that includes FULL TIME, PART TIME, CASUAL, and FLEX.

A pre-defined list of work types is available in the EMPLOYEE_WORK_TYPE table and is referenced in the Employee Interface.

Do not process if the import value is {empty}.

Ent_Policy

String

1000

Entitlement policy name or factor string.

The input value supports these options:

No field mapping
More than one policy can be supplied by using the tilde (~) symbol. For example, POLICY1~POLICY2.
Default entitlement policy mapping
Only one policy can be passed in, which matches policy name.
The default mapping definition (Default Entitlement Policy Mapping) must be selected for this field in the employee layout.
See Field mappings.
Custom policy mapping
Can match multiple policies separated by a pipe (|) symbol, where each policy is assigned by matching external fields (factors) separated by tilde (~) symbols. Up to 10 factors can be used to map to a single entitlement policy. For example, (CA~EXEMPT~FULLTIME~|CA~EXEMPT~PARTTIME~).
The custom mapping definition must be selected for this field in the employee layout.
See Field mappings.

Do not process if the import value is {empty}.

See Overlapping entitlement policy assignments.

Ovr_End_Date

Date

MM/DD/YYYY

Effective end date.

End of effective period. Defaults to 01/01/3000 if the import value is {empty}.

This data element must be placed in the 2/B column.

See Effective dating.

Ovr_Start_Date

Date

MM/DD/YYYY

Effective start date.

Start of effective period. Defaults to the system date if the import value is {empty}.

Placing this data element in the 1/A column is mandatory.

See Effective dating.

Paygrp_Name

String

40

Pay group factor string.

The factors are separated by tilde (~) symbols and map to a payroll group.

Up to ten factors can be used to map to a single payroll group.

Defaults to 0 if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

See Field mappings.

SEMP_DAYMAX_HRS

Number

20

Maximum hours per day.

SEMP_EFF_DATE

Date

10

Effective date of the employee's schedule settings.

SEMP_EXEMPT_STAT

Number

1

The employee's exempt status (H=Hourly and M=Management).

SEMP_IS_MINOR

Number

1

Indicates if the employee is a minor (0=No and 1=Yes).

SEMP_IS_SALARY

Number

1

Indicates if the employee is salaried (0=No and 1=Yes).

SEMP_ ISKEYHOLDER

Number

1

Indicates if the employee holds keys to the location (0=No and 1=Yes).

SEMP_MAX2NT_RULE

Number

1

Indicates whether the maximum 2 nights per week rule will be applied (0 = No, 1 = Yes).

SEMP_MAXSHFTDAY

Number

1

Indicates whether the maximum number of shifts per day rule will be applied (0 = No, 1 = Yes).

SEMP_ONFIXED_SKD

Number 1

Indicates whether the employee is on a fixed schedule (0 = None, 1 = Only, 2 = Partial).

SEMP_SEASONAL_REG

Number

1

Indicates whether the employee is a regular employee or a seasonal employee (R=Regular and S=Seasonal).

SEMP_SHFTMIN_HRS

Number

20

Minimum hours per shift.

SEMP_SKDMAX_HRS

Number

20

Maximum hours per schedule.

SEMP_SKDMIN_HRS

Number

20

Minimum hours per schedule.

SEMP_X_IN_DATE

Date

10

Currently unused.

SEMP_X_OUT_DATE

Date

10

Currently unused.

Shftpat_Name

String

40

Shift pattern factor string.

The factors are separated by tilde (~) symbols and that map to a shift pattern.

Up to ten factors can be used to map to a single shift pattern. Defaults to NULL - ALL OFFS if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

See Field mappings.

Team

The name of the team to which the employee belongs.

Team_Desc

String

10

Updates the description of teams according to employee roles.

Team description changes are triggered by employee role changes.

User_Role

String

10

Assigns a set of roles associated with an employee(s) and updates the description of teams (see Team_Desc) in which an employee occupies a role.

Role assignments are effective dated using the OVR_START_DATE and OVR_END_DATE fields.

The input value has this format:

Team Name 1~Role Name 1~Action 1|Team Name 2~ Role Name 2~ Action 2| Team Name N~ Role Name N~ Action N.

The available actions are ADD, UPDATE, and DELETE.

See User roles.

User_Status

String

10

Updates the account status of employees. Specify I for Inactive and A for Active.

Wbg_ID

Number

10

Security group factor string.

The factors are separated by tilde (~) symbols and map to a security group. Up to ten factors can be used to map to a single security group.

Do not process if the import value is {empty}. This data definition is inactivated by default.

See Field mappings.

Wbll_ID

Varchar2

40

Language locale.

Defaults to ENGLISH if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Wbu_Can_Proxy

Char

1

Indicates whether the user can proxy to other users.

Wbu_Cansee_Self

Char

1

Indicates whether the user can see their own timesheet and themselves in general throughout the Workforce Management application.

Wbu_Email

Varchar2

100

E-mail address.

Do not process if the import value is {empty}.

Wbu_Flag[1..10]

Varchar

1

User defined flag string.

10 one-character flags for general use.

A {space} in one of the flag positions indicates no processing is to be done for that flag.

An ampersand (&) in one of the flag position indicates the flag is to be 'blanked'.

See User flags.

Wbu_Identity2

String

100

This optional field contains the global user identity string (GUID), which is shared across all products in Infor CloudSuite.

Infor OS Portal will pass this value to Workforce Management during login so that the user is uniquely identified across the system.

Wbu_Ip

Varchar

100

If populated, this field will restrict access to the system for this IP only.

Wbu_Is_Power

Char

1

In general, a power user means that the user has access to the first three levels of the team security hierarchy in an environment with more than 30,000 employees.

For more information, see "System security" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.

Wbu_Name

String

40

User name.

When WFM and HRT are integrated, the Wbu_Name field must be the ActorID from Infor HR Talent.

If the import value is {empty}, do not process this and the next six (6) field columns:

Wbu_Password
Wbu_Email
Wbll_ID
Wbg_ID
Wbu_Pwd_Changed_Date
Wbu_Identity2

Wbu_Password

String

100

Password.

Defaults to the Employee ID (Emp_SIN) if the import value is {empty} and is creating a new record.

Do not process if the import value is {empty} and is writing to an existing record.

Wbu_Pwd_Changed_Date

Date

MM/DD/YYYY

Password change date.

Default to 1/1/1900 if the import value is {empty} and is creating a new record. This ensures passwords for new users are expired upon initial login. If the user already exists in the system, the password will not expire.

Wbu_Udf1

Varchar

100

User defined, do not process if the import value is {empty}.

An ampersand (&) indicates the field is to be "blanked".

Wbu_Udf2

Varchar

100

User defined, do not process if the import value is {empty}.

An ampersand (&) indicates the field is to be "blanked".

Wbu_Udf3

Varchar

100

User defined, do not process if the import value is {empty}.

An ampersand (&) indicates the field is to be "blanked".

Wbu_Udf4

Varchar

100

User defined, do not process if the import value is {empty}.

An ampersand (&) indicates the field is to be "blanked".

Wbu_Udf5

Varchar

100

User defined, do not process if the import value is {empty}.

An ampersand (&) indicates the field is to be "blanked".