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	Working Hours - Break Hours
Scheduled 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.
Paid Hours	Leave Paid Hours
Contractual Working 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.
Maximum Working Hours	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.

Report Columns	Meaning
Date of Employment	Date of employment set from Employee - Basic Info
Main Team	Main team set from Employee - Basic Info if an employee is assigned to multiple teams
Contractual Working days	Number of weekly working days set from Employee - Wage Info
Scheduled Days	Shift days excluding Paid Leave Days
Worked Days	Attendance Days + (Deemed Work Days)    * Duplicated hours are excluded when using deemed work feature along with the attendance record.
Paid Leave Days	Number of Paid Leave Days
Contractual Working Hours	Daily Working Hours(Set from Contractual Hour Rule) × Contractual Working Days
Scheduled Hours	Shift Hours - Break Hours - (Paid Leave Hours)
Scheduled Paid 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)
Worked Paid Hours	(Attendance Hours - Break Hours) + Deemed Work Hours + Paid Leave Hours
Standardized Hours	Standardized Hours set from Company Settings - Report and based on settings from [Manage > Standardization Rules].
Standardized Paid Hours	Standardized Hours + Paid Leave Hours
Paid Leave Hours	Hours reflected as Paid Leave Hours
Avg. Scheduled Hours Per Day	Scheduled Hours ÷ Scheduled Days
Avg. Scheduled Paid Hours Per Day	Scheduled Paid Hours ÷ Scheduled Days
Avg. Worked Hours Per Day	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
Avg. Scheduled Paid Hours 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
Avg. Worked Paid Hours 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
Overtime Work 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
Worked Overtime Hours	Overtime Hours within a unit period (Worked Hours - Contractual Working Hours)    * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected
Standardized Overtime Hours	Overtime Hours within a unit period (Standardized Hours - Contractual Working Hours)    * Minimum Overtime Threshold set from Employee - Wage Contractual Working Hour Rule is reflected
Standardized Overtime Paid Hours	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
Worked Overtime Paid Hours	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
Scheduled Remaining Contractual Hours	Contractual Working Hours - Scheduled Hours
Scheduled Remaining Contractual Paid Hours	Contractual Working Hours - Scheduled Paid Hours
Worked Remaining Contractual Hours	Contractual Working Hours - Worked Hours
Worked Remaining Contractual 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)
Scheduled Remaining Maximum Overtime Paid Hours	(Contractual Working Hours + Maximum Overtime Threshold Hours) - Scheduled Paid Hours    * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected
Worked Remaining Maximum Overtime Hours	(Contractual Working Hours + Maximum Overtime Threshold Hours) - Worked Hours     * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected
Worked Remaining Maximum Overtime Paid Hours	(Contractual Working Hours + Maximum Overtime Threshold Hours) - Worked Paid Hours    * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected
Standardized Remaining Maximum Overtime Hours	(Contractual Working Hours + Maximum Overtime Threshold Hours) - Standardized Hours    * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected
Standardized Remaining Maximum Overtime Paid Hours	(Contractual Working Hours + Maximum Overtime Threshold Hours) - Standardized Paid Hours    * Maximum Overtime Threshold set from Employee - Wage Contractual Hour Rule is reflected
Standardized Remaining Maximum Hours	Maximum Working Hours - Standardized Hours    * Remaining standardized hours that can be extended within the unit period set in maximum working hour rule.
Standardized Remaining Maximum Paid Hours	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 Weekday Hours Per Day (Excluding OT)	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 Weekday Hours Per Day (Excluding OT)	Worked hours per day in weekdays exclduing OT
Standardized Weekday Hours Per Day (Excluding OT)	Standardized hours per day in weekdays exclduing OT    * Standardized hours set from [Manage > Standardization Rule].
Scheduled Overtime Hours Per Day	Scheduled Hours per day - Contractual Working Hours per day
Scheduled Overtime Paid Hours Per Day	Scheduled Paid Hours per day - Contractual Working Hours per day
Scheduled Weekday 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)
Scheduled Off Day Overtime Hours Per Day	Scheduled Off Day Hours per day - Contractual Working Hours per day
Scheduled Off Day Overtime Paid Hours Per Day	Scheduled Off Day Paid Hours per day - Contractual Working Hours per day
Scheduled Holiday 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)
Scheduled Overtime 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'.
Scheduled Weekday 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'.
Scheduled Off Day 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'.
Scheduled Holiday 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 Non Premium Overtime 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 Premium Overtime Hours	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 Non Premium Overtime Paid Hours	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 Premium Overtime Paid Hours	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 Night Hours	Scheduled Hours from 10PM to 6AM.
Worked Night Hours	Worked Hours from 10PM to 6AM.
Standardized Night Hours	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 Night Paid Hours	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]
Scheduled Weekday 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].
Scheduled Weekday 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].
Scheduled Off Day 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].
Scheduled Off Day 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].
Scheduled Holiday 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].
Scheduled Holiday 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].
Standardized Weekday Overtime Paid Hours per Day	Standardized Weekday Paid Hours per Day - Contractual Working Hours per Day
Standardized Holiday Overtime Hours per Day	Standardized Holiday Hours per Day - Contractual Working Hours per Day
Scheduled Holiday Hours	Scheduled Hours overlapping with public holidays, custom holidays, weekly paid holidays
Worked Holiday Hours	Worked Hours overlapping with public holidays, custom holidays, weekly paid holidays
Scheduled Off Day Hours	Scheduled Hours on Off Days(days excluding weekday, holiday)
Standardized Holiday Hours	Standardized Hours overlapping with public holidays, custom holidays, weekly paid holidays
Standardized Off Day Hours	Standardized Hours on Off Days(days excluding weekday, holiday)
Scheduled Additional Working Hours (With Premium)	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 Additional Working Paid Hours (With Premium)	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 Additional Working Hours (With Premium)	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 Additional Working Hours Per day (With Premium)	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	Maximum Work Calculation Period set from Employee - Wage Maximum Hour Rule.    (Report shows results in Maximum Work Unit Period)
Scheduled Remaining Maximum Hours	Maximum Working Hours - Scheduled Hours
Scheduled Remaining 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)

If you have any further questions, feel free to contact support@shiftee.io