2561209 - How to calculate Consecutive days for Time Sheet Weekly Recorders

In some scenarios, special handling of overtime is required when the weekly period time sheet recorder works for 7 consecutive days.

For example, if an employee works from Sunday to Saturday, the overtime for Saturday should be calculated as 3.0. Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

• SAP SuccessFactors HCM Suite
• SAP SuccessFactors Employee Central - Time Sheet
• SAP SuccessFactors HCM Suite

Important Note: 

This is only possible inside the same week, which means that the system won't be able to determine if the employee worked for 7 days consecutively when these days start in a week and ends in another. To validate consecutive days that span across time sheet periods, please refer to KBA 3656773.

To achieve this, the following steps are required:

1. Count the number of days worked. This can be achieved by using the Valuation Type "Compare Threshold with Input Groups and Count Events", see one example as below.

Notes on DAYSWKD valuation:

• • the count event method compares the input with a threshold value or group and will count as 1 event (in the time type group above) whenever that threshold is reached, for example, in the threshold value it is possible to define a minimum number of hours required to consider a day as a working day. In this example here, whenever the employee records more than one hour, then the day will be counted as a working day.
  • the valuation method here must be valuate per day then it will be able to count 1 event per day of the week.
  • it is not mandatory to have the time type group as a time collector but the Time Category of this group must be "Counted Events".
  • for more information about this valuation, please refer to Setting Up Time Valuations for Time Collectors.

Refer below to an image for the group 05DAYSWKD in this example:

      2. Filter the hours recorded for the last day of the week (This depends on how the time sheet week is configured; for more info, refer to Defining the First Day of the Week). To achieve this, time record filters need to be used, as shown in the example below.

1. • Create the Time Record Filter:

• • Create a valuation to separate only Saturday hours:

Notes on SATVAL valuation:

• • The input group here depends on the scenario, in this case the input group is only the overtimes generated during the week.

• • The value that falls under the filter must be sent to the Time Type Group Below.

      3. The times recorded on the last day must be routed to the desired time type group, but this must be done only if the employee worked the 7 days of the week. To achieve this, the valuation type "Compare Threshold with Comparison Group to Route Input" can be used, see below one example on how this valuation can be configured:

 

Notes on OVR3.0 valuation:

• • For this valuation to work, a comparison group is required. This comparison group will be the Time Type Group Above of the valuation explained in the first step (DAYSWKD).
  • The input group here depends on the business need, it corresponds to the filtered Saturday hours (Time Type Group Below of the valuation explained in the second step (SATVAL).
  • The threshold value was set to 6, which means that whenever the 7th day is registered, it will then make the route. This is important because if the employee does not work the 7 days but for some reason does an overtime on Saturday, then this special handling should not happen.

By applying the above steps, special calculations based on consecutive days can be achieved.

KBA 3656773 - Business Rule – How to Validate Employee Consecutive Working Days

Timesheet implementation scenario, consecutive days calculation, weekly, period, consecutive, count, event, counted, week, filter, records , KBA , LOD-SF-EC-TMS , Time Sheet , LOD-SF-TTR , Time Tracking , How To

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Time Tracking all versions