Employee data element definitions

This table describes the default employee data elements provided by Infor. For more in-depth definitions that outline the options and limitations for data elements, see Detailed 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.
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.

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 Ming.le 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.

Wbu_Name String 40 User name.

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".