Position assignment
Position assignments are assigned to an employee using the WBDPOSITION dimension.
The process uses these tables and stored procedures:
- The staging table is DAT_ASSIGNMENT_STAGE.
- The stored procedure to validate staged data is
depm_integration_wb_assignment_prepare_staging. - The stored procedure to process staged data is
depm_integration_wb_assignment. - The data is imported to:
- The DAT_ASSIGNMENT_TRANSFORMED table.
- The ATCDATA_POSITION, WBCCONFIG_ACTION_ORDER, and WBCCONFIG_ALLOCATION cubes. The WBCCONFIG_ALLOCATION cube contains a row for the allocation stored procedures.
The output tables are:
- ATT_ATCDATA_POSITION contains dynamic attribute cube data.
- DIM_WBDPOSITION_ELEMENTS contains the elements for the WBDPOSITION dimension.
- DIM_WBDPOSITION_PARENTS contains the parent/child relationships for the WBDPOSITION dimension.
The entity ID, account ID, position and employee must exist prior to importing data.
If you are importing position assignment data, and if in use, then you must also import salary table data, salary grade data, salary step data, progression rules, progression rule data, position data, and employee data.
This table describes DAT_ASSIGNMENT_STAGE:
| Field | Required | Description |
|---|---|---|
| WBDPOSITION | Y | Must be a valid position identifier. The related field is Identifier in the DAT_ATCDATA_POSITION_STAGE table. |
| WBDEMPLOYEE | Y | Must be a valid employee identifier. The related field is Identifier in the DAT_ATCDATA_EMPLOYEE_STAGE table. |
| AssignmentEffectiveStart | Y | Effective start date for the assignment. The format is YYYY/MM/DD. |
| AssignmentEffectiveEnd | N | Effective end date for the assignment. The format is YYYY/MM/DD. The default is the position or employee end date, whichever is earlier. The date must be equal or later than the AssignmentEffectiveStart date. |
| Salary | Y/N | PayBasis is one of S/M/H. |
| SalaryTable | Y/N | Valid salary table identifier. This is required if using salary
table. PayBasis is T. The related field is Identifier in the s DAT_WBDSG_TABLE_STAGE table. |
| SalaryGrade | Y/N | Valid salary grade name. This is required if using salary table PayBasis is T. The related field is Name in the DAT_WBDSG_GRADE_STAGE table. |
| SalaryStep | Y/N | Valid step number in salary step. This is required if using salary table.
PayBasis is T. The related field is Step in the DAT_WBDSG_STEP_STAGE table. |
| BaseSalaryAccount | Y | Valid base salary account ID from account dimension. The related field is Name in DAT_PROGRESSION_STAGE table. |
| ProgressionRule | N | Automatic progression between salary steps in grades, and between salary
grades. Valid progression rule name associated with the employee, if applicable. If inheriting from position, the progression rule must equal the position's ProgressionRule value. |
| MaximumSalary | N | Maximum salary. Only applicable if PayBasis equals M or S, which
corresponds to monthly or salary pay basis. If inheriting from position, the maximum salary must equal the MaximumSalary value for the position. |
| PhasingMethod | N | Valid phasing method name. The default value is Even. |
| FTE | Y | Full time equivalent |
| Primary | Y | Flag that indicates the primary assigned position for the employee.
There must be one primary assignment. The values are:
The default is 1. |