Guidelines for Loading Incremental Salary Components with Salaries Using HCM Data Loader

You can supply incremental component information when loading salaries using the Salary.dat file and HCM Data Loader. You need to set the ComponentReasonCode attribute. Valid values are in the CMP_SALARY_COMPONENTS lookup type.

Use the Manage Base Pay Lookups task in the Setup and Maintenance work area to manage the CMP_SALARY_COMPONENTS lookup type. You can use each component reason code only once for each salary.

The first salary that you load for a worker needs to have the SalaryAmount attribute value equaling the sum of the incremental component values. For later salary adjustments to account for changes, the sum of the component amounts plus the previous salary amount need to equal the new salary amount. Here’s what to set for component amounts depending on how adjustments relate to FTE:

• When you're not increasing or decreasing the new salary amount beyond the FTE change, enter 0 for the component change amounts.
• When you're adjusting salary to account for FTE changes and another increase or decrease, you need to provide non0 change amounts. Also, enter the new salary amount that accounts for the FTE change and 0 for the adjusted salary amount. For example, the current FTE is 1 and the salary is $100. As of January 1 of the next year, the FTE changes to 0.8, which means the new salary should be $80.

Specify a ChangeAmount value for each component. You add the ChangeAmount value to the base pay amount to derive the new salary amount for the salary. The corresponding percentage value is calculated automatically. Here’s what you provide for a new salary amount adjusted for FTE:

• $0 for the component amount
• $80 for the salary amount

To reduce or increase the new salary amount beyond $80, you need to provide the change amount for the relevant components. You also need to provide the new salary amount.