Progression rule data
The process uses these tables and stored procedures:
- The staging table is DAT_PROGRESSIONDATA_STAGE.
- The stored procedure to validate staged data is
depm_integration_wb_progressiondata_prepare_staging. - The stored procedure to process staged data is
depm_integration_wb_progressiondata. - The data is imported to:
- The DAT_WBDSG_PROGRESSIONDATA_TRANSFORMED table.
- The WBCCONFIG_PROGRESSION cube.
The output tables are:
- ATT_WBCCONFIG_PROGRESSION contains the configuration cube data.
- DIM_WBDPROGRESSION_ELEMENTS contains the elements for the WBDPROGRESSION dimension.
- DIM_WBDPROGRESSION_PARENTS contains the parent/child relationships for the WBDPROGRESSION 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 exist prior to importing data.
If you are importing progression rule data, you must also import salary table data, salary grade data, and salary step data.
This table describes DAT_PROGRESSIONDATA_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 in the WBDSG_TABLE salary table
dimension. The related field is Identifier in the DAT_WBDSG_TABLE_STAGE table. |
| ProgressionRuleName | Y | Progression rule name. The related field is Name in the DAT_PROGRESSION_STAGE table. |
| ChangeLine | Y | The order in which the progressions are applied. |
| StartGrade | Y | Grade from which the rule progresses. The related field is Name in the DAT_WBDSG_GRADE_STAGE table. |
| StartStep | Y | Step from which the rule progresses. The related field is Step in the DAT_WBDSG_STEP_STAGE table. |
| EndGrade | Y | Grade where the rule stops. The related field is Name in the DAT_WBDSG_GRADE_STAGE table. |
| EndStep | Y | Step where the rule stops. The related field is Step in the DAT_WBDSG_STEP_STAGE table. |
| Periods | Y | Number of months over which the progression rule is made. |