Report Columns
Updated At: 2023-10-04
All Users can view the report page. |
---|
- You can check all the data related to time and attendance in report page.
- Users with Staff Access Level can only view their own data. Users with Supervisor Access Level can only view the data of assigned teams/locations.
Understanding Basic Terms
The following basic terms below can help you understand the report columns better.
Terms | Meaning |
---|---|
|
Working Hours - Break Hours |
|
Shift Hours - Break Hours - (Paid Leave Hours) e.g. 9:00-18:00 shift, 1 hour break time, 4 hours of paid leave : Scheduled Hour is 4 hours. |
Worked Hours |
(Attendance Hours - Break Hours) + Deemed Work Hours e.g. 8:58 - 6:15 attendance, 1 hour break time : 8h 17m of Worked Hours ﹡Duplicated hours are excluded when using deemed work feature along with attendance record. |
|
Leave Paid Hours |
|
Reflects Contractual Working Days and Contractual Working Hour Rule set from Employees - Wage Info. Used for calculating Contractual Working Hours and Overtime Working Hours during unit period. |
|
Reflects Maximum Working Hour Rule set from Employees - Wage Info. Used for calculating Maxmimum Working Hours to comply labor law. e.g. 52hr(maximum working hours) ÷ 7(maximum working hours unit days) × (entire unit period days) |
Overtime Hours |
Working hours exceeding Contractual Hours e.g. 100 hours of working hours, 90 hours of contractual hours : 10h of Worked overtime hours. * If the Minimum Overtime Threshold is set from Employee - Wage Contractual Working Hour Rule, overtime work is considered when the Contractual Working Hours + the Minimum Overtime Threshold Hours are exceeded. |
Understanding Report Columns
Hover over the column name to check each formula.
Enter 'Ctrl + F' to find a term
Report Columns | Meaning |
---|---|
|
Date of employment set from Employee - Basic Info |
|
Main team set from Employee - Basic Info if an employee is assigned to multiple teams |
|
Number of weekly working days set from Employee - Wage Info |
|
Shift days excluding Paid Leave Days |
|
Attendance Days + (Deemed Work Days) * Duplicated hours are excluded when using deemed work feature along with the attendance record. |
|
Number of Paid Leave Days |
|
Daily Working Hours(Set from Contractual Hour Rule) × Contractual Working Days |
|
Shift Hours - Break Hours - (Paid Leave Hours) |
|
Shift Hours - Break Hours + Paid Leave Hours |
Worked Hours |
(Attendance Hours - Break Hours) + Deemed Work Hours ﹡ Duplicated hours are excluded when using deemed work feature along with attendance record. (Attendance Hours - Deemed Work Hours) + (Deemed Work Hours - Break Hours) |
|
(Attendance Hours - Break Hours) + Deemed Work Hours + Paid Leave Hours |
|
Standardized Hours set from Company Settings - Report and based on settings from [Manage > Standardization Rules]. |
|
Standardized Hours + Paid Leave Hours |
|
Hours reflected as Paid Leave Hours |
|
Scheduled Hours ÷ Scheduled Days |
Per Day |
Scheduled Paid Hours ÷ Scheduled Days |
|
Worked Hours ÷ Worked Days |
Avg. Scheduled Hours Per Week |
Scheduled Hours from the start date to today's date ÷ Selected Days 𝗑 7 e.g. Period of Inquiry: 1/1~1/31, Today's Date : 1/15 (Scheduled Hours in 1/1~1/15) ÷ 15 𝗑 7 |
Per Week |
Scheduled Paid Hours from the start date to today's date ÷ Selected Days 𝗑 7 e.g. Period of Inquiry: 1/1~1/31, Today's Date : 1/15 (Scheduled Paid Hours in 1/1~1/15) ÷ 15 𝗑 7 |
Avg. Worked Hours Per Week |
Worked Hours from the start date to today's date ÷ Selected Days 𝗑 7 e.g. Period of Inquiry: 1/1~1/31, Today's Date : 1/15 (Worked Hours in 1/1~1/15) ÷ 15 𝗑 7 |
Per Week |
Worked Paid Hours from the start date to today's date ÷ Selected Days 𝗑 7 e.g. Period of Inquiry: 1/1~1/31, Today's Date : 1/15 (Worked Paid Hours in 1/1~1/15) ÷ 15 𝗑 7 |
Calculation Period |
Reflects Effective Date and Contractual Working Hour Rule set from Employee - Wage Info e.g. Unit period set to 1 month : Contractual Hours and Overtime Work Calculation Period set to 1 month. |
Scheduled Overtime Hours |
Overtime Hours within a unit period (Scheduled Hours - Contractual Working Hours) * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected |
Scheduled Overtime Paid Hours |
Overtime Hours within a unit period (Scheduled Paid Hours - Contractual Working Hours) * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected |
|
Overtime Hours within a unit period (Worked Hours - Contractual Working Hours) * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected |
|
Overtime Hours within a unit period (Standardized Hours - Contractual Working Hours) * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected |
|
Overtime Hours within a unit period (Standardized Paid Hours - Contractual Working Hours) * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected |
|
Overtime Hours within a unit period (Worked Paid Hours - Contractual Working Hours) * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected |
Contractual Hours |
Contractual Working Hours - Scheduled Hours |
Contractual Paid Hours |
Contractual Working Hours - Scheduled Paid Hours |
|
Contractual Working Hours - Worked Hours |
|
Contractual Working Hours - Worked Paid Hours |
Scheduled Remaining Maximum Overtime Hours |
(Contractual Working Hours + Maximum Overtime Threshold Hours) - Scheduled Hours * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected e.g. Maximum Overtime Threshold 12 hours per 1 week, 1 month unit period = 12 ÷ 7(maximum threshold unit days) x 31(entire unit period days) |
|
(Contractual Working Hours + Maximum Overtime Threshold Hours) - Scheduled Paid Hours * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
(Contractual Working Hours + Maximum Overtime Threshold Hours) - Worked Hours * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
(Contractual Working Hours + Maximum Overtime Threshold Hours) - Worked Paid Hours * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
(Contractual Working Hours + Maximum Overtime Threshold Hours) - Standardized Hours * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
(Contractual Working Hours + Maximum Overtime Threshold Hours) - Standardized Paid Hours * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
Maximum Working Hours - Standardized Hours * Remaining standardized hours that can be extended within the unit period set in maximum working hour rule. |
|
Maximum Working Hours - Standardized Paid Hours * Remaining standardized paid hours that can be extended within the unit period set in maximum working hour rule. |
|
Scheduled hours per day in weekdays exclduing OT * (e.g.) If contractual working hours in 1 day : 8 hrs, scheduled hours 12 hrs, then scheduled weekday hours per day (excluding OT) = 8 hrs. |
|
Worked hours per day in weekdays exclduing OT |
|
Standardized hours per day in weekdays exclduing OT * Standardized hours set from [Manage > Standardization Rule]. |
|
Scheduled Hours per day - Contractual Working Hours per day |
|
Scheduled Paid Hours per day - Contractual Working Hours per day |
Overtime Hours Per Day |
Overtime Scheduled Hours exceeding Contractual Working Hours per day during weekdays. (Scheduled Hours per day during weekdays - Contractual Working Hours per day) |
Overtime Hours Per Day |
Scheduled Off Day Hours per day - Contractual Working Hours per day |
Overtime Paid Hours Per Day |
Scheduled Off Day Paid Hours per day - Contractual Working Hours per day |
Overtime Hours Per Day |
Overtime Scheduled Hours exceeding Contractual Working Hours per day during holidays. (Scheduled Hours on public holidays, custom holidays, weekly paid holidays - Contractual Working Hours per day) |
Shift Hours |
Scheduled working hours of shift with 'overtime work' shift type. Paid leave hours will not be deducted from the 'scheduled overtime shift hours'. |
Overtime Shift Hours |
Scheduled working hours of shift with 'overtime work' shift type on weekdays. Paid leave hours will not be deducted from the 'scheduled overtime shift hours'. |
Overtime Shift Hours |
Scheduled working hours of shift with 'overtime work' shift type on off days. Paid leave hours will not be deducted from the 'scheduled overtime shift hours'. |
Overtime Shift Hours |
Scheduled working hours of shift with 'overtime work' shift type on holidays(public holidays, custom holidays, weekly paid holidays). Paid leave hours will not be deducted from the 'scheduled overtime shift hours'. |
|
Scheduled Weekday Overtime Hours between the Contractual Working Hours and Contractual Paid Hours * Contractual Paid Hours = Contractual Working Hours + Paid Hours e.g. Scheduled Hours during weekdays = 180 hrs, Contractual Working Hours = 160 hrs, Paid Hours = 5 hrs Contractual Paid Hours = 160 hrs + 5 hrs = 165 hrs Scheduled Weekday Non-Premium Overtime Hours = 5 hrs |
|
Scheduled Weekday Overtime Hours exceeding Contractual Paid Hours * Contractual Paid Hours = Contractual Working Hours + Paid Hours e.g. Scheduled Hours during weekdays = 180 hrs, Contractual Working Hours = 160 hrs, Paid Hours = 5 hrs Contractual Paid Hours = 160 hrs + 5 hrs = 165 hrs Scheduled Weekday Premium Overtime Hours = 15 hrs |
|
Scheduled Weekday Overtime Paid Hours between the Contractual Working Hours and Contractual Paid Hours * Contractual Paid Hours = Contractual Working Hours + Paid Hours e.g. Scheduled Paid Hours during weekdays = 185 hrs, Contractual Working Hours = 160 hrs, Paid Hours = 5 hrs Contractual Paid Hours = 160 hrs + 5 hrs = 165 hrs Scheduled Weekday Non-Premium Overtime Paid Hours = 5 hrs" |
|
Scheduled Weekday Overtime Paid Hours exceeding Contractual Paid Hours * Contractual Paid Hours = Contractual Working Hours + Paid Hours e.g. Scheduled Paid Hours during weekdays = 185 hrs, Contractual Working Hours = 160 hrs, Paid Hours = 5 hrs Contractual Paid Hours = 160 hrs + 5 hrs = 165 hrs Scheduled Weekday Premium Overtime Paid Hours = 20 hrs" |
|
Scheduled Hours from 10PM to 6AM. |
|
Worked Hours from 10PM to 6AM. |
|
Standardized Hours from *10PM to 6AM. * or based on the 'night work time range' set from [Company Settings > General]. * standardized hours set from [Manage > Standardization Rule] |
|
Standardized Paid Hours from *10PM to 6AM. * or based on the 'night work time range' set from [Company Settings > General]. * standardized hours set from [Manage > Standardization Rule] |
Night Hours Per Day |
Scheduled Hours from *10PM to 6AM during weekdays (paid leave hours excluded) * or based on the 'night work time range' set from [Company Settings > General]. |
Night Paid Hours Per Day |
Scheduled Hours from 10PM to 6AM during weekdays * or based on the 'night work time range' set from [Company Settings > General]. |
Night Hours Per Day |
Scheduled Hours from 10PM to 6AM during off days (paid leave hours excluded) * or based on the 'night work time range' set from [Company Settings > General]. |
Night Paid Hours Per Day |
Scheduled Hours from 10PM to 6AM during off days * or based on the 'night work time range' set from [Company Settings > General]. |
Night Hours Per Day |
Scheduled Hours from *10PM to 6AM during public holidays, custom holidays, weekly paid holidays * or based on the 'night work time range' set from [Company Settings > General]. |
Night Paid Hours Per Day |
Scheduled Hours from *10PM to 6AM during public holidays, custom holidays, weekly paid holidays * or based on the 'night work time range' set from [Company Settings > General]. |
Overtime Paid Hours per Day |
Standardized Weekday Paid Hours per Day - Contractual Working Hours per Day |
Overtime Hours per Day |
Standardized Holiday Hours per Day - Contractual Working Hours per Day |
|
Scheduled Hours overlapping with public holidays, custom holidays, weekly paid holidays |
|
Worked Hours overlapping with public holidays, custom holidays, weekly paid holidays |
|
Scheduled Hours on Off Days(days excluding weekday, holiday) |
|
Standardized Hours overlapping with public holidays, custom holidays, weekly paid holidays |
|
Standardized Hours on Off Days(days excluding weekday, holiday) |
|
Scheduled Overtime Hours × 1.5 + Night Hours × 0.5 + Holiday Hours × (0.5 or custom premium rate) * Minimum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
Scheduled Overtime Paid Hours × 1.5 + Night Hours × 0.5 + Holiday Hours × (0.5 or custom premium rate) * Minimum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
Worked Overtime Hours × 1.5 + Night Hours × 0.5 + Holiday Hours × (0.5 or custom premium rate) * Minimum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected |
|
Scheduled Weekday Overtime Hours Per Day 𝗑 1.5 + Scheduled Holiday Overtime Hours per day 𝗑 0.5 + Night Hours 𝗑 0.5 + Holiday Hours 𝗑 (0.5 or custom premium rate) |
|
Maximum Work Calculation Period set from Employee - Wage Maximum Hour Rule. (Report shows results in Maximum Work Unit Period) |
Maximum Hours |
Maximum Working Hours - Scheduled Hours |
Maximum Paid Hours |
Maximum Working Hours - Scheduled Paid Hours |
Worked Remaining Maximum Hours
|
Maximum Working Hours - Worked Hours |
Worked Remaining Maximum
Paid Hours |
Maximum Working Hours - Worked Paid Hours |
Deemed Working Days
|
Working days with deemed work feature |
Deemed Working Hours
|
Working hours with deemed work feature |
Leave Days
|
Days that used leaves |
Leave Deducted Days
|
Sum of days deducted from Leaves |
Tardiness
|
Late clock in record after the scheduled start time ﹡Reflects the Tardiness Threshold on the report page |
Tardiness Hours
|
Late clock-in time recorded after the scheduled shift start time (e.g.) If shift start time 9:00, clock-in time 9:25, then tardiness hours = 25 min. |
Early Clock Out
|
Early clock out record prior to the end of scheduled end time |
Early Clock Out Hours
|
Early clock-out time recorded earlier than the scheduled shift end time |
Absences
|
No clock in record on scheduled shift |
Missing Clock Out |
Missing clock in/out records ﹡ If employees forgot to clock out on time (Over the threshold hours set in Company Settings - Timeclock) |