Compound Employee Query does not retrieve multiple events included on the same day.
SuccessFactors Employee Central.
Reproducing the Issue
1. Make multiple changes on any employee on the same day (Note that every change made on the same day will be described as "3 of 4", "4 of 4"):
2. Run a Query and try to retrieve the information on the record 3 of 4, the responde will be like the below example, you can only see the last sequence number for all the changes made on that day:
Each record has a transaction sequence number. The record with the highest sequence number contains the business data for the time slice. Only the job data or compensation data of the time slice with the highest sequence number is considered.
You can see the changes made on the Employee Central UI but Compound Employee Queries does not inform all the changes made on a day, you can only see the record of the last sequence number, thats the expected behavior of Compound Employee. If you use Delta on the Query, you will see how many sequence number you had on a day, but you can't get the information of each one.
This information is on the Work Book: Implementing the Employee Central Compound Employee API in Delta Transmission Mode, you can check on the link below on the see also section.
As a workaround you can retrieve the information using OData, you can get the information from the same entity the record for each sequence number for the above example.
Compound Employee Query does not retrieve multiple events included on the same day, only last sequence number compound employee, compound employee sequence number, sequence number, last sequence number. , KBA , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , How To