Salary table
Salary table records provide a grouping to hold step and grade information. Salary table data is dimensioned by entity and organization during the import.
The process uses these tables and stored procedures:
- The staging table is DAT_WBDSG_TABLE_STAGE.
- The stored procedure to validate staged data is
depm_integration_wb_table_prepare_staging. - The stored procedure to process staged data is
depm_integration_wb_table. - The data is imported to:
- The DAT_WBDSG_TABLE_TRANSFORMED table.
- The WBCCONFIG_STEPANDGRADE cube.
- The WBDSG_TABLE table contains placeholder elements.
The output tables are:
- ATT_WBCCONFIG_STEPANDGRADE contains the configuration cube data table.
- DIM_WBDSG_TABLE_ELEMENTS contains the SG_TABLE_nnnn placeholder elements for the WBDSG_TABLE dimension.
- DIM_WBDSG_TABLE_PARENTS contains the parent/child relationships for the WBDSG_TABLE dimension.
The entity ID must exist prior to importing data.
If you are importing salary table data, you must also import salary grade data.
This table describes DAT_WBDSG_TABLE_STAGE:
| Field | Required | Description |
|---|---|---|
| Entity | Y | Unique entity ID. The related field is ID in the DIM_BPDENTITY_ELEMENTS table. |
| Identifier | Y | Unique salary table identifier. |
| Name | Y | Name of the salary table. |
| Description | N | Description for the salary table. |
| PayType | Y | One-character code for pay type. The valid values are:
|