Example of Loading Rate Definitions for Basic Salary

Use HCM Data Loader to create a primary rate for a basic salary. The salary rate for an employee is displayed on the salary page or used for other purposes, such as a contributor to an absence rate.

Before You Begin

Use HCM Data Loader to create the salary element at the assignment level. The salary element entries contain the information to be retrieved by the salary rate definition for an employee. You can create it using the flat amount or factor calculation rule.

Use this RateDefinitionV2.dat file to create a rate definition and load these values:

Attribute

Value

Category

Element

StorageType

Amount

ElementCode

Regular Salary

ReturnRatePeriodicity

Annually

ConversionFormulaCode

Standard Rate Annualized

ReturnRateCurrency

USD

LegislativeDataGroupName

CRFL RRF LDG US1

METADATA|RateDefinitionV2|RateDefinitionCode|ConversionFormulaCode|ContributorTotalPeriodicity|ReturnRatePeriodicity|EffectiveStartDate|LegislativeDataGroupName|ShortName|Category|SourceSystemId|SourceSystemOwner|ReturnRateCurrency|ElementCode|Status|BaseSalaryFlag|ReturnDecimalDisplay|ReturnRoundingRule|StorageType|OverrideAllowed|ReturnFullTimeRateFlag|ReportingRateFlag|CalculateLiveRatesFlag|Description|RateDefinitionName
MERGE|RateDefinitionV2|Basic_Salary|Standard Rate Annualized|Annually|Annually|2020/01/01|US LDG|Basic_Salary|ET|RateElement_001|VISION|USD|Regular Salary|A|Y|6|D|A|Y|Y|Y|Y|Basic_Salary|Basic_Salary
METADATA|RateContributorV2|EmploymentLevel|ContributorType|ContributorInputValueCode|EffectiveStartDate|Feed|LegislativeDataGroupName|RateDefinitionCode|SequenceNumber|ReturnFullTimeRateFlag|SourceSystemId|SourceSystemOwner
MERGE|RateContributorV2|Payroll Assignment|IV|Amount|2020/01/01|1|US LDG|Basic_Salary|1|Y|RateElement_001|VISION