This article provides a summary of the data you can use when creating a report. You create reports from the Analytics area in Personio. We’ll cover the following important concepts:
- The difference between attributes and metrics.
- Different ways to create reports based on time selection.
- All data you can use in reporting.
Understand the difference between attributes and metrics
In the report builder, Personio uses the term "data" to refer to both attributes and metrics together. It’s important to understand the difference between attributes and metrics. This helps you organize, analyze, and display your data effectively.
| Attribute | Metric | |
| Definition | An attribute is a single data field or property that describes an employee or event in your organization. | A metric is a calculated value. Personio often derives a metric by combining or transforming multiple attributes. This helps provide a key performance indicator (KPI) for your organization. |
| How do I use them? |
Attributes are the building blocks of your data. You can use them for filtering, grouping, or segmenting reports. Personio sources attributes from different product areas, such as employee data, time off, and compensation. Attributes can be either preset or custom-created to match your organization’s needs. For a general introduction to attributes in Personio, read our summary of attributes article. |
You can use metrics to answer specific business questions and support decision-making. They’re also central to trend and performance analysis. In Personio, metrics are available as pre-built options in our reporting templates. |
| Examples |
Attributes can be preset, like Position or Hire date, or custom, like “Laptop model” or “Language skills.” Attributes can be static, like Birth date, or dynamic, like Status, which can change over time. |
Headcount, FTE (full-time equivalent), Absence rate, Turnover rate. |
Different ways to create reports based on time selection
You can create reports in three different ways based on your time selection: as a snapshot (point in time), as an aggregate (timeframe), or as a detailed change log (employee change report). Choose the appropriate option based on your reporting needs.
All data is available in both point-in-time and timeframe formats. However, you can only use certain data in employee change reports. To see which data you can use for this report type, go to Create a report > Employee change blank report and start adding data.
Point-in-time report
- Definition: This option reflects the value for each employee at a specific date, such as the end of a selected month, quarter, or reporting period. Pick a specific date in the calendar to generate a point-in-time report.
- Use case: This option is useful for getting a snapshot of your data at a specific point in time. For example, “What was the headcount on March 31st?” or “Who was in the Sales department at the end of last year?”
Timeframe report
- Definition: This option aggregates or summarizes data over a selected period. Click the calendar icon above the main report view to select a timeframe, for example, Last year or This quarter. You can also select a custom range. Note that timeframe reports only show the data value at the end of the period under review. To understand changes over time, use the employee change report.
- Use case: This option is useful for analyzing totals, averages, or patterns across time. For example, “Total time off in Q2” or “Average hours worked in January.”
Employee change report
- Definition: This refers to the report option under Create a report > Employee change blank report. These reports track and display how data values change over time. They capture every update or change made to a data field. You can use them for historical and also future data. Employee change reports show the full change history for selected data, not just their values at a single point or over a period.
- Use case: This option is essential for auditing and understanding trends. For example, “How did an employee’s department or salary change during their tenure?” or “What changes were made to employment status last quarter?”
Understand permissions
Anyone with an Administrator role can create a report. You can also allow other employees to do so through their employee role. Learn more about granting other employees permissions to create reports.
Employees can only access data for which they have permissions. Therefore, you need to grant access to the relevant employee attribute data. In the sections below, we outline in each table the permissions needed for each data item.
Note that for some data, you need additional attribute permissions. For example, to use Headcount, you also need view access to the Status and Hire date attributes. To check which Personal data section an attribute belongs to, go to Settings > People > Personal information. For example, Personio places the Status attribute in the HR information section by default.
Employee information data
The table below outlines all employee information attributes available for reporting.
| Data | Description | Permissions needed |
| Employee information (system attributes) |
|
People data > Personal data |
| Employee information (custom attributes) |
Examples:
|
People data > Personal data |
| Birthday | The employee’s birthday. | People data > Personal data |
| Personio ID | The Personio ID is a system-generated identifier. You can find it at the end of the URL for each employee profile. | No additional permissions needed |
| Last day of work | The last working day of an employee. | People data > Personal data |
| Termination date | The date you officially issue an employee's termination. | People data > Personal data |
| Terminated within timeframe | Indicates if the termination date is within the selected timeframe. |
People data > Personal data You also need view access to the Status attribute. |
| Hired within timeframe | Indicates if the hire date is within the selected timeframe. |
People data > Personal data You also need view access to the Status attribute. |
| Termination reason | Additional details regarding the reason for termination, entered in a free-text field. |
People data > Personal data You also need edit access to the Status attribute. |
| Termination type | The termination type within the specified termination categories. |
People data > Personal data You also need edit access to the Status attribute. |
| Voluntary termination | Indicates whether the termination is voluntary or involuntary. Voluntary termination is when an employee resigns on their own. The employer initiates involuntary termination. |
People data > Personal data You also need edit access to the Status attribute. |
| Regretted termination | Indicates whether the termination is regrettable or not. If an employee leaves your organization and you want to keep them, then it's regretted termination. |
People data > Personal data You also need edit access to the Status attribute. |
| Position should be backfilled | Indicates whether you intend to backfill a position after a termination. If you don't backfill a position, then you eliminate it from the organizational structure after the employee's termination. |
People data > Personal data You also need edit access to the Status attribute. |
| Notice pronounced | The date when an employee officially communicates their notice. |
People data > Personal data You also need edit access to the Status attribute. |
| Headcount | Headcount refers to the total number of active employees in an organization, counted on the final day of a specific period. |
People data > Personal data You also need view access to the Status and Hire date attributes. |
| FTE | The system calculates FTE by dividing an employee's weekly working hours by the standard full-time weekly hours for your organization. |
People data > Personal data You also need view access to the Status, Hire date, and Weekly hours attributes. |
| Employee turnover rate | The rate at which employees leave the organization. |
People data > Personal data You also need view access to the Status and Hire date attributes. |
| Age | The age of the employee. |
People data > Personal data You also need view access for the Date of birth attribute. |
| Age bucket | The age range that an employee's age fits within. For example, 25–34. | People data > Personal data |
| Tenure (years) | The number of years that an employee has been with the organization. |
People data > Personal data You also need view access for the Hire date attribute. |
| Tenure bucket (years) | The range of years that an employee's tenure fits within. For example, 3–5 years. |
People data > Personal data You also need view access for the Hire date attribute. |
| Probation period end | The date when the probation period ends. | People data > Personal data |
| Job family | The job family of the employee's position. | People data > Jobs |
| Job grade | The grade level of the employee's position. | People data > Jobs |
| Job level | The level of seniority of the employee's position. | People data > Jobs |
| Job track | The career track for the employee's position. | People data > Jobs |
| Employment type | Specifies if an employee is employed internally or externally. | People data > Personal data |
Compensation data
The table below outlines all compensation data available for reporting.
The currency shown in reports is based on each employee’s workplace. You can set the currency for each workplace via Settings > Organization > Workplaces. If you don’t assign a workplace, then Personio applies the default currency for your organization. You can check this via Settings > Account & support > Company defaults.
All salary attributes are available until five years into the past.
| Data | Description | Permissions needed |
| Prorated gross salary (fixed and hourly) | Represents each employee's actual salary or hourly pay, based on their hire date, working hours, attendance, and overtime. | People data > Salary information |
| Prorated gross salary (fixed) | Actual salary for full-time employees. This is adjusted based on hire date, weekly hours, etc. | People data > Salary information |
| Hourly salary | Hourly pay. This is adjusted based on hire date, working hours, etc., for hourly employees. | People data > Salary information |
| Hourly salary - contracted | Employees' current contractual hourly salary rate | People data > Salary information |
| Gross salary (FTE) | 100% of the salary amount for full-time employees, not considering weekly working hours. | People data > Salary information |
| Gross salary | Adjusted full-time gross salary, calculated based on the employee's weekly working hours relative to full-time hours. | People data > Salary information |
| Hourly rate | The amount an employee is paid per hour of work. | People data > Salary information |
| One-time compensation | Non-recurring financial payments, such as signing bonuses or severance packages. | People data > Salary information |
| Recurring compensation | Salary components with a regular payment (monthly, quarterly, half-yearly, or yearly) of a constant amount, such as subsidies for the public transport system. | People data > Salary information |
| Bonus payout | Actual amount of the goal and variable bonus that was paid to the employee in the respective period. | People data > Salary information |
| Salary band (Min/Mid/Max) | Min/Mid/Max compensation value associated with the employee's job level. | People data > Salary information |
| On target earnings | Total projected monetary compensation for employees if they meet all their performance goals. It includes gross salary, one-time and recurring compensation, and bonuses (goal and variable). | People data > Salary information |
| Total payout | Total actual amount, including gross salary, one-time and recurring compensation, bonus (goal and variable), and overtime payout that was paid to the employee in the respective period. | People data > Salary information |
| Goal bonus target | Goal bonus amount from the salary tab in their employee profile. | People data > Salary information |
| Contracted annual gross salary | Current contractual gross salary extrapolated to a full year. | People data > Salary information |
| Contracted monthly gross salary | Current contractual gross salary broken down into monthly installments. | People data > Salary information |
| Contracted annual gross salary (FTE) | Full-time equivalent annual gross salary. | People data > Salary information |
| Contracted monthly gross salary (FTE) | Full-time equivalent monthly gross salary. | People data > Salary information |
| Overtime payout | Reimbursement of overtime hours. | People data > Salary information |
Time off data
The table below outlines all time off data available for reporting. You can combine all time off data with attendance, salary, and employee information data.
The system aggregates all time off types. If you want to report on a specific time off type, like paid vacation or sick days, then you can filter by it.
All time off attributes are available from an employee’s start date until two years in the future.
| Data | Description | Permissions needed |
| Capacity available rate | Shows the percentage of workforce capacity not absent. | People data > Time off |
| Certificate status | Status of the time off certificate. | People data > Time off |
| EAU certificate status | Status of the EAU certificate of the time off. | People data > Time off |
| Half day at beginning of period | Indicates if the time off period starts with a half day. | People data > Time off |
| Half day at end of period | Indicates if the time off period ends with a half day. | People data > Time off |
| Time off days | Total number of days that employees took time off during a specific period. | People data > Time off |
| Time off duration – days inside timeframe | Total number of time off days within the selected timeframe for a given time off period. | People data > Time off |
| Time off duration – hours inside timeframe | Total number of time off hours within the selected timeframe for a given time off period. | People data > Time off |
| Time off end date | The last date of the time off period. | People data > Time off |
| Time off hours | Total number of hours that employees took time off during a specific period. | People data > Time off |
| Time off hours against target hours | Includes all time off types and considers the target hours set for each employee. | People data > Time off |
| Time off period comment | Any comment or note added by the employee or approver for the specific time off period. | People data > Time off |
| Time off period status | The current status of the time off request. For example, approved. | People data > Time off |
| Absence rate | An overview of the absence rate at your organization. | People data > Time off |
| Time off start date | The first date of the time off period. | People data > Time off |
| Time off type | The specific category of time off taken. For example, paid vacation, sick leave, or parental leave. | People data > Time off |
| Time off available balance - days | The latest time off balance in days according to contract working hours. The system considers taken time off periods. | People data > Time off |
| Time off effective balance - days | The time off balance. The system considers both taken and planned time off periods. | People data > Time off |
| Time off carryover - days | Time off days carried over from the previous period. | People data > Time off |
| Time off used carryover - days | The number of carryover days from the previous period that the employee has already used. | People data > Time off |
| Time off entitlement - days | Total time off entitlement in days. | People data > Time off |
| Time off expired carryover days | The number of time off carryover days that have expired. | People data > Time off |
| Time off planned approved - days | The number of approved time off days planned to be taken. | People data > Time off |
| Time off pending approval - days | The number of days the employee requested time off for that haven't been approved yet. | People data > Time off |
| Time off - daily time off types | The time off in days for daily time off types. The system doesn't consider target hours. | People data > Time off |
| Time off - hourly time off types | The time off in hours for hourly time off types. The system doesn't consider target hours. | People data > Time off |
| Time off status | The time off status. | People data > Time off |
| Time off type - days | Time off type - days | People data > Time off |
| Time off type - hours | Time off type - hours | People data > Time off |
Attendance and overtime data
The table below outlines all attendance and overtime data available for reporting.
When creating reports using the attributes Attendance hours tracked and Overtime hours tracked, you can filter by the relevant status to show hours that are confirmed, pending, etc. For example, to see only confirmed hours:
- For reports with Attendance hours tracked, apply the filter “Attendance status equals Confirmed.”
- For reports with Overtime hours tracked, apply the filter “Overtime status equals Confirmed.”
This applies to all attributes that contain different possible statuses. Without these filters, your report numbers may not match the expected results.
| Data | Description | Permissions needed |
| Attendance hours tracked | Total hours tracked for attendance. | People data > Attendance data |
| Attendance start time | The start time of an attendance period. | People data > Attendance data |
| Attendance end time | The end time of an attendance period. | People data > Attendance data |
| Attendance date | The specific date on which attendance is tracked. | People data > Attendance data |
| Attendance rejection reason | The reason provided for rejecting an attendance entry. | People data > Attendance data |
| Attendance status | The current status of the attendance entry. For example, approved, pending, or rejected. | People data > Attendance data |
| Attendance breaks tracked | Total duration of breaks tracked during the attendance period. | People data > Attendance data |
| Attendance project | Project associated with attendance. You add project-specific details when setting up a project. | People data > Attendance data |
| Attendance subproject | Subproject associated with attendance. | People data > Attendance data |
| Attendance project billable | Specifies whether a project is billable or not (Y/N) | People data > Attendance data |
| Attendance project client name | Client associated with the project. | People data > Attendance data |
| Attendance project code | Code associated with the project. | People data > Attendance data |
| Attendance project cost center | Cost center associated with the project. | People data > Attendance data |
| Attendance project start date | The start date associated with the project. | People data > Attendance data |
| Attendance project end date | The end date associated with the project. | People data > Attendance data |
| Attendance project type | The project type, for example, an internal or external project. | People data > Attendance data |
| Attendance comment | Comments related to attendance. | People data > Attendance data |
| Overtime activity type | Overtime item activity type | People data > Attendance data |
| Overtime hours tracked | Total overtime hours tracked. | People data > Attendance data |
| Overtime date | Date when overtime is logged. | People data > Attendance data |
| Overtime status | Approval or processing status of overtime. | People data > Attendance data |
| Contractual work hours | The standard number of hours an employee is expected to work, as defined in their work schedule. | People data > Attendance data |
| Effective work hours | The total number of working hours for an employee after considering time off, approved leave, public holidays, and other relevant factors. | People data > Attendance data |
| Contract hours over public holidays | The portion of an employee’s contractual working hours that coincides with public holidays. This reflects the number of hours considered as worked due to public holiday entitlement. | People data > Attendance data |
| Contractual hours date | The date of the contractual hours. | People data > Attendance data |
| Tracked with | The source or origin of the attendance period. | People data > Attendance data |
| Exact location - work start | Exact location where attendance starts. | People data > Attendance data |
| Exact location - work end | Exact location where attendance ends. | People data > Attendance data |
| Location type – work start | Location type where attendance starts. | People data > Attendance data |
| Location type – work end | Location type where attendance ends. | People data > Attendance data |
| Workplace name - work start | Name of the workplace where work starts. | People data > Attendance data |
| Workplace name - work end | Name of the workplace where work ends. | People data > Attendance data |
Performance and goal data
The table below outlines all performance and goal attributes available for reporting.
| Data | Description | Permissions needed |
| Goal name | The name of the goal assigned to an employee. | People data > Performance & development |
| Goal achieved percentage | The percentage of the goal the employee has achieved so far, indicating progress towards completing the goal. | People data > Performance & development |
| Goal status | The current state of an employee's goal, providing a general indication of its progress or standing. | People data > Performance & development |
| Goal interval | The timeframe set for the employee to start and complete the goal. | People data > Performance & development |
| Subgoal name | The name of a subgoal linked to a broader goal. | People data > Performance & development |
| Subgoal achieved percentage | The percentage of the subgoal the employee has achieved so far. | People data > Performance & development |
| Subgoal weight | The numeric weight assigned to a subgoal, representing its importance and contribution to the goal achievement. | People data > Performance & development |
| Subgoal target value | The numeric target value that the subgoal aims to achieve. | People data > Performance & development |
| Subgoal type | The measurement method for the subgoal. | People data > Performance & development |
| Subgoal target value achieved | The numeric result compared against the target that the subgoal aims to achieve. | People data > Performance & development |
| Goal end date | The goal's end date. | People data > Performance & development |
| Goal start date | The goal's start date | People data > Performance & development |