Load Compensation Data - Step 2 - Select Type

The ability to perform Compensation loads using Data Load Wizard (DLW) will begin to be deprecated with the November 2022 Release. Data Load Wizard Compensation loads include Employee Salary, Salary Structure and Individual Targets.

Data Load Wizard is a legacy data load tool, built on older technology, with limited load type support, a dated interface, and slow performance. Edge Import addresses these issues with a modern interface and an intuitive workflow that can support a greater number of concurrent loads, while providing administrators with a delightful user experience.

To begin loading compensation data, you must first select the type of data you are loading. This ensures that the data is loaded into the correct location.

The available types are:

  • Employee Salary - This data type enables administrators to load information about the user's salary, wage type, and effective date. Existing salary data can be updated and new salary data can be created via the Data Load Wizard. Any updates to existing salary data are tracked in the employee salary history. The Last Updated value is recorded as the date on which the data was loaded. The Last Updated By value is recorded as the administrator who performed the data load.
    • Each unique combination of User ID and Effective Date creates a record. If a combination of User ID and Effective ID is loaded that matches an existing combination, then the data that is loaded overwrites the existing data. Use cases are provided on the Upload topic. See Load Compensation Data - Step 3 - Upload.
  • Individual Targets - This data type enables administrators to load individual user targets such as Bonus, ISO, LTI, NQO, RSA, and custom bonus types that have been configured in the portal. Existing individual target data can be updated and new individual target data can be created via the Data Load Wizard.
    • Each unique combination of User ID, Target Type, Target Name, and Target Date creates a record. If a combination of User ID, Target Type, Target Name, and Target Date is loaded that matches an existing combination, then the data that is loaded overwrites the existing data. Use cases are provided on the Upload topic. See Load Compensation Data - Step 3 - Upload.
  • Salary Structure - This data type enables administrators to load salary ranges that are set for primary and secondary OUs. Minimum and maximum ranges can be set. Also, administrators can set the wage type. Existing salary structure data can be updated and new salary structure data can be created via the Data Load Wizard. Any updates to existing salary structure data are tracked in the Modification History section on the Salary Structure administration page. The Modified By value is recorded as the administrator who performed the data load. The Last Updated value is recorded as the date on which the data was loaded.
    • When a Secondary OU is provided, each unique combination of Primary OU, Secondary OU, and Wage Type creates a record. If a combination of Primary OU, Secondary OU, and Wage Type is loaded that matches an existing combination, then the data that is loaded overwrites the existing data. Use cases are provided on the Upload topic. See Load Compensation Data - Step 3 - Upload.
    • When a Secondary OU is not provided, each unique combination of Primary OU and Wage Type creates a record. If a combination of Primary OU and Wage Type is loaded that matches an existing combination, then the data that is loaded overwrites the existing data. Use cases are provided on the Upload topic. See Load Compensation Data - Step 3 - Upload.

After selecting the appropriate data type, click Next to proceed to the Upload step. See Load Compensation Data - Step 3 - Upload.