Salary grade

The process uses these tables and stored procedures:

  • The staging table is DAT_WBDSG_GRADE_STAGE.
  • The stored procedure to validate staged data is depm_integration_wb_grade_prepare_staging.
  • The stored procedure to process staged data is depm_integration_wb_grade.
  • The data is imported to the DAT_WBDSG_GRADE_TRANSFORMED table.

The output tables are:

  • ATT_WBCCONFIG_STEPANDGRADE contains the configuration cube data.
  • DIM_WBDSG_GRADE_ELEMENTS contains the SG_GRADE_nnnn placeholder elements for the WBDSG_GRADE dimension.
  • DIM_WBDSG_GRADE_PARENTS contains the parent/child relationships for the WBDSG_GRADE dimension.

The entity ID must already exist.

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

This table describes DAT_WBDSG_GRADE_STAGE:

Field Required Description
Entity Y Unique entity ID.

The related field is ID in the DIM_BPDENTITY_ELEMENTS table.

SalaryTableIdentifier Y Unique salary table identifier.

The related field is Identifier in the DAT_WBDSG_TABLE_STAGE table.

Name Y Unique salary table grade name per salary table.
Description N Description of the salary grade.
MaximumSteps Y Number of steps in the grade, such as 3.

Must be less than or equal to the number of step placeholders.

Order Y Positive integer indicating sequence of grade within salary table.

Must begin at 1 and increment by 1.