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

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?

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: The Validate Import File option will check for missing values in required fields and validate the MANAGER and HR fields contain valid, active users. If your company plans to import two separate data files (one for core user data and another for compensation data), your consultant may have disabled this validation on import. Disabling the validation on import will allow you to load a simplified file with compensation data only. In this situation, you may see errors such as ‘Missing value in Email field’ when running Validate Import File, but not when actually importing your file. Please discuss your set-up with your consultant

  1. 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 HCM Core all versions