Examples of Loading Progression Grade Ladders Without Steps

Here are examples of how you can load Progression Grade Ladder objects without steps.

Create a Progression Grade Ladder Without Steps Using Source Keys

This example ProgressionGradeLadder.dat file creates a progression grade ladder where the grades don't have steps. The file includes Progression Grade Ladder and Grades In Progression Grade Ladder components. Both components use source keys. The rates are defined separately using Progression Grade Rate objects.

This excerpt shows the Progression Grade Ladder component.

METADATA|ProgressionGradeLadder|SourceSystemOwner|SourceSystemId|EffectiveStartDate|GradeLadderName|GradeType|ActiveStatus|GradeSetCode|AllowProgOverrideFlag|AllowSalaryOverrideFlag|AutoProgressionCode|AutoSalChangeCode|ProgressionDateCode|ProgressionStyleCode|RateChangeDateCode|SalaryCalculationMethodCode|SalaryChangeDateCode|UpdateSalaryFlag|ProgActionCode|SalaryActionCode|LegislativeDataGroupId(SourceSystemId)
MERGE|ProgressionGradeLadder|VISION|GSP_DEVELOPMENT|2000/02/15|GSP Development|GRADE|A|COMMON|N|N|CMP_GSP_PROG_MANUAL|CMP_GSP_PROG_MANUAL|CMP_GSP_PROCESS_DT|CMP_GSP_GP|CMP_GSP_PROCESS_DT|CMP_GSP_GRADE_STEP_RATE|CMP_GSP_ELIGIBILITY_DT|Y|CMP_GRADE_STEP_PROGRESSION|CMP_GRADE_STEP_PROGRESSION|GSP_US_LDG1

This excerpt shows the Grades In Progression Grade Ladder components.

METADATA|GradesInProgressionLadder|SourceSystemOwner|SourceSystemId|EffectiveStartDate|GradesInLadderSequence|GradeSetCode|GradeId(SourceSystemId)|GradeLadderId(SourceSystemId)
MERGE|GradesInProgressionLadder|VISION|GSP_DEVELOPMENT_GIL1|2000/02/15|1|COMMON|DEV1_GSP|GSP_DEVELOPMENT
MERGE|GradesInProgressionLadder|VISION|GSP_DEVELOPMENT_GIL2|2000/02/15|2|COMMON|DEV2_GSP|GSP_DEVELOPMENT
MERGE|GradesInProgressionLadder|VISION|GSP_DEVELOPMENT_GIL3|2000/02/15|3|COMMON|DEV3_GSP|GSP_DEVELOPMENT
MERGE|GradesInProgressionLadder|VISION|GSP_DEVELOPMENT_GIL4|2000/02/15|4|COMMON|DEV4_GSP|GSP_DEVELOPMENT
MERGE|GradesInProgressionLadder|VISION|GSP_DEVELOPMENT_GIL5|2000/02/15|5|COMMON|DEV5_GSP|GSP_DEVELOPMENT
MERGE|GradesInProgressionLadder|VISION|GSP_DEVELOPMENT_GIL6|2000/02/15|6|COMMON|DEV6_GSP|GSP_DEVELOPMENT

Create a Progression Grade Ladder Without Steps Using User Keys

This example ProgressionGradeLadder.dat file creates a progression grade ladder where the grades don't have steps. The file includes Progression Grade Ladder and Grades In Progression Grade Ladder components, which both use user keys. The rates are defined separately using Progression Grade Rate objects.

This excerpt shows the Progression Grade Ladder component.

METADATA|ProgressionGradeLadder|EffectiveStartDate|GradeLadderName|GradeType|ActiveStatus|GradeSetCode|AllowProgOverrideFlag|AllowSalaryOverrideFlag|AutoProgressionCode|AutoSalChangeCode|ProgressionDateCode|ProgressionStyleCode|RateChangeDateCode|SalaryCalculationMethodCode|SalaryChangeDateCode|UpdateSalaryFlag|ProgActionCode|SalaryActionCode|LegislativeDataGroup
MERGE|ProgressionGradeLadder|2010/01/01|GSP Staff|GRADE|A|COMMON|N|N|CMP_GSP_PROG_MANUAL|CMP_GSP_PROG_MANUAL|CMP_GSP_PROCESS_DT|CMP_GSP_GP|CMP_GSP_PROCESS_DT|CMP_GSP_GRADE_STEP_RATE|CMP_GSP_ELIGIBILITY_DT|Y|CMP_GRADE_STEP_PROGRESSION|CMP_GRADE_STEP_PROGRESSION|GBI United States LDG

This excerpt shows the Grades in Progression Grade Ladder components.

METADATA|GradesInProgressionLadder|EffectiveStartDate|GradesInLadderSequence|GradeSetCode|GradeCode|GradeLadderName
MERGE|GradesInProgressionLadder|2010/01/01|1|COMMON|STAFF1|GSP Staff
MERGE|GradesInProgressionLadder|2010/01/01|2|COMMON|STAFF2|GSP Staff
MERGE|GradesInProgressionLadder|2010/01/01|3|COMMON|STAFF3|GSP Staff
MERGE|GradesInProgressionLadder|2010/01/01|4|COMMON|STAFF4|GSP Staff

Delete Progression Grade Ladders Without Steps

This example ProgressionGradeLadder.dat file deletes a progression grade ladder, which it references by its source key. This progression grade ladder includes grades without steps, so you need to delete any linked Progression Grade Rate and Progression Rule objects separately.

METADATA|ProgressionGradeLadder|SourceSystemOwner|SourceSystemId
DELETE|ProgressionGradeLadder|VISION|GSP_DEVELOPMENT