HR plays a direct and crucial role in the promotion process of an employee. This query allows to monitors the impact of promotions on employee salaries.
HR Managers *Compensation data is not available for Non-HR scope |
Target Users: HR Managers |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 03.11.2023 | Emma Glasson | Initial draft |
|
Promotion is a moment in an employee's journey that requires changes in the expectations of what the employee needs to do and deliver - increase in the scope and complexity for which the employee should also be rewarded accordingly.
The following scenarios are considered as a promotion case:
Scope increase (no grade change) - tangible additional responsibility that is above the existing scope of the position, but below requirements of a higher grade according to Generic Job Descriptions (increase in pay with no change in S grade or STI plan);
The following scenarios are not considered as a promotion case:
A Transfer is an internal move of an employee to another position in another team/site/entity as a result of internal recruitment project or in the framework of a career development plan of the employee.
Please note: Ensure that prior to proceeding with the promotion action, a vacant position with new job grade information has been created first. Also, a vacant position is required only in cases of complete change in the employees role / job. A vacancy is not required in cases of increase of scope or increase of responsibilities of the employee.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
Promotions | Monitoring the impact of promotions on salaries | Cal Year / Month Functional roles Employee Current Status Workforce Type
| n.a | BW_QRY_CPHRPATRCKCH_0003 |
mandatory field
Please find bellow general dimension, commun to all BW HR reports:
| Dimension | Definition |
Company Code | Company code to which an employee belongs on the time period selected in the report |
Country of the company | Country of company where the employee has his employment contract |
Calendar | Time dimensions available: Day, Month, Year, Year/Month |
Division (Entity) | Division (former entity) to which an employee belongs on the time period selected in the report |
Employee NR (NS) Employee PERN | Employee payroll number |
Employee status | Active, Active Leave, Inactive Leave Dormant, reported No Show Terminated, Inactive |
Employment status | Valid for historical data - the period before 1 November 2020. Equivalent to the current dimension Employee status |
Employee sub-group grouping (Gr) | Identification of employee by:
The employee sub-group grouping is a grouping definition of the employment type. |
Location Grp (Site) | Employee’s site |
Person ID | Unique identifier code for an employee. EC number. (person name available in the text option for this dimension) |
User Name | User account name (to access system/tool) |
| Domain | HR |
|---|---|
| Application | BW Promotion |
| Provider | CPHRPATRCKCH |
| Existing Documentation |
4.2.2. KPI's/Calculations/Indicators
Promotion data:
Indicatores/KPI's | Definition | Calculation/Extraction of data |
|---|---|---|
| Previous Salary (Local) | Salary before the promotion in Local Currency | n.a |
| New Salary (Local) | Salary after the promotion in Local Currency | n.a |
| Previous Salary (EUR) | Salary before the promotion in Euro | n.a |
| New Salary (EUR) | Salary after the promotion in Euro | n.a |
| Salary increase (%) | % of salary increase |
as per standards
Reports that contain sensitive data: Salary with People names.
GDPR compliant.
as per standards
as per standards
as per standards
as per standards
as per standards
Refresh Daily at 20.30pm CET