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