Salary table

The staging table is WFB_SalaryTable.

Salary table 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:

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.
Name [nvarchar] (200)

NOT NULL

Y Salary table name.
Description [nvarchar] (200)

NULL

N Description of the salary table.
PayType [nvarchar] (200)

NOT NULL

Y One character code for pay type.

These values are valid:

  • S used for annual.
  • M used for monthly.
  • H used for hourly.