1.0 Overview




Assessment per Appraisal Campaign Historical report 


This report contains data for performance and talent management, between 2018 and 2020. The datasource for this report is the You tool. You can find in this report, not only detailed information of Appraisal Campaign but also data to do the follow up of individual objectives and feedback culture. 


Note: For 2021 performance and talent reports are being developed in Success Factors report centre

There is 1 report available for the following stakeholders:

  • Menu-Solvay HR: Access only for HR and Managers (span of control)

Key user profiles: 

HR 

Managers

Target Users: 

HR and managers 

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

25.09.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

2.0 Business Process


Capture the business process that the application supports . This can be describe through a process diagram or a business capability model

You old tool decomission and transfer to success factor 

3.0 Application Feature Overview


Information about the existent Workbooks and the respective BW queries.

ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name
Assessment per Appraisal CampaignHaving YOU tool as datasource, you can find in this report, not only detailed information of Appraisal Campaign but also data to do the follow up of  individual objectives and feedback culture

Campaign (star)

Functional roles (star)


(star) mandatory field

n.aBW_QRY_CPHRAPCAMP_0001

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 Appraisal Query
ProviderCPHRAPCAMP
Existing Documentation


This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.


4.2.2. KPI's/Calculations/Indicators 

Indicators available: 

Indicatores/KPI's

Definition

Calculation/Extraction of data

Nb of Assessments

Number of assessments that need to be performed. It's one assessment per employee. 

count()

Nb of performed assessments

Number of assessments completed. It's one assessment per employee. count()
Nb of Score 1Number of employee that were assess with a Score 1.count()
Nb of Score 2Number of employee that were assess with a Score 2.count()
Nb of Score 3Number of employee that were assess with a Score 3.count()
Nb of Score 4Number of employee that were assess with a Score 4.count()
Nb of Score 5Number of employee that were assess with a Score 5.count()
% Score 1% of employee that were assess with a Score 1.avg in %
% Score 2% of employee that were assess with a Score 1.avg in %
% Score 3% of employee that were assess with a Score 1.avg in %
% Score 4% of employee that were assess with a Score 1.avg in %
% Score 5% of employee that were assess with a Score 1.avg in %

Number of profiles


count()

Number of Employees (active in YOU)

Number of employee with an active profile on YOU tool. count()

Number of disclaimer with profile published only for HR


count()

Number of Objectives

Number of objectif set. An employee can set multiple objectives.count()

Number of Objectives completed

Number of objective completed by an employee.count()

Number of Objectives in progress

Number of objective in progress per employee.count()

Nb of feedback given

Number of feedback given/send by en employee to another.count()

Nb of feedback received

Number of feedback received per employee.count()

Nb of feedback requests

Number of feedback requested per employee.count()

Nb of Geographical Mobility

Number of employee that change region/ country as their resident adresse and that it was part of the mobility program. For exemple, change location France to Portugal. count()

Nb of Functional Mobility


count()

5.0 Non-functional Descriptions 


Please populate the relevant section and delete those that are not applicable.

5.1 Usability

n.a

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

n.a

5.5 Reliability

Reliability is the ability of a solution or its component to perform its required functions without failure under predefined conditions for a specified time / period.  Reliability can possibly be specified in terms of average time system runs before failure occurs, percentage of operations completed successfully within a time / period, maximum acceptable failure probability, or number of failures within a period.  Reliability aspects are in reference to (but not limited to) evaluation of the system to be considered as reliable, classification of reliability defining failures vs. regular failures, and the impact of failure on business operations.  The Maintenance Dashboard will display data from the previous refresh of data.   

n.a

5.6 Scalability

Historical report, no small enhancements will be performed and no new access except for new joiners in HR domain.

5.7 Compatibility

Xtract and GCP compatible

5.8 Availability

100% Week and Weekends

5.9 Refresh of the Data

N.A 

Historical data loaded from YOU tool as datasource, you can find in this report historical information of Appraisal Campaign (2018-2020).

Note: For 2021 performance and talent reports are being developed in Success Factors report centre