Salary table step

The staging table is WFB_SalaryTableStep.

Step elements are created during the import process by the application in the WBDSG_STEP dimension which is in the WBDSG_STEP hierarchy under TOTAL_SG_STEP.

This table describes salary table step:

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 SalaryTable, the field is SalaryTableID.
SalaryTableEffectiveStart [datetime]

NOT NULL

 Y Effective start date for the salary.

There is no default value.
GradeName [nvarchar] (252)

NOT NULL

 Y Valid grade name in the Salary Table business object.

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

NOT NULL

 Y Indicates step in grade.

Must be sequential. For example: 1, 2, 3 and so on. It cannot exceed the MaximumStep amount. The maximum step amount is 99.
Amount [float] (53)

NOT NULL

 Y Salary amount.

There is no default value.