Access Management

Data flow

Overview

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

Data flow

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)

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

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

• 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

• 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

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