The meaning of ‘Duration’ and ‘In Period’ Columns

For example, I’m on leave from 12 January till 14 January:

and in the report I would like to see my current leaves from the 1st till 13 January:

The report for my leave from 12 January till 14 January shows ‘duration’ 2 (2 working days) and ‘in period’ 1 (1 working day) as duration of this leave is 2 working days but in the selected period (the date range in the report) from 1 January till 13 January it is 1 working day.

Start by choosing your preferred ‘Date range’ from the presets or by customizing the date range yourself. Remember to press the ‘Update’ button in order to be sure your changes will take effect.

You can also group data by ‘User’ or ‘Leave type’. If you select ‘User,’ your list of results will be based on the users.

If you pick to list by ‘Leave type’, the overview will be listed based on the leave types.

Furthermore, you can filter your report based on:

– Your leave types
– Team members, staff
– Status (approved, pending).

Once you’ve made your picks, you’ll be able to export the report via PDF, CSV or EXCEL.

Follow the link, for the detailed calculations regarding the attendance report.

Note:

– Standard Break Times and Office Shutdown Times influence the Total Break Time

– If the time model is Just CORE time, we calculate on Flex time balance

If you want a detailed picture of your attendance data, you can find the report here:

Besides the ‘Date range’, you can also limit the report to a specific template. Click the drop-down menu and choose your preferred ones:

You can also filter the report by ‘Teams’ or a specific ‘Staff’:

You can also filter for payable/not-payable time records.

What’s featured in the report?

For example, if we choose the date shown below:

‘Flextime Balance’ will display the + or – hours which are calculated as ongoing.
In this case, it will be -5:38h.
So if you set up your plan by 8 hours a day, we calculate based on these hours. So when the user works over 8 hours = overtime (+), and if the user is below 8 hours = minus hours

Note: If you set up your flex time from 7 am to 5 pm and the user clocks in at 6 am, we start counting at 7 am. There will be 1 hour of unpaid working time. Also, keep in mind, that Standard Break Times and Office Shutdown Times (as you set them up), influence the Total Break Time.

If you want to see the non-production time of your staff members you can do that with our SQL integration.You can insert the SQL-Query below and insert it into your data visualization software or your business intelligence tool. Then, you can measure the project time vs. attendance time.

Here you can learn how to add the SQL integration: Learn more

Please note that:
1. Attendance time module must be active learn more
2. Attendance time is must not be synced with project time learn more

If you are using Google Data Studio you can see here an example where to insert the SQL-Query:

MySQL Query:
Please note the last two columns of the SQL-Query where you can add filter by dates and filter by user id. Also it might be that some tools have problems to read comments on the SQL query. Please try to delete them if an error occurs.

SELECT 
	calendar.dt,
	u.first_name,
	u.last_name,
	ifnull(at_time.work_hours + at_time.break,0) as attendance_total_time,
	ifnull(at_time.work_hours,0) as attendance_work_time,
	ifnull(at_time.break,0) as attendance_break_time,
	ifnull((select sum(hours) from zst_time_sheet_tbl where log_date = calendar.dt and user_id = u.id),0) as total_project_hours,
	ifnull((select sum(hours) from zst_time_sheet_tbl where log_date = calendar.dt and user_id = u.id and document_status_id = 29),0) as non_billable_hours,
	ifnull((select sum(hours) from zst_time_sheet_tbl where log_date = calendar.dt and user_id = u.id and document_status_id <> 29),0) as billable_hours
FROM 
	zst_calendar_tbl as calendar 
	cross join zst_user_tbl as u
	left join zst_attendance_time_accumulation_tbl as at_time on
		at_time.user_id = u.id and at_time.dt = calendar.dt
where
	u.vendor_id is null
	and u.customer_id is null
	and calendar.dt between '2020-03-16' and '2020-03-22' -- filter by dates
	and u.id = 1 -- filter by user_id

This report shows which user has has how many days of vacation already taken, remaining, planing and pending for approval. This is an overview at the time you review the report.

On this report you can also see if a person was on-site or off-site and changes to the flex time balance will be shown as well for each day. The report can be exported as PDF and Excel.

In some countries, e.g. Switzerland, Germany, Italia, France or Spain employees get an extra pay for woking at night, on holidays or on the weekly day of rest. Therefore, you see on the HR report worktime on holidays and weekly day of rest (e.g. Sunday) and during the night.

Holiday and Sunday Worktime

See if anyone worked during a holiday. Holiday worktime is all attendance time record tracked on a holiday, set up on the attendance time template.
Here’s more about holidays →

Sunday Worktime is any attendance time tracked on the weekly day of rest, set up on the attendance template’s worktime rule.
Here’s more about worktime rules →

Night Worktime

On the HR report you can easily see if a user tracked attendance time during the night. The night work time can be defined on settings/company profile/company settings. Usually, night work time is from 22:00–06:00. However, please make sure that the night worktime meet the regulation that apply to your company.
Here’s more about the company profile →

Further, you see the amount of the remaining and taken vacation days within the selected time period. Additionally, the report lists all leave types taken for the selected month. Both, taken vacation and taken leaves is shown in days and hours.

Below, you can see all manual corrections (e.g. paid out overtime or turned overtime into vacation) made to the user’s flextime balance in the selected time period.

Filters and Export

On the attendance report you can only view data per single month, you need to select the year and the month. You can limit the report to specific attendance time templates or to specific users, teams, or reporting groups.

The report can be exported as PDF only.