Position
Positions are specific roles that employees hold within a company. They are more detailed than Jobs and are always created from a job. Positions can inherit pay and cost details from the associated job. A position is unique to a single configuration set, budget version, entity, and organization combination.
The process uses these tables and stored procedures:
- The staging table is DAT_ATCDATA_POSITION_STAGE.
- The stored procedure to validate staged data is
depm_integration_wb_position_prepare_staging. - The stored procedure to process staged data is
depm_integration_wb_position. - The data is imported to:
- The DAT_ATCDATA_POSITION_TRANSFORMED table.
- The ATCDATA_POSITION and WBCCONFIG_ACTION_ORDER cubes.
The output tables are:
- ATT_ATCDATA_POSITION contains the 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, organization ID, and account ID must exist prior to importing data.
If you are importing position data, and if in use, then you must also import salary table data, salary grade data, salary step data, progression rules, and progression rule data.
This table describes DAT_ATCDATA_POSITION_STAGE:
| Field | Required | Description |
|---|---|---|
| PositionName | Y | Name of the position. |
| PositionDescription | N | Description of the position. |
| Active | N | The values are:
The default value is 1. A position's active status must match associated job's active status. |
| Identifier | Y | Unique identifying code for the position. Used as the element name. |
| EffectiveStart | Y | Effective start date for the position. The format is YYYY/MM/DD. |
| EffectiveEnd | Y | Effective end date for the position. The format is YYYY/MM/DD. Must be greater than or equal to EffectiveStart. |
| Salary | Y/N | Salary amount. This is required if not using salary table. Must match job value. PayBasis is one of S/M/H. |
| SalaryTable | Y/N | Valid salary table identifier. This is required if using salary table.
The PayBasis is T. If inheriting from job, the salary table name must equal the job's SalaryTable value. The related field is Identifier in the DAT_WBDSG_TABLE_STAGE table. |
| SalaryGrade | Y/N | Valid salary grade name. This is required if using salary table. The PayBasis is T. If inheriting from job, the salary grade must equal the job's SalaryGrade value. 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.
For example, PayBasis is T. If inheriting from job, the step number must equal the job's SalaryStep value. The related field is Step in the DAT_WBDSG_STEP_STAGE table. |
| BaseSalaryAccount | Y | Valid base salary account ID from account dimension. Account must be activated in the configuration set in which data will be loaded. The related field is ID in the DIM_BPDACCOUNT_ELEMENTS table. |
| ProgressionRule | N | Valid progression rule name associated with the position, if applicable.
If inheriting from job, the progression rule must equal the job's ProgressionRule value. The related field is Name in the DAT_PROGRESSION_STAGE table. |
| MaximumSalary | N | Maximum salary. Only applicable if PayBasis equals M or S, which
corresponds to monthly or salary pay basis. If inheriting from job, the maximum salary must equal the job's MaximumSalary value. |
| ReportIdentifier | N | Optional tag for reporting. |
| HeadCount | N | This headcount value used for the initial action on the position. If the configuration has been set to use actual headcount this value must be a whole number. If effective headcount was set, then decimal values are valid. The default value is 1. The headcount must be positive. |
| FTE | N | Full time equivalent. This FTE value is used for the initial action on the
position. The default value is 1. |
| JobIdentifier | Y | Valid job identifier for the position. The related field is Identifier in the DAT_ATCDATA_JOB_STAGE table. |
| ExcludeFromDefaults | N | Exclude the position from any changes that are made to the default values
that are specified in the job level. The valid values are:
The default value is 0. |
| ReportFTE | N | Full time equivalent value for reporting. |
| PhasingMethod | Y | Valid phasing method name. The default value is Even. |
| FundingAvailable | N | Date when funding is available. The format is YYYY/MM/DD. |
| BPDENTITY | Y | Unique entity ID from BPDENTITY. Entity that is activated within the
configuration set. The related field is ID in the DIM_BPDENTITY_ELEMENTS table. |
| BPDORGANIZATION | Y | Valid organization ID from BPDORGANIZATION. The related field is ID in the DIM_ORGANIZATION_ELEMENTS table. |