Examples of Loading Progression Grade Rates
This topic provides examples showing how to load Progression Grade Rate objects using HCM Data Loader.
Creating Progression Grade Rates
In both examples in this section, the progression grade rate:
-
Uses grades without grade steps, and the rates are quoted as monthly amounts
-
Has the same name as its associated progression grade ladder
-
Has a RateType of
SALARY
, and the ProgressionRateFlag is set toY
to indicate that this rate is to be used for grade step progression
This example ProgressionGradeRate.dat file creates a Progression Grade Rate object using source keys.
METADATA|ProgressionGradeRate|SourceSystemOwner|SourceSystemId|EffectiveStartDate|GradeRateName|LegislativeDataGroupId(SourceSystemId)|RateType|CurrencyCode|RateFrequency|ActiveStatus|AnnualizationFactor|ProgressionRateFlag|GradeLadderId(SourceSystemId)
MERGE|ProgressionGradeRate|VISION|GSP_DEVELOPMENT_GR|2000/02/15|GSP Development|GSP_US_LDG1|SALARY|USD|MONTHLY|A|12|Y|GSP_DEVELOPMENT
METADATA|ProgressionGradeRateValue|SourceSystemOwner|SourceSystemId|EffectiveStartDate|LegislativeDataGroupId(SourceSystemId)|RateId(SourceSystemId)|RateObjectId(SourceSystemId)|MinimumAmount|MaximumAmount|ValueAmount
MERGE|ProgressionGradeRateValue|VISION|GSP_DEVELOPMENT_GRV1|2000/02/15|GSP_US_LDG1|GSP_DEVELOPMENT_GR|DEV1_GSP|3500|6500|5000
MERGE|ProgressionGradeRateValue|VISION|GSP_DEVELOPMENT_GRV2|2000/02/15|GSP_US_LDG1|GSP_DEVELOPMENT_GR|DEV2_GSP|4500|7500|6000
MERGE|ProgressionGradeRateValue|VISION|GSP_DEVELOPMENT_GRV3|2000/02/15|GSP_US_LDG1|GSP_DEVELOPMENT_GR|DEV3_GSP|5500|8500|7000
MERGE|ProgressionGradeRateValue|VISION|GSP_DEVELOPMENT_GRV4|2000/02/15|GSP_US_LDG1|GSP_DEVELOPMENT_GR|DEV4_GSP|6500|9500|8000
MERGE|ProgressionGradeRateValue|VISION|GSP_DEVELOPMENT_GRV5|2000/02/15|GSP_US_LDG1|GSP_DEVELOPMENT_GR|DEV5_GSP|7500|10500|9000
MERGE|ProgressionGradeRateValue|VISION|GSP_DEVELOPMENT_GRV6|2000/02/15|GSP_US_LDG1|GSP_DEVELOPMENT_GR|DEV6_GSP|8500|11500|10000
This example ProgressionGradeRate.dat file creates a Progression Grade Rate object using user keys.
METADATA|ProgressionGradeRate|EffectiveStartDate|RateType|GradeRateName|GradeLadderName|CurrencyCode|RateFrequency|AnnualizationFactor|ActiveStatus|LegislativeDataGroup|ProgressionRateFlag
MERGE|ProgressionGradeRate|2010/01/01|Salary|GSP Staff|GSP Staff|USD|Monthly|12|A|GBI United States LDG|Y
METADATA|ProgressionGradeRateValue|EffectiveStartDate|MinimumAmount|MaximumAmount|MidValueAmount|ValueAmount|GradeRateName|SetCode|GradeCode|LegislativeDataGroup
MERGE|ProgressionGradeRateValue|2010/01/01|2000|5000|3500|3000|GSP Staff|COMMON|STAFF1|GBI United States LDG
MERGE|ProgressionGradeRateValue|2010/01/01|4000|6000|5000|4500|GSP Staff|COMMON|STAFF2|GBI United States LDG
MERGE|ProgressionGradeRateValue|2010/01/01|5000|8000|6500|5800|GSP Staff|COMMON|STAFF3|GBI United States LDG
MERGE|ProgressionGradeRateValue|2010/01/01|6000|9000|7500|6200|GSP Staff|COMMON|STAFF4|GBI United States LDG
Deleting Progression Grade Rates
When you delete a progression grade rate, its grade rate values are also deleted. You can delete a progression grade rate using HCM Data Loader if another object, such as a salary basis, isn't referencing it. If the progression grade rate is used in a progression grade ladder, then delete it only if you're also deleting the related progression grade ladder.
This example ProgressionGradeRate.dat file deletes a progression grade rate, which is identified using source keys.
METADATA|ProgressionGradeRate|SourceSystemOwner|SourceSystemId|LegislativeDataGroupId(SourceSystemId)
DELETE|ProgressionGradeRate|VISION|GSP_DEVELOPMENT_GR|GSP_US_LDG1
This example ProgressionGradeRate.dat file deletes a progression grade rate, which is identified using user keys.
METADATA|ProgressionGradeRate|LegislativeDataGroup|GradeRateName
DELETE|ProgressionGradeRate|GBI United States LDG|GSP Staff