Progression rule

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

The staging table is WFB_ProgressionRule.

This table describes the progression rule:

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.

Name [nvarchar] (252)

NOT NULL

Y Progression rule name.
Description [nvarchar] (252)

NULL

N Progression rule description.
DateType [nvarchar] (252)

NOT NULL

Y Type of the date the rule is based on.

These values are valid:

  • EmployeeEffectiveStart
  • AssignmentEffectiveStart
  • PositionEffectiveStart
  • HireDate
  • PromotionDate
  • FundingAvailable
  • LongevityDate