Salary table step
The table is WFB_SalaryTableStep.
Step elements are created during the import process by the application in the Workforce Budgeting Salary Table Step dimension (WBDSG_STEP) which is in the WBDSG_STEP hierarchy under TOTAL_SG_STEP.
This table describes salary table step:
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 SalaryTable, the field is SalaryTableID. |
SalaryTableEffectiveStart | [datetime] NOT NULL |
Y | Effective start date for the salary table. 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 which is defined in the Grade table. The maximum step amount is 99. |
Amount | [float] (53) NOT NULL |
Y | Salary amount. There is no default value. |