1.0 Overview



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









 

Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Others Success Factor 

2.0 Business Process


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 ROLES & RESPONSIBILITIES IN THE PROCESS

  • Site HR is responsible for initiating the promotion action in the tool for Non-Cadre roles or Transfers to another Team or country;
  • People/Line Managers are responsible for initiating the promotion and pay rate change action in the tool for Cadre roles;
  • Strategic Business Partners (SBPs) are responsible for initiating the promotion and pay rate change actions in the tool for Executive (S23+) roles;
  • The Payroll team is responsible for checking & approving those requests at the last step of the workflow;
  • Promotion / Pay rate change statements are available in the System (unless local legislation requires another document to be used - in this case document to be provided by the Site HR) and promotions / pay rate changes must be communicated by People/Line Managers.

WHAT IS AND WHAT IS NOT CONSIDERED A PROMOTION CASE

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);

  • Same position with a higher S Grade - significant increase or change in the role as defined with Solvay Job grading methodology and Generic   Job Descriptions  that justifies increase of S grade ( by 1 or 2 levels );
  • New position within the same Team / Department - change in the scope, role & responsibility and remaining part of the same Team (reporting to the same manager);
  • Internal move (or transfer) to another Team / Site / Entity - as part of internal recruitment or career development plan employee has been offered and the employee has accepted a new position in another Department / Entity.

The following scenarios are not considered as a promotion case:

  • Change in the Job Title;
  • Change in Compensation Information or Pay Rate (increase of salary during the year for any reason other than change of scope or job, for example off-cycle pay increase);
  • Change in Department or Team; this type of career development is referred to as "Transfer." 


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. 


3.0 Application Feature Overview



ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name

Promotions

Monitoring the impact of promotions on salaries 

Cal Year / Month (star)  

Functional roles (star)

Employee Current Status (star)

Workforce Type (star)

(star) mandatory field

n.aBW_QRY_CPHRPATRCKCH_0003


(star) mandatory field

4.0 Functional Specification


4.1 General Data/Calculations 

Please find bellow general dimension, commun to all BW HR reports:

DimensionDefinition

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:

  • Cadre
  • Employee
  • Blue Collar 
  • Sales Cadre
  • External
  • N.A.

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)



4.2 Process Detail 

4.2.1.  Report/Process Definition 


DomainHR
ApplicationBW Promotion
ProviderCPHRPATRCKCH
Existing Documentation

HR Wiki



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 


5.0 Non-functional Descriptions 


5.1 Usability

as per standards

5.2 Regulatory Compliance

Reports that contain sensitive data: Salary with People names. 

GDPR compliant.

5.3 Security

  • Only authorised Users be able to access data.
  • Data are not yet split between SCO or ECO. The report contains both companies data. 

5.4 Performance

as per standards

5.5 Reliability

as per standards

5.6 Scalability

as per standards

5.7 Compatibility

as per standards

5.8 Availability

as per standards

5.9 Refresh of the Data

Refresh Daily at 20.30pm CET