Examples of Loading Salary Records

Here are examples of how you can load and manage salary records for a person's work assignment using HCM Data Loader.

Create a Salary Using Source Keys

This example Salary.dat file creates a Salary object with components for an existing assignment. The file identifies both the Salary object and the linked assignment by their source keys.

METADATA|Salary|SourceSystemOwner|SourceSystemId|AssignmentId(SourceSystemId)|DateFrom|SalaryAmount|SalaryBasisName|ActionCode|SalaryApproved|MultipleComponents
MERGE|Salary|VISION|1012SAL15|1012_EMP_ASG|2015/01/01|65000|SalBasis_1007|CHANGE_SALARY|Y|N
METADATA|SalaryComponent|SourceSystemOwner|SourceSystemId|SalaryId(SourceSystemId)|DateFrom|ComponentReasonCode|ChangeAmount|ComponentApproved
MERGE|SalaryComponent|VISION|1012SAL15_COL|1012SAL15|2015/01/01|COST_OF_LIVING|60000|Y
MERGE|SalaryComponent|VISION|1012SAL15_ADJ|1012SAL15|2015/01/01|ADJUSTMENT|5000|Y

Update a Salary Using Source Keys

This example Salary.dat file updates an existing, open-ended salary record by supplying changes to the Salary object and its components. The file identifies all components by their source keys.

METADATA|Salary|SourceSystemOwner|SourceSystemId|AssignmentId(SourceSystemId)|DateFrom|DateTo|SalaryAmount|SalaryBasisName|ActionCode|SalaryApproved|MultipleComponents
MERGE|Salary|VISION|1012SAL16|1012_EMP_ASG|2016/01/01||70000|SalBasis_1007|CHANGE_SALARY|Y|N
METADATA|SalaryComponent|SourceSystemOwner|SourceSystemId|SalaryId(SourceSystemId)|DateFrom|ComponentReasonCode|ChangeAmount|ComponentApproved
MERGE|SalaryComponent|VISION|1012SAL16_COL|1012SAL16|2016/01/01|COST_OF_LIVING|5000|Y
MERGE|SalaryComponent|VISION|1012SAL16_ADJ|1012SAL16|2016/01/01|ADJUSTMENT|0|Y

Create a Salary Using User Keys

This example Salary.dat file creates a Salary object with components, for an assignment. The file identifies both the Salary object and the linked assignment using user keys.

METADATA|Salary|AssignmentNumber|DateFrom|SalaryAmount|SalaryBasisName|ActionCode|SalaryApproved|MultipleComponents
MERGE|Salary|1014|2015/01/01|53500|SalBasis_1007|CHANGE_SALARY|Y|N
METADATA|SalaryComponent|AssignmentNumber|DateFrom|ComponentReasonCode|ChangeAmount|ComponentApproved
MERGE|SalaryComponent|1014|2015/01/01|COST_OF_LIVING|52000|Y
MERGE|SalaryComponent|1014|2015/01/01|ADJUSTMENT|1500|Y 

Update a Salary Using User Keys

This example Salary.dat file updates an existing, open-ended salary record by supplying changes to the Salary object and its components. The file identifies all components using user keys.

METADATA|Salary|AssignmentNumber|DateFrom|DateTo|SalaryAmount|SalaryBasisName|ActionCode|SalaryApproved|MultipleComponents
MERGE|Salary|1014|2016/01/01||53900|SalBasis_1007|CHANGE_SALARY|Y|N
METADATA|SalaryComponent|AssignmentNumber|DateFrom|ComponentReasonCode|ChangeAmount|ComponentApproved
MERGE|SalaryComponent|1014|2016/01/01|COST_OF_LIVING|300|Y
MERGE|SalaryComponent|1014|2016/01/01|ADJUSTMENT|100|Y

Delete a Salary

Delete salary records using HCM Data Loader only if many records were created or loaded incorrectly and need to be deleted in bulk. Unless you're deleting all salary records for an assignment, you can delete only the salary record with the most recent salary start date. For example, if a salary record has salary start dates of January 1, March 1, and September 1 then you can delete only the September 1 record. Or, you can delete all three records.

This example Salary.dat file deletes an existing salary record. The file identifies the Salary object by its source key.

METADATA|Salary|SourceSystemOwner|SourceSystemId|AssignmentId(SourceSystemId)|DateFrom
DELETE|Salary|VISION|1012SAL16|EJ1012_EMP_ASG|2016/01/01

This example Salary.dat file deletes an existing salary. The file identifies the Salary object by its user key.

METADATA|Salary|AssignmentNumber|DateFrom
DELETE|Salary|1014|2016/01/01

Purge Salaries for an Assignment

Purge all the salary records for an assignment in bulk using HCM Data Loader and the PurgeAssignmentSalary attribute. You supply the delete command for the salary record with the most recent salary start date. For example, if the assignment has salary records with salary start dates of January 1, March 1, and September 1, you use the delete command with the September 1 salary. When you load the delete command, all three of salary records get purged.

This example Salary.dat file purges all the existing salary records of the assignment. The file identifies the Salary object by the assignment number.

METADATA|Salary|AssignmentNumber|PurgeAssignmentSalary|DateFrom
DELETE|Salary|E966169008889157|Y|2021/01/01