Splitting Ordinary Time into three Valuations

[AoifeTFX]

Hi there,

We are pretty new to Time Sheet and Time Valuations, still very much learning. We have a scenario where we need to be able to split up the overall clocked in hours into three possible valuation groups:

• Ordinary Time - should equate to the planned hours for an employee based on their work schedule

• Time Off In Lieu (TOIL) - time recorded outside Ordinary time should be converted to TOIL – up to 29 mins. 

• Overtime: After 30 mins, the employee becomes eligible for paid overtime, for those first 30 mins (which should now no longer be converted to TOIL) and for every 15 minute increment after that. Any recorded minutes that do not fill a 15 minute increment are to be valuated as TOIL instead.

Please see different examples of scenarios below on how we are wanting to split the valuation up.

Clock In / Clock Out –  Paid overtime (After 30 Mins)
Example A : Scheduled Planned Hours 7.45 (ACTUALLY worked -  8.14)
7.45 Ordinary Time
29 Min TOIL

Example B: Scheduled Planned Hours 7.45 (ACTUALLY worked 8.44)
7.45 Ordinary Time
45 Min Paid Overtime
14 Min TOIL

Example C: Scheduled Planned Hours 7.45 (ACTUALLY worked 8.45)
7.45 Ordinary Time
1 Hour Paid Overtime

Example D : Scheduled Planned Hours 7.45 (ACTUALLY worked 8.46)
7.45 Ordinary Time
1 Hour Paid Overtime
1 Min TOIL 

We are trying to understand if this configuration is possible. If so, is it possibly rules we need to look at and what parameters should we be using?

Kind Regards,

Aoife

[Volker_Ruof]

Hello Aiofe,

the requirement is pretty straight forward and can be covered with a few time valuations - except the 15 min increments. This is possible, but as far as I remember you need a big chain of time valuations. Not quite sure, but I think a blog exists on that. 

And for the normal splitting after 30 minutes: investigate on the route time valuation type.  Do you know this blog where all the time valuation types are explained in more detail with examples?

https://community.sap.com/t5/human-capital-management-blogs-by-sap/how-to-setup-time-evaluation-in-t... 

I would have a look onto the "route" time valuation types. This works like an if clause. You can first check if the time outside of planned time is bigger than 29 minutes and then post to Toil.

Volker

[AoifeTFX]

Hi Volker,

Thank you for the response.

We are currently reviewing your suggestion above.

Kind Regards,

Aoife

[NaveenR]

HI @Volker_Ruof - Using the route time evaluation types here, once the Planned time > 29 mins, we can split it between TOIL and Overtime. However, is there a (automated) way for the system to process this logic recursively with 15 minute increments? As you mentioned, we could leverage the Route Evaluation type to selectively split them up via multiple time evaluations but is there a way to kind of loop through this logic until all of the Worked time is evaluated?

[Volker_Ruof]

@Naveen: Please have a look into the new capabilities of business rules in time valuation. I am pretty sure that it can cover the requirement with combination of the route time valuation type. Either you use the route function or the decision rule to find out if a time type group is above or below 30. And with the calcualation business rule you can use the modulo functionality and divide by 15...you need maybe a bit creativity and play around, but as mentioned, think this can be covered. Check my last release blog where I described the business rules for time valuation. The new one will be released in a couple of days where I wrote again a bit on it, cause we gonna make it to general availability with the H2 release.