Discussions

Ask a Question
Back to all

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:

  1. Does Personio overwrite the existing Employment record when the status changes instead of creating a historical record?
  2. Is there any API endpoint or audit/history table available to retrieve historical employee status changes?
  3. Is there a recommended way to reconstruct historical employee statuses for BI/reporting purposes?
  4. 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