Loading Value Defined By Criteria for Annual Salaries
Use HCM Data Loader to calculate annual salaries for employees based on their position by defining conditions and values for salaries.
In this example and illustration,
-
If the employee is a Consultant, pay 45,000.
-
If the employee is a Senior Consultant, pay 55,000.
-
If the employee is a Principal Consultant, pay 65,000.
This ValuesDefinedByCriteria.dat file loads the conditions and salary
values. The Salary value definition group must be already available in the application.
METADATA|ValuesDefinedByCriteria|ValuesDefinedByCriteriaCode|EffectiveStartDate|EffectiveEndDate|LegislativeDataGroupName|ValueDefinitionGroupCode|ValuesDefinedByCriteriaName|DefaultCalculationTypeCode|PeriodOrUnit|RetrievalDateType
METADATA|Criteria|CriteriaCode|EffectiveStartDate|EffectiveEndDate|CriteriaName|RetrievalDateType|DisplayName|Operand|Sequence|ValueSetCode|LegislativeDataGroupName|ValueDefinitionGroupCode|DatabaseItemCode|DefaultCriteriaFlag|ValuesDefinedByCriteriaCode|ParentCriteriaCode
METADATA|LiteralValuesForCriteria|EffectiveStartDate|EffectiveEndDate|LiteralValue|LegislativeDataGroupName|CriteriaCode
METADATA|ValueDetails|ValueCode|EffectiveStartDate|EffectiveEndDate|ValueName|ValueIdentifier|RetrievalDateType|Uom|Currency|ValuesDefinedByCriteriaCode|CriteriaCode|ValueDefinitionGroupCode|CalculationTypeCode|LegislativeDataGroupName|MultiplierOrCondition|Periodicity
METADATA|CalculationValues|EffectiveStartDate|EffectiveEndDate|OverrideCalculationTypeCode|FlatAmountValue|FlatCalculationValueDefnCode|FlatRateValue|IncrementalRateValue|NumberValue|TextValue|RateDefinitionCode|ValueIdentifier|LegislativeDataGroupName|ValueCode|FromValue|ToValue
MERGE|ValuesDefinedByCriteria|VBC_Job|2020/01/01|4712/12/31|CRFL RRF LDG US1|Salary|VBC_Job|Flat Amount|P|E
MERGE|Criteria|Job_Consultant|2020/01/01|4712/12/31|Job_Consultant|E||=|1||CRFL RRF LDG US1|Salary|PER_ASG_JOB_NAME|N|VBC_Job|VBC_Job
MERGE|Criteria|Senior_Consultant|2020/01/01|4712/12/31|Senior_Consultant|E||=|2||CRFL RRF LDG US1|Salary|PER_ASG_JOB_NAME|N|VBC_Job|VBC_Job
MERGE|Criteria|Principal_Consultant|2020/01/01|4712/12/31|Principal_Consultant|E||=|3||CRFL RRF LDG US1|Salary|PER_ASG_JOB_NAME|N|VBC_Job|VBC_Job
MERGE|LiteralValuesForCriteria|2020/01/01|4712/12/31|Consultant|CRFL RRF LDG US1|Job_Consultant
MERGE|LiteralValuesForCriteria|2020/01/01|4712/12/31|Senior Consultant|CRFL RRF LDG US1|Senior_Consultant
MERGE|LiteralValuesForCriteria|2020/01/01|4712/12/31|Principal Consultant|CRFL RRF LDG US1|Principal_Consultant
MERGE|ValueDetails|Consultant_Salary|2020/01/01|4712/12/31|Consultant_Salary||E|M|USD|VBC_Job|Job_Consultant|Salary|Flat Amount|CRFL RRF LDG US1||Year
MERGE|ValueDetails|Senior_Consultant_Salary|2020/01/01|4712/12/31|Senior_Consultant_Salary||E|M|USD|VBC_Job|Senior_Consultant|Salary|Flat Amount|CRFL RRF LDG US1||Year
MERGE|ValueDetails|Principal_Consultant_Salary|2020/01/01|4712/12/31|Principal_Consultant_Salary||E|M|USD|VBC_Job|Principal_Consultant|Salary|Flat Amount|CRFL RRF LDG US1||Year
MERGE|CalculationValues|2020/01/01|4712/12/31||45000||||||||CRFL RRF LDG US1|Consultant_Salary|0|999999999999
MERGE|CalculationValues|2020/01/01|4712/12/31||55000||||||||CRFL RRF LDG US1|Senior_Consultant_Salary|0|999999999999
MERGE|CalculationValues|2020/01/01|4712/12/31||65000||||||||CRFL RRF LDG US1|Principal_Consultant_Salary|0|999999999999