Access Management

Role Code

Role Description

Explanation

ZH_MENU_HR

HR: Menu - Solvay HR

Role menu for the application

ZH_MENU_ADMIN

HR: Menu - HR Reporting ADMIN

ZH_MENU_NON-HR

HR: Menu - Solvay Non-HR

ZH_PA_ALL

HR: Headcount - ALL

Application role

ZH_PA_ALL_ECO

HR: Headcount - ALL - ECO

ZH_PA_ALL_SCO

HR: Headcount - ALL - SCO

ZH_PA_COUNTRY

HR: Headcount - Country

ZH_PA_EXP

HR: Headcount - Expert

ZH_PA_EXP_ECO

HR: Headcount - Expert - ECO

ZH_PA_EXP_SCO

HR: Headcount - Expert - SCO

ZH_PA_GBU

HR: Headcount - Expert - SCO

ZH_PA_MANAGER

ZH_PA_SITE

ZH_PA_SITE_ECO

ZH_PA_SITE_SCO

ZH_PA_SOLVAY

ZH_PA_SOLVAY_ECO

ZH_PA_SOLVAY_SCO

List of authorization objects mandatory for the application.

Authorization object

Explanation

C_BUSUNIT

Business Unit

C_CNTRYHR

Country

C_LOCAGRP

Site(Obsolete)

C_MGRID

Manager

C_HRPO2

PO2 flag

Data flow

Overview

It's an overview of the workforce at the level of employee, calday.

Data flow

Image Removed

EC dataflow:

C_USERID, C_PERSNID -> CPHRECHDT -> ABHRECHDT -> ABHRHDCME -> CV_HR_HDCT_MONTH -> CV_HR_HDCT_EVENTS -> CV_HR_HDCT_EVENTS_TIME -> CPHRPAHDM

Please see the data flow of the composite provider CPHRPANHR(Headcount and Event Monthly Non HR) generated from Performer Suite.

Please see the data flow of the composite provider CPHRPAHDM(Headcount and Events Monthly) generated from Performer Suite.

People Engagement Journey (PEJ) Project - Main Enhancements

1) Transformation from "Headcount EC" (ABHRECHDT) to "Headcount per Month EC" (ABHRHDCME)

Image Removed

End Routine:

• INCLUDE zbw_employee_mid_point.
  • Mid Point (C_MIDPNT and K_MIDPNT).
• INCLUDE zbw_employee_bonus (outside the scope of PEJ Project but developed as part of it due to transports convenience).
  
  • Charges on salary (K_SALCHRG).
  • Charges on bonus (K_BNSCHRG).
  • Non Payroll Finance (K_PAYFI).
  • Target Percent (C_TGTPCNT and K_TGTPCNT).
  • Total Employee Cost (K_TEC_L).
• INCLUDE zbw_employee_scope_of_control.
  
  • Number of Direct Reports (C_DIRCREP).
  • Total Team Size (C_TEAMSZ).
  • Organizational Level (C_ORGLVL).
• INCLUDE zbw_hdct_personal_details.
  
  • Manager (Yes/No) (C_ISSUPER).
  • Address (C_LNGADDR).
  • Birthplace (C_BIRTHPL).
  • National Identity Number (C_NATNLID).
  • Global Assignment Attributes:
    • Assignment Type (C_ASGTYP).
    • Assignment Policy (C_ASGPOL).
    • Assignment Start Date (C_ASGSTDT).
    • Assignment Planned End Date (C_ASGEDDT).
    • Social Security Secondment (C_ASGSOSS).
    • Assignment Split Payroll (C_ASGSPLP).
  • Personal Phone (C_PERSPHN).
  • Professional Phone (C_PROFPHN).
• INCLUDE zbw_employee_assessment_score.
  • Assessment Score (C_ASSCORE).

• Withdrawn / on hold:
  • Bank Account (C_BANKNHR).
  • Social Security Number (C_SOCSECN).

2) Transformation from "Payroll Data" (APHRPY01) to "Headcount per Month EC" (ABHRHDCME).

• Total Employee Cost (K_TEC_L).

Image Removed

3) Transformation from InfoSource "Spliced C_USERID and C_PERSNID" (IFS_HR_PA_02) to "Headcount EC" (ABHRECHDT).

• End Routine
  • INCLUDE zbw_employee_current_status. 
    • Current Employee Status (C_EMPLSTC).

4) Transformation from CompositeProvider "Load C_USERID" (CPHRUSERID) and InfoObject "UserID (Employee)" (C_USERID).

• End Routine
  • INCLUDE zbw_employee_userid (existing code prior to PEJ Project).
  • INCLUDE zbw_employee_userid_score.
    
    • Assessment Score (C_ASSCORE).
  • INCLUDE zbw_employee_market_reference.
    • Position S-Grade (C_SGRADEP).
    • Market Reference (C_MARKTPR) - Deprecated as the source system did not provide values for this field
    • Pay Range (C_PAYRANG)
    • Compa Ratio (C_COMPRAT)

5) BW Queries

Image Removed  

• CompositeProvider CPHRPAHDM
  • HANA View Solvay_HR.PA.VIRT/CV_HR_HDCT_EVENTS_TIME
    • HAVA View Solvay_HR.PA.VIRT/CV_HR_HDCT_EVENTS
      • HANA View Solvay_HR.PA.VIRT/CV_HR_HDCT_MONTH
        • DSO "Headcount Employee Central" (ABHRHDCME)
        • DSO "Headcount SAP" (ABHRHDCMS)
      • HANA View Solvay_HR.PA.VIRT/CV_HR_ACT_EVT
        • HANA View Solvay_HR.PA.VIRT/CV_HR_ACTIONS
        • HANA View Solvay_HR.PA.VIRT/CV_HR_EVENTS

Image Removed

• CompositeProvider CPHRPATRCKCH
  • CompositeProvider CPHRPAHDCTCH
    • HANA View Solvay_HR.PA.VIRT.CV_HR_TRACKING_CHANGES
      
    • HANA View Solvay_HR.PA.VIRT.CV_HR_ECHDCT_CHANGES
      
    • DSO "Headcount for Reporting" [ABHRHDCTR]
      
    • DSO "Personnel Actions (SAP) Reporting" [ABHRPA01R]
      
    • DSO "Headcount EC" [ABHRECHDT]
      
    • HANA View Solvay_HR.PA.VIRT.CV_HR_EVENTS

6) Snapshots

• DSO "Workforce Snapshots" (ABHRSNAP1)

Reporting

Dependencies with other applications

List of OpenHub

QV Query: QV_BW_QRY_CPHRPANHR_0001

Data loading

Technical Architecture

Data Flow

1. BW(Workforce + Payroll) →  Xtract → Talend → GCP → Qlik
2. Pulse(gsheet) → Talend → GCP → Qlik

Data Source

Prerequisites:

  BW 

• Remote Access should be enabled for the interface query
• Access to the two interface queries should be assigned to the role: ZH_PA_INGESTION and technical user: RFC_TAL_WBP

  Pulse

• It's integrated into one gsheet(tab:Pulse) as above and should be shared with
  • sa-talend@prj-data-dm-hr-dev.iam.gserviceaccount.com
  • sa-talend@prj-data-dm-hr-test.iam.gserviceaccount.com
  • sa-talend@prj-data-dm-hr-ppd.iam.gserviceaccount.com
  • sa-talend@prj-data-dm-hr-prod.iam.gserviceaccount.com
• Short text for [Management Level]
• Text for [Cadre, Non Cadre]

Restrictions on BW queries:

• User Name = SACBW_HRD
• HR Roles    = WORLDWIDE
• PO2 Flag    = #; E;TSAE

Please see here for details.

Xtract

Please see here for details.

Talend

For the loading of historical data, starting from the current month of Y-2 until previous month of Y.

In order to avoid the memory issue in WBP, please load the data every 3 months, to put the parameter in RDS.talend_param with the format: &YYYYMM_Start=202206&YYYYMM_End=202208.

After the finish of the historical data loading, please put the currentmonth in table:talend_param, it will load the data of previous month on 10th of each month

F120_People_Insight_Data_Mart_Monthly

• F001_BW_QRY_CPHRPAHDM_0005_to_ODS(Workforce Data)
  • J001_BW_QRY_CPHRPAHDM_0005_csv_to_GCS
• F002_BW_QRY_CPHRPY002_0001_to_ODS(Payroll Data)
  • J002_BW_QRY_CPHRPY002_0001_csv_to_GCS

F120_Data_Mart_Pulse_Manual

• F003_FIL_PULSE(Solvay Pulse Survey Data)
  • J003_Pulse_GSheet_to_GCS

GCP

STG Tables:

• STG.STG_BWH_0000_0000_F001_F_M_qry_cphrpahdm_0005
• STG.STG_BWH_0000_0000_F001_F_M_qry_cphrpy002_0001
• STG.STG_FIL_0000_0000_F003_F_A_pulse_to_hr_peopleinsight

ODS Tables:

• ODS.ODS_BWH_0000_F001_F_M_qry_cphrpahdm_0005
• ODS.ODS_BWH_0000_F001_F_M_qry_cphrpy002_0001
• ODS.ODS_FIL_0000_0000_F003_F_A_pulse_to_hr_peopleinsight

DM Tables:

• DM.FACT_hr_peopleinsight_workforce
• DM.FACT_hr_peopleinsight_payroll
• DM.FACT_hr_peopleinsight_pulse

Stored Procedure:

• DM.PROC_PAYROLL_ODS_TO_DM
• DM.PROC_WORKFORCE_ODS_TO_DM
• DM.PROC_PULSE_ODS_TO_DM

Views:

• DS_prj_data_ppl_insgt_dashb.V_FACT_hr_peopleinsight_workforce
• DS_prj_data_ppl_insgt_dashb.V_FACT_hr_peopleinsight_pulse
• DS_prj_data_ppl_insgt_dashb.V_FACT_hr_peopleinsight_payroll

• DataOcean.V_FACT_hr_peopleinsight_pulse
• DataOcean.V_FACT_hr_peopleinsight_payroll
• DataOcean.V_FACT_hr_peopleinsight_workforce

• DPL.V_FACT_hr_peopleinsight_pulse
• DPL.V_FACT_hr_peopleinsight_payroll
• DPL.V_FACT_hr_peopleinsight_workforce

The DataOcean and DPL views should be created in GCP project: prj-data-ppl-insgt-dashb-<<env>>; the others to be created in GCP project: prj-data-dm-hr-<<env>>

Service Accounts:

• prj-data-ppl-insgt-dashb-<<env>>
  • sa-talend@prj-data-ppl-insgt-dashb-<<env>>.iam.gserviceaccount.com
• prj-data-ppl-insgt-dashb-<<env>>
  • sa-talend@prj-data-dm-hr-<<env>>.iam.gserviceaccount.com

DA&AI - Domain Mapping - HR

DA&AI  - HR - People Insight Dashboard

QlikSense

QlikSense technical documentation

Data Quality Controls

Data comes from SAP system. To compare data between BW and sources systems, check propagation layers.

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticality, workarounds and resolution plan.>

Roadmap

<List past & future evolutions for the application (including links to MED/FSD/TSD)>