Symptom
This article aims clarifying the end dates of records added with the same effective date.
Please note that this logic applies to Job Information, Compensation Information, Position and Organization Information.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Employee Central
Reproducing the Issue
Let's work with the following scenario:
Two records are added effective of 1/1/2022. Another record is added effective of 2/1/2022.
When generating a Person and Employment Export, the first two records will get their end dates set to:
- Record "1 of 1": 1/1/2022
- Record "2 of 2": 1/31/2022
And the latest record will get its end date set to 12/31/9999:
Cause
As per the current product design, this is expected behavior.
Resolution
Having two records with the same end date is considered data quality issue, and therefore each record should have an unique end date.
Hence, please make sure to observe that when importing records with the same effective date, also. The order they are listed in the import file dictates which record will get the end date (following the previously shared scenario) on 1/1/2022 and which record will get the end date on 12/31/2022.
See Also
Data Validation for Job Information on History UI
Centralized Services for Employee Data Imports
2317955 - How to Correct or Remove Job Information Via Import in Full Purge Mode - EC
2494885 - Correct or Update Pay Component Recurring or Pay Component Non Recurring Information record via Import in Full Purge mode
2413486 - Correct/Update Compensation Information Record via Import in Full Purge Mode
Keywords
End Date, End Dates, Event Reason, Event, Event Date, Start Date, Job Information, Job Info, Multiple Records, Effective Date, Effective Dated Entity, Compensation Information, Position Information, Organization Information, Sequence Number, Import, UI, Update, Insert New Record, History, Audit, Export, Person and Employment, Report, Ad-Hoc , KBA , LOD-SF-EC-JOB , Job Information , LOD-SF-EC-POS , Position Management , LOD-SF-EC-CMP , Compensation Information & One-Time Bonus , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC-JOB-UI , History UI & MSS UI , LOD-SF-EC-CMP-UI , History or MSS UI , How To
Product
Attachments
Pasted image.jpg |