Salary step

The process uses these tables and stored procedures:

  • The staging table is DAT_WBDSG_STEP_STAGE.
  • The stored procedure to validate staged data is depm_integration_wb_step_prepare_staging.
  • The stored procedure to process staged data is depm_integration_wb_step.
  • The data is imported to:
    • The DAT_WBDSG_STEP_TRANSFORMED table.
    • The WBCCONFIG_STEPANDGRADE cube.

The output tables are:

  • ATT_WBCCONFIG_STEPANDGRADE contains the configuration cube data.
  • DIM_WBDSG_STEP_ELEMENTS contains the SG_STEP_nnnn placeholder elements for the WBDSG_STEP dimension.
  • DIM_WBDSG_STEP_PARENTS contains the parent/child relationships for the WBDSG_STEP dimension.
  • DIM_BPDNO_ELEMENTS contains placement holder elements for different effective date and salary table combinations.
  • DIM_BPDNO_PARENTS contains the parent/child relationships for the BPDNO dimension.

The entity ID must already exist.

If you want to import salary step data, you must also import salary table and salary table grade data.

This table describes DAT_WBDSG_STEP_STAGE:

Field Required Description
Entity Y Unique entity ID.

The related field is ID in the DIM_BPDENTITY_ELEMENT table.

SalaryTableIdentifier Y Unique salary table identifier.

The related field is Identifier in the DAT_WBDSG_TABLE_STAGE table.

GradeName Y Must be a valid salary grade name.

The related field is Name in the DAT_WBDSG_GRADE_STAGE table.

Step Y Positive integer indicating step within grade.
Amount Y Salary amount.
SalaryTableEffectiveDate Y Effective start date for the salary table.

The format is YYYY/MM/DD.