SAP Knowledge Base Article - Public

3201077 - Employee Central End Dates Explained

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

SAP SuccessFactors HXM Suite 2205

Attachments

Pasted image.jpg