Loading Value Defined By Criteria for Annual Salaries

Use HCM Data Loader to calculate annual salaries for employees based on their position by defining conditions and values for salaries.

In this example and illustration,

If the employee is a Consultant, pay 45,000.
If the employee is a Senior Consultant, pay 55,000.
If the employee is a Principal Consultant, pay 65,000.

As shown in this illustration, consultants are paid 45,000. Senior consultants are paid 55,000 and principal consultants are paid 65,000.

This ValueDefinition.dat file loads the conditions and salary values.

METADATA|ValueDefinition|BaseName|DateMode|DefaultFlag|EffectiveEndDate|EffectiveStartDate|Expression|Periodicity|Sequence|ValueIdentifier|ValueSetCode1|ValueGroupName|CalculationTypeName|DatabaseItemName|DefaultCalculationTypeName|ParentValueDefinitionName|LegislativeDataGroupName|ValueDefinitionName|DisplayTag|CurrencyCode|Uom|RootValueDefinitionName
METADATA|RangeItem|EffectiveStartDate|EffectiveEndDate|LowValue|HighValue|Value1|LowValueText|LegislativeDataGroupName|ValueDefinitionName
MERGE|ValueDefinition|VBC_Job|E||4712/12/31|2020/01/01||||||Salary|Value By Criteria||Flat Amount||CRFL RRF LDG US1|VBC_Job||||VBC_Job
MERGE|ValueDefinition|Job_Consultant|E|N|4712/12/31|2020/01/01|=||1|||Salary|Node|PER_ASG_JOB_NAME||VBC_Job|CRFL RRF LDG US1|Job_Consultant||||VBC_Job
MERGE|ValueDefinition|Consultant_Salary|E||4712/12/31|2020/01/01||Year||||Salary|Flat Amount|||Job_Consultant|CRFL RRF LDG US1|Consultant_Salary||USD|M|VBC_Job
MERGE|ValueDefinition|VBC_Senior Consultant|E|N|4712/12/31|2020/01/01|=||2|||Salary|Node|PER_ASG_JOB_NAME||VBC_Job|CRFL RRF LDG US1|VBC_Senior Consultant||||VBC_Job
MERGE|ValueDefinition|Senior Consultant_Salary|E||4712/12/31|2020/01/01||Year||||Salary|Flat Amount|||VBC_Senior Consultant|CRFL RRF LDG US1|Senior Consultant_Salary||USD|M|VBC_Job
MERGE|ValueDefinition|VBC_Principal Consultant|E|N|4712/12/31|2020/01/01|=||3|||Salary|Node|PER_ASG_JOB_NAME||VBC_Job|CRFL RRF LDG US1|VBC_Principal Consultant||||VBC_Job
MERGE|ValueDefinition|Principal Consultant_Salary|E||4712/12/31|2020/01/01||Year||||Salary|Flat Amount|||VBC_Principal Consultant|CRFL RRF LDG US1|Principal Consultant_Salary||USD|M|VBC_Job
MERGE|RangeItem|2020/01/01|4712/12/31||||Consultant|CRFL RRF LDG US1|Job_Consultant
MERGE|RangeItem|2020/01/01|4712/12/31|0|999999999999|45000||CRFL RRF LDG US1|Consultant_Salary
MERGE|RangeItem|2020/01/01|4712/12/31||||Senior Consultant|CRFL RRF LDG US1|VBC_Senior Consultant
MERGE|RangeItem|2020/01/01|4712/12/31|0|999999999999|55000||CRFL RRF LDG US1|Senior Consultant_Salary
MERGE|RangeItem|2020/01/01|4712/12/31||||Principal Consultant|CRFL RRF LDG US1|VBC_Principal Consultant
MERGE|RangeItem|2020/01/01|4712/12/31|0|999999999999|65000||CRFL RRF LDG US1|Principal Consultant_Salary