You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Average FTE

edited May 10, 2019 12:36AM in Human Capital Management 1 comment

Summary

Is there a standard way to retrieve average FTE over a period of time?

Content

I have a requirement to calculate the average FTE for an employee between two dates. Can you please advise if this functionality exist in system, if not where we could possibly develop it (using groovy or SQL in a DFF) or create a function to be called via a fast formula where I pass a person, start date and end date?

Below I have mapped out the scenario with requirements:

Period Start: 01/07/2018

Period End: 30/06/2019

I need to select all assignments for an employee during this period, standard working hours, working hours, effective from date and effective to date. There are 4 (main) scenarios that are relevant to selecting an employee’s assignment.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!