2818933 - How to Import End Dated Payments

As detailed in KBA 2473623 - Employee Central: How to enable End Dated Payments feature, the End Dated Payment Feature is a UI only feature and currently does not trigger on imports.

You are able to achieve the same desired effect via a series of imports, the order of which is covered in this KBA

• SAP SuccessFactors HXM Suite
• SAP SuccessFactors Employee Central

To import end dated payments, you must create two compensation information records on the start date and one on the end date.
You must then carry out two pay component recurring imports, one to add the desired pay component and one to remove it on the end date using the DELIMIT Operator.

Please review the Resolution Section for detailed steps on how to prepare your import files and carry out the imports in the correct order.

Prepare Compensation Information Import Files:

Here you will be doing a report and preparing an import file for the current Compensation Information for the desired employee(s).

1. Build a Table Report on the "Person and Employment Export" domain and select "Compensation Information" fields for the desired employee(s).
2. Export the Compensation Information data
3. Filter on the Effective End Date 31/12/9999 to get the "latest" records and copy into a new compInfo import template (will end up with 1 compInfo row per user)
4. In this newly prepared import file, remove the endDate value and seq-number value so they are blank
5. Make a copy of this import file for later (so you will have 1 compInfo import file for where the Pay Component gets added, and another where it is removed)

Prepare Pay Component Recurring Import Files:

Here you will be building a report and preparing an import file for the current Pay Component Recurring for the desired employee(s).

1. Build a Table Report on the "Person and Employment Export" domain and select "Pay Component Recurring" data for the desired employee(s).
2. Export the Pay Component Recurring data
3. Filter on the Effective End Date 31/12/9999 to get the "latest" records and copy into a new payComponentRecurring import template (will have 1 row per Pay Component, so possibly multiple rows for each user)
4. In this newly prepared import file, remove the endDate value (so it is blank) but set seq-number value to 1
5. Make a copy of this import file for later (so you will have 1 payComponentRecurring import file for where the Pay Component gets added, and another where it is removed)

Import the Compensation Information Import Files:

Here you will be importing the Compensation Information Files; one file for the date the pay component will be added and one for the date the pay component will be removed.

1. Then import the compInfo records with the 2 import files:
   - One of the files should have start date of where the Pay Component is assigned
   - One of the files should have a start date of where the Pay Component is no longer assigned
2. Import each of the files in order - waiting for 1st file to complete before importing 2nd
3. Then go to Profile and check your user -  they will have 2 new Comp Info records but without any Pay Components assigned to them

Import the Pay Component Recurring Files:

Here you will be importing the Pay Component Recurring Files; one file were you are adding the pay component to the list of pay components for this user on the add date and one for when you are removing (delimit) the pay component from the list of pay components for this user on the end date

1. Then import the payComponentRecurring records with the 2 import files:
   - 1st import file should have a start date AND seq-number corresponding with the 1st compInfo import file - this is the file where you have to add the extra row for the new Pay Component being assigned to the employee
   - 2nd import file should have a start date AND seq-number corresponding with the 2nd compInfo import file - this is the file where you remove the end dated pay component. This is done, by including the DELIMIT operator on the row for the specified pay component.
2. Import the 1st file - then go check the Profile for the user  - verify that the 1st compInfo record now has correct Pay Components
3. Import the 2nd file - then go check in Profile for the user - verify that the 2nd compInfo record has Pay Components where the desired pay component has been removed.

• 2473623 - Employee Central: How to enable End Dated Payments feature
• Employee Central Imports - What is the DELIMIT value?

ECT-59054, end-dated payment, end dated payment, payComponentRecurring, ECT-74068, Payment End Date, ECT- 72868,  Event reason for end-dated payments, missing, ECT-69238, import , KBA , LOD-SF-EC-CMP , Compensation Information & One-Time Bonus , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , How To

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions