SAP Knowledge Base Article - Public

2084020 - Manage Data - Admin 101 Importing Compensation Employee Data - Compensation

Symptom

  • Summary of importing your compensation employee data. Compensation employee data is imported by uploading it in CSV format as part of the user import spreadsheet. Your SuccessFactors Consultant will provide the correct data file format and data file requirements. To make corrections, you may want to export the data, adjust, and re-import.
     
     
  • How to import, update, delete compensation employee data?

*images taken from demo instance*

Environment

  • Compensation

Resolution

Managing User Data

  • As an administrator, you can navigate to the import/export user data screens in two ways.
  1. From the main Admin Tools screen under the Manage Employees section. Click on Employee Import or Employee Export

       1.png 1.png

  1. From the Compensation Admin 2.0 Home page. Navigate to the Actions for all plans screen.

          2.png 2.png

      Both methods bring you to the same screen.

Employee Import

  • Compensation data is imported by uploading it in CSV format as part of the user import spreadsheet. Your SuccessFactors Consultant will provide the correct data file format and data file requirements. To make corrections, you may want to export the data, adjust, and re-import.
     
  • In Actions for all Plans, under Import/Export Data, go to All Plans dropdown and select Employee Data Import.

       3.png 3.png

  •  Once on the Employee Import screen, follow these steps to import your employee data file. Numbered items are explained in more detail below.

 4.png

  1. Select Browse; choose the CSV file to import; then select Validate Import File. If no errors, select Browse, and choose the file again.

Note: During b1911 release, required fields should now be added in the import file even when importing from Compensation Admin page. The list of required fields can be found in the "Managing User Information" guide under Field Requirements for the User Data File section.

    2. Depending on your process, you should check all or some of the following boxes in the Specify Form routing options.

  • Do Not Transfer Documents

- OR -
Automatic insertion of new manager as next document recipient if not already.

Note: Checking this option will change the route of already-created compensation forms to include the new second-level manager. This could ADD a new step to the route map if the new manager is not already included in the next step of the route map.

  • Automatic Inbox document transfer to new manager.
     
  • Automatic En Route document transfer to new manager.
     
  • Automatic Completed document transfer to new manager.

**Important Point to remember about the form routing options:

Automatic Manager Transfer – The compensation module is different than other SuccessFactors modules. The “Manager” in the case of automatic manager transfer is the manager of the compensation planner. In order to transfer employees between launched forms, you will need to select Update Compensation Forms.

  1. Update Compensation Forms

          Warning! Never use this feature without understanding the impacts. There is no undo button. This will trigger an update to ALL fields that are reloadable with whatever data now exists in your system.
 

    5.png

  •  Once you select Update Compensation forms, additional options are presented:

  6.png

 

 

 

Employee Export

  • In Actions for all Plans, under Import/Export Data, go to All Plans dropdown and select Employee Data Export.

        7.png

  •  Once on the Employee Data Export screen, follow these steps to export employee data:

     8.png

 

  1. Confirm the CSV format is selected.
     
  2. Check the Include User Compensation Data checkbox. To include all relevant compensation data in the file including eligibility information, select both checkboxes as shown in the screenshot above. Make sure to select the form template name. You can select more than one template at a time by holding the CTRL key while clicking template names.
     
  3. Click Export User File. You are prompted to either run or save a zipped version of the CSV file.

Keywords

KBA , sf compensation manage data , LOD-SF-CMP , Compensation Management , How To

Product

SAP SuccessFactors HXM Core all versions