Progression rule data

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

The table is WFB_ProgressionRuleData.

This table describes the progression rule data:

Field Type Required 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.