Discussions
Employments endpoint status changes
Hi Forum,
I am currently building a Power BI reporting solution based on the Personio API and I have a question regarding employee/employment status history.
In the Employments data, I can see fields such as the employee status (for example ACTIVE or LEAVE). However, it seems that the Employment entity only stores the current state and not historical changes.
I tested this with an employee whose status changed from ACTIVE to LEAVE. I expected that this would create a new Employment record (or some kind of historical/versioned entry), but instead I only see a single record that appears to have been updated.
My questions are:
- Does Personio overwrite the existing Employment record when the status changes instead of creating a historical record?
- Is there any API endpoint or audit/history table available to retrieve historical employee status changes?
- Is there a recommended way to reconstruct historical employee statuses for BI/reporting purposes?
- Are customers expected to build their own historization/snapshot logic externally?
The challenge is that without historical status information, Power BI reports cannot correctly show the employee status for past dates.
For example:
- Employee becomes LEAVE in January
- API now returns LEAVE as current status
- In Power BI, the employee incorrectly appears as LEAVE even for dates before January
Any guidance or best practices would be greatly appreciated.
https://developer.personio.de/reference/get_v2-persons-person-id-employments
