People Reports: Absenteeism, Employee List As At, Trainee Movement
Three read-only reports for headcount and attendance questions: who was absent and why, who was on the payroll on a given date, and how a group of trainees moved in and out during a month. None of them change any record. Each is under Manpower, Reports, and each has an Excel export.
Absenteeism Report
Shows, for any From and To date, how much each employee was scheduled, present, absent, late, on leave and working on rest days or holidays. You can start from a cutoff (the dates fill in for you) or type any range, up to one year.
| Column | What it counts |
|---|---|
| Scheduled Days | Working days on the employee's schedule. Rest days, extra days, holidays and company days off are not scheduled days. |
| Days Present | Days worked. A day fully covered by leave is not counted as present. |
| Days Absent | Unexcused absences, the same absence figure payroll deducts. Approved leave is shown under leave instead. |
| Late and Undertime | How many times, and the total minutes. |
| Paid / Unpaid Leave Days | Approved leave days, split by whether the leave was filed with pay. A half-day leave counts 0.5. |
| Rest-day Work / Holiday Work | Days worked on a rest day or on a holiday. |
| Absenteeism Rate | Days Absent divided by Scheduled Days, as a percentage. Subtotals and the total are worked out from the summed days, not by averaging each person's rate. |
Filter by department (sub-departments are included), payroll group, branch, employment type and tags. Use Subtotals by to group the figures per department, branch or payroll group.
Click any underlined count (absent, late, undertime, leave, rest-day or holiday work) to list the exact dates. For leave, the list also shows the leave type, paid or unpaid, and the reason the employee filed.
The Leave Reports and Approval Applications reports also take any From and To date. A leave that starts before the range but runs into it is included. Both now show the leave type, whether it is paid, and the filed reason. You need the matching report permission to open them.
Employee List As At
A month-end headcount: every employee employed on the date you choose, with department, position, employment type as it was that day, payroll group, hire date, regularization date and status, and the dispatch (if any) in force that day. An employee counts as employed up to, but not including, their separation date.
Tick Include separated in period to also list people who left between the Separated since date (default: the first of the month) and the as-at date, shown with their separation date and type.
Trainee Movement Report
Pick a month and the group you mean by trainees, using employment type and/or tags (nothing is fixed in the system). The report lists joiners, leavers, dispatch departures and dispatch returns with their dates and departments, and rolls the headcount forward:
| Line | Example |
|---|---|
| Opening headcount | 79 |
| Joiners | +1 |
| Leavers | -2 |
| Closing headcount | 78 |
If someone moves into or out of the group during the month (for example from Trainee to Probationary) the difference appears on its own line, Reclassified / other, so the roll-forward always adds up. On dispatch at month end is shown for information.
How It Connects
Set up first
- Employee Records — contracts, hire and separation dates, tags and departments come from here.
Gets its data from
- Payroll Time Keeping — daily present, absent, late and undertime figures.
- Filings — approved leave, with its type, paid flag and reason.
Feeds into
- HR and Payroll Reports — sits beside the other manpower reports.