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.