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.
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