Automatic Calculation of FTE Values for Workers

The full-time equivalent (FTE) value is the result of dividing assignment working hours by standard working hours, which are typically those of a full-time worker.

For example, if the assignment working hours are 10 and the standard working hours are 40, then the FTE value is 0.25. When you edit assignment working hours in the user interface, FTE is calculated automatically. When you load assignment records using HCM Data Loader, you can specify FTE values on the Assignment Work Measure component. Alternatively, you can request that FTE values be calculated automatically. This topic describes how to request automatic calculation of FTE values.

Calculating FTE Values Automatically

To request automatic calculation of FTE values for all assignments in a Worker.dat file, include the following SET instruction in the file:

SET CALCULATE_FTE Y 

When you include this instruction, the following rules apply:

  • You must not include an Assignment Work Measure component for the assignment in the Worker.dat file.

  • No more than one assignment work measure record can exist for the assignment in Oracle HCM Cloud.

  • Both assignment working hours and standard working hours must exist for the assignment throughout the relevant time period. Otherwise, no calculation of FTE values occurs for the assignment.

You may find automatic calculation of FTE values helpful if:

  • You're loading many assignment records that include assignment working hours.

  • You aren't loading FTE values in the Assignment Work Measure component.

By including the SET CALCULATE_FTE Y instruction in the .dat file, you can generate FTE values for all of the assignments.

Tip: You can perform a data load with the sole purpose of calculating FTE values. Simply include the user keys of the assignments in a Worker.dat file that includes the SET CALCULATE_FTE Y instruction.

The SET CALCULATE_FTE Y instruction generates FTE values only. It doesn't generate headcount values.