Salary table grade

The staging table is WFB_SalaryTableGrade.

Grade elements are created during the import process by the application in the WBDSG_GRADE dimension which is in the WBDSG_GRADE hierarchy under TOTAL_SG_GRADE.

This table describes salary table grade:

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.

Name [nvarchar] (252)

NOT NULL

Y Unique salary table grade name per salary table.
Description [nvarchar] (252)

NULL

N Description of the grade.
MaximumSteps [float]

NOT NULL

Y Number of steps in the grade.

Must be a whole number between 1 and 99.

There is no default value.

Order [float]

NOT NULL

Y Indicates the sequence of the grade in salary table.

Must be a positive non-decimal numeric value.