1.0 Overview



The workplace is changing, and so is Solvay’s approach to development: 

  • Individuals are expected to own and drive their development, supported by their Manager as a coach.
  • Development is more than traditional classroom training.  It is an ecosystem built around performance culture, talent attraction, talent management, and learning.
  • There is no substitute for experience.  The research is clear about how we grow most successfully: 70% experience, challenges and assignments, 20% exposure to developmental relationships, and 10% formal education, also known as the 70-20-10 model. See below for more information.
  • Learn, unlearn, relearn.  We are shifting from “single-event training” to a culture of continuous development.
  • Self-directed, digital learning options offer an efficient, accessible way to scale up the impact of learning, aligned with Solvay’s sustainability goals.
  • We bond with our purpose when we bond with each other.  Many of Solvay’s development options help individuals grow their networks, learn from peers, and encourage self awareness through a culture of feedback.



Key user profiles: 

HR - Talent Services Team

Managers

Target Users: 

HR and managers 

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

09.10.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 - YOU Grow

2.0 Business Process



3.0 Application Feature Overview



ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name
Certification Complexion Details

Functional roles (star)

Calendar Year / Month (star)

Employee Class 

Category

n.aBW_QRY_CPHRLS003_0001
Course Completion Details

BW_QRY_CPHRLS001_0001
Curriculum Completion Details

BW_QRY_CPHRLS002_0001
Learning Forecast

Functional roles (star)

Calendar Year / Month (star)


BW_QRY_CPHRLS001_0002
Training Management (Historic)

ORGUNIT

Year (star)


BW_QRY_CPHRLHST_0001


(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 

DomainHuman Resources (HR)
ApplicationBW Learning Queries
ProviderCPHRLS
Existing Documentation

4.2.2. KPI's/Calculations/Indicators 

Report Certification Complexion Details: 

Indicators/KPI's

Definition

Calculation/Extraction of data

People Counter

Certifications Assigned

Certifications In Progress

Certifications Acquired

Certifications Expired

Certifications Overdue

Respondant Counter


Report Course Completion Details

Indicators/KPI's

Definition

Calculation/Extraction of data

Duration (CLS)

Courses Completed

Internal Workforce (SABA)

Course Amount (CLS) - Local Curr

Survey Score


Report Curriculum Completion Details

Indicators/KPI's

Definition

Calculation/Extraction of data

Curriculum Course Expected Duration

People Counter (PPL)

Curriculums In Progress

Curriculum Completion %

Curriculums Acquired

Curriculums Overdue

Survey Score (EVAL)


Report Learning Forecast

Indicators/KPI's

Definition

Calculation/Extraction of data

Course Amount (CRS) - LC

Course Amount (CRS) - EUR

Course Amount (CLS) - Local Curr

Course Amount (CLS) - EUR

Duration (CRS)

Duration (CLS)

Duration (CC)

Target Days (CRS)

Internal Workforce (SABA)

Courses Completed

Courses In Progress

Courses Incomplete

Courses Acquired (ACT)

Courses Successful (ACT)

Courses Unsuccessful (ACT)

Courses Assigned (ACT)

Courses In Progress (ACT)

Courses Not Evaluated (ACT)

Courses Pending Registration (ACT)

Respondant Counter

Survey Score


Report Training Management (Historic)

Indicators/KPI's

Definition

Calculation/Extraction of data

No of Attendees

Attendance Fee

Cancellation Fee

Total Fee

External Course Pric

Internal Course Pric

5.0 Non-functional Descriptions 


5.1 Usability

as per standards

5.2 Regulatory Compliance

GDPR compliant. Report that contain confidential data but no sensitive data.

5.3 Security

  • Only authorised Users be able to access data.
  • Data will be split between either SCO or ECO, and Users will only have authority to one Entity 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