Progression rule data

Progression rules define automatic changes in grade and step in a salary table.

The staging table is WFB_ProgressionRuleData.

This table describes the progression rule data:

Field Type Mandatory Description
Entity [nvarchar] (200)

NOT NULL

 Y Unique entity ID in the Entity business object that is activated in the configuration set.
SalaryTableID [nvarchar] (200)

NOT NULL

 Y Unique salary table ID in the Salary Table business object.

The related table is Salary Table, the field is SalaryTableID.
ProgressionRuleName [nvarchar] (252)

NOT NULL

 Y Progression rule name.
ChangeLine [float] (53)

NOT NULL

 Y The order in which the progressions are applied.
StartGrade [nvarchar] (252)

NOT NULL

 Y Grade from which the rule progresses.

Valid salary table grade name in Salary Table Grade.

The related table is SalaryTableGrade, the field is Name.
StartStep [float] (53)

NOT NULL

 Y Step from which the rule progresses.

Valid step in Salary Table Step.

The related table is SalaryTableStep, the field is Step.
EndGrade [nvarchar] (252)

NOT NULL

 Y Grade from which the rule progresses.

Valid salary table grade name in Salary Table Grade.

The related table is SalaryTableGrade, the field is Name.
EndStep [float] (53)

NOT NULL

 Y Step from which the rule progresses.

Valid step in Salary Table Step.

The related table is SalaryTableStep, the field is Step.
Periods [float] (53)

NOT NULL

 Y Number of months over which the progression rule is made.