Symptom
This article aims clarifying the end dates of records added with the same effective date. 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 HCM Suite
- 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.
Important:
- Manually maintaining end-date can lead to data inconsistencies and UI errors.
- Please leave the end-date column blank in all EC related import files.
- The system will calculate the correct end-date to use to ensure there are no gaps in the Effective Dated data structure.
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 |
| Pasted image.jpg |
SAP Knowledge Base Article - Public