Workstem provides several functions to value schedule time, which is used to calculate salaries. The system provides the following functions:

CountRosterByDay(type)

GetRosterByTime(StartTime ,Endtime)

GetRosterByLocation(location1, location2)

GetRosterByProject(project1, project, project,……)

The following is a detailed description of the function:

Step 1

[Payroll] > [Settings] > [Pay Items] > [Settings].

Step 2

Click [Settings], go to [Pay Items], find the corresponding item that needs to set the formula, click [Formula], or add new item to formula setup step, and go to [Pay Items] formula setting interface.

Step 3

1. Count days by shift type, and click "Functions" to find

CountRosterByDay(type). Then view the relevant description and example of this function.

Note: [Parameter description]

Type: When the value is Working, the number of working days within the payroll period is returned; When the value is rest, return the number of scheduled Rest days; When it is SH, return the number of statutory holidays on schedule; When the value is empty, the number of days on schedule is returned;

Example:
// Reurn the number of working days within the payroll period

CountRosterByDay('Working');

// Return the number of scheduled Rest days

CountRosterByDay('Rest');

// Return the number of statutory holidays on schedule

CountRosterByDay('SH')

// Return the number of days on schedule

CountRosterByDay()

2. Based on the attendance period corresponding to the current salary period, return the employee's schedule time, and click "Functions" to find GetRosterByTime(StartTime ,Endtime). Then view the relevant description and example for this function.

Note: [Parameter description]

StartTime: Start time

EndTime: End time

Example:

GetrosterByTime('09:00', '17:00')

2020-07-01—2020-07-01 Roster 09:00 —12:00 180 min

2020-07-02—2020-07-02 Roster 14:00 —18:00 180 min

2020-07-03—2020-07-03 Roster 17:00 —20:00 0 min

A total of 360 min is returned.

3. Based on the attendance period corresponding to the current salary period, return the schedule time of designated locations, and click "Functions" to find GetRosterByLocation(location1, location2). Then view the relevant description and example of this function.

Note: [Parameter description]

Location: The name of office clock-in/out place. If more than one location exists, separate them sequentially by commas.

Example:

GetrosterByLocation(' Shanghai, Shenzhen, Changsha ')

2020-07-01—2020-07-01 Roster 09:00 —12:00 location:Shanghai

2020-07-02—2020-07-02 Roster 14:00 —18:00 location:Shenzhen

2020-07-03—2020-07-03 Roster 17:00 —20:00 location:Changsha

A total of 420 min is returned.

4. Based on the attendance period corresponding to the current salary period, return the schedule time of designated projects, and click "Functions" to find GetRosterByProject(project1, project, project,……). Then view the relevant description and example of this function.

Note: [Parameter description]

Project: The name of schedule project, If more than one location exists, separate them sequentially by commas.

Example:

GetRosterByProject('Dance, Bike, Fight')

2020-07-01 — 2020-07-01 Roster 09:00 — 12:00 Location: Dance

2020-07-02 — 2020-07-02 Roster 14:00 — 18:00 Location: Bike

2020-07-03 — 2020-07-03 Roster 17:00 — 20:00 Location: Fight

A total of 180 min is returned.

Did this answer your question?