A query to the EmpEmploymentTermination entity returns no record related to an employee which had been terminated in the past, but is now rehired and active.
NOTE: Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
SAP SuccessFactors HXM Suite
- Employee Central
- OData API
Reproducing the Issue
Sample terminated employee with personIdExternal '123':
Querying EmpEmploymentTermination of this employee will return a record:
GET https://<apiURL>/odata/v2/EmpEmploymentTermination?$filter= personIdExternal eq '123'
Now, if the employee is rehired, the same query to EmpEmploymentTermination will not return any record:
Working as designed.
The data of EmpEmploymentTermination is a subset of EmpEmployment, with condition "endDate != null". Once an employee is terminated, the value of endDate will be filled and the termination data is available under EmpEmploymentTermination. However once the employee is rehired, no matter the rehire date is the past or future, the value of endDate will be reset to null. Then this record is unavailable under EmpEmploymentTermination.
Since EmpEmployment and EmpEmploymentInformation are not effective-dated entities, they also do not keep a history of termination data. So supposing the following scenario:
- Employee terminated
- Employee rehired
- Employee terminated again
Only the latest termination details can be queried via OData API. The data from the first termination is replaced by the the second termination.
termination, ec, employment, odata, api, query, blank, null, no, result, missing, record , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , Problem