Load Rate Definitions for Overall Salary
Using HCM Data Loader, you load a rate definition for overall salary that includes multiple rate contributors.
You do these actions.
-
Load the overall salary rate definition
-
Add the regular salary rate contributor
-
Add the car allowance rate contributor
This table summarizes the key decisions for your scenario.
Decision to Consider |
In This Example |
---|---|
What components of pay should be included in an employee's overall salary? |
|
Should I include all pay for car allowance in the overall salary? |
No. Only include 50 percent of the amount paid for car allowance. |
Overall Salary
Using HCM Data Loader, you load the overall salary rate definition as shown in this table:
Attribute |
Value |
---|---|
Category |
Derived Rate |
RateDefinitionName |
Overall Salary |
ElementCode |
Salary |
Periodicity |
Weekly |
ConversionFormulaCode |
Standard Rate Annualized |
ReturnedRateCurrency |
USD |
LegislativeDataGroupName |
US LDG |
Regular Salary Rate Contributor
This table provides the values that you provide when loading the regular salary rate contributor.
Attribute |
Value |
---|---|
Add or Subtract |
Add |
Employment Level |
Payroll Assignment |
Periodicity |
Weekly |
Car Allowance Rate Contributor
This table provides the values that you provide when loading the car allowance rate contributor.
Attribute |
Value |
---|---|
Add or Subtract |
Add |
Rate Name |
Car Allowance |
Periodicity |
Weekly |
Factor Rule |
Value |
Factor Value |
0.5 |
This RateDefinitionV2.dat file loads the overall salary rate definition and the two contributors - Regular Salary and Car Allowances.
METADATA|RateDefinitionV2|RateDefinitionCode|ConversionFormulaCode|ContributorTotalPeriodicity|ReturnRatePeriodicity|EffectiveStartDate|LegislativeDataGroupName|ShortName|Category|SourceSystemId|SourceSystemOwner|ReturnRateCurrency|ElementCode|Status|ReturnDecimalDisplay|ReturnRoundingRule|OverallSalaryFlag|ReturnFullTimeRateFlag|ProcessContributorTotalFteFlag|ReportingRateFlag|EmploymentLevel|CalculateLiveRatesFlag|Description|RateDefinitionName
MERGE|RateDefinitionV2|Rate def_DRT_OverallSal|Standard Rate Annualized|Weekly|Weekly|2020/01/01|US LDG|Rate def_DRT_OverallSal|DRT|RateElement_DRT_001|VISION|USD|AL_CDRM_Element_Rate|A|8|U|Y|Y|Y|Y|Payroll Assignment|N|Rate def_DRT_OverallSal|Rate def_DRT_OverallSal
METADATA|RateContributorV2|ContributorType|ContributorRateDefinitionCode|EffectiveStartDate|Feed|LegislativeDataGroupName|Periodicity|RateDefinitionCode|SequenceNumber|RateContributorId|ReturnFullTimeRateFlag|SourceSystemId|SourceSystemOwner
MERGE|RateContributorV2|RD|Basic_Salary|2020/01/01|1|US LDG|Weekly|Rate def_DRT_OverallSal|1||Y|RateCont_DRT_030|VISION
MERGE|RateContributorV2|RD|Rate Def_Factor_Value|2020/01/01|1|US LDG|Weekly|Rate def_DRT_OverallSal|2||Y|RateCont_DRT_031|VISION