Loading Allowance Payments Based on Percentage of Salary

Use HCM Data Loader to calculate allowance payments that are based on a percentage of salary. The percentage rate is based on a condition, such as worker's location.

Here are some criteria that you could use:

For workers at location A, apply a percentage of 25% (0.25)
For workers at the location B, apply a percentage of 50% (0.50)
For workers at the location C, apply a percentage of 75% (0.75)

Note: You must set the default calculation type as Number.

This figure shows the criteria that you can use to calculate the percentage rate.

For workers at location A, a percentage of 25% (0.25) of salary is applied to calculate allowance payments. For workers at the location B, a percentage of 50% (0.50) of salary is applied. For workers at the location C, a percentage of 75% (0.75) is applied.

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

MERGE|ValueDefinition|VBC_Percent_Salary|E||4712/12/31|2020/01/01||||||Salary|Value By Criteria||Number||CRFL RRF LDG US1|VBC_Percent_Salary||||VBC_Percent_Salary
MERGE|ValueDefinition|VBC_Location A|E|N|4712/12/31|2020/01/01|=||1|||Salary|Node|PER_ASG_LOCATION_NAME||VBC_Percent_Salary|CRFL RRF LDG US1|VBC_Location A||||VBC_Percent_Salary
MERGE|ValueDefinition|Location A Percentage|E||4712/12/31|2020/01/01||Year||||Salary|Number|||VBC_Location A|CRFL RRF LDG US1|Location A Percentage|||N|VBC_Percent_Salary
MERGE|ValueDefinition|VBC_Location B|E|N|4712/12/31|2020/01/01|=||2|||Salary|Node|PER_ASG_LOCATION_NAME||VBC_Percent_Salary|CRFL RRF LDG US1|VBC_Location B||||VBC_Percent_Salary
MERGE|ValueDefinition|Location B Percentage|E||4712/12/31|2020/01/01||Year||||Salary|Number|||VBC_Location B|CRFL RRF LDG US1|Location B Percentage|||N|VBC_Percent_Salary
MERGE|ValueDefinition|VBC_Location C|E|N|4712/12/31|2020/01/01|=||3|||Salary|Node|PER_ASG_LOCATION_NAME||VBC_Percent_Salary|CRFL RRF LDG US1|VBC_Location C||||VBC_Percent_Salary
MERGE|ValueDefinition|Location C Percentage|E||4712/12/31|2020/01/01||Year||||Salary|Number|||VBC_Location C|CRFL RRF LDG US1|Location C Percentage|||N|VBC_Percent_Salary
MERGE|RangeItem|2020/01/01|4712/12/31||||A|CRFL RRF LDG US1|VBC_Location A
MERGE|RangeItem|2020/01/01|4712/12/31|0|999999999999|0.25||CRFL RRF LDG US1|Location A Percentage
MERGE|RangeItem|2020/01/01|4712/12/31||||B|CRFL RRF LDG US1|VBC_Location B
MERGE|RangeItem|2020/01/01|4712/12/31|0|999999999999|0.5||CRFL RRF LDG US1|Location B Percentage
MERGE|RangeItem|2020/01/01|4712/12/31||||C|CRFL RRF LDG US1|VBC_Location C
MERGE|RangeItem|2020/01/01|4712/12/31|0|999999999999|0.75||CRFL RRF LDG US1|Location C Percentage