Attendance Variables

19-Jul-2023 ·

What are Attendance Variables?

There are several Attendance Variables that can be used in Backstage for calculating staff attendance. Below is the Basic form of the Attendance Variables.

Usage

Basic Form

Attendance Variable Description
[OVERTIME_MINUTES] Get the number of Overtime minutes on the day. The time would be counted after the shift End time
[LATE_IN_MINUTES] Get the number of Late In minutes on the day. The time would be counted after the shift Start time
[EARLY_OUT_MINUTES] Get the number of Early Out minutes on the day. The time would be counted if staff leave before the shift End time
[SHORT_MINUTES] Get the number of Short minutes on the day. The time would be counted if staff Actual Working hours are fewer than the Standard Working hours of the shift
[BREAK_EARLY_OUT_MINUTES] Get the number of Break time Early Out minutes on the day. The time would be counted if staff goes out for break before the shift Break Start time
[BREAK_LATE_IN_MINUTES] Get the number of Break Late In minutes on the day. The time would be counted if the staff break comes back after the shift Break End time


General Parameters/Variations

Hightlight part content can be changed

Parameters/Variations Description Usage
DAY_OF_WEEK=Number*

Number: 0-6
0=Sun, 1=Mon, 2=Tue, 3=Wed, 4=Thur, 5=Fri, 6=Sat
Count the number of minutes on the specified day(s) of week by providing 0 to 6 (Sunday to Saturday) Count Overtime minutes on Sunday only
[OVERTIME_MINUTES(DAY_OF_WEEK=0)]
[HAS_ACTIVITY(Activity Type Code]**

**If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.
Count/Not Count the number of minutes only if that day has certain Activity record NOT Count Overtime minutes if the staff has Activity WFH that day
IIF('[HAS_ACTIVITY(WFH)]'='Y',0,[OVERTIME_MINUTES])

IIF('[HAS_LEAVE(WFH)]'='N',[OVERTIME_MINUTES],0)
[HAS_LEAVE(Leave Type Code]**

**If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.
Count/Not Count the number of minutes only if that day has certain Leave record NOT Count Overtime minutes if the staff takes AL that day
IIF('[HAS_LEAVE(AL)]'='Y',0,[OVERTIME_MINUTES])

IIF('[HAS_LEAVE(AL)]'='N',[OVERTIME_MINUTES],0)