BW Query
| Query | |
|---|---|
| BW_QRY_CPHRPAHDM_0001 | Workforce |
| BW_QRY_CPHRPAHDM_0002 | People at Solvay |
| BW_QRY_CPHRPAHDM_0003 | Leavers Report |
| BW_QRY_CPHRPAHDM_0004 | Workforce (no Employee Details) |
| BW_QRY_CPHRPAHDM_0005 | People at Solvay - Global |
| BW_QRY_CPHRPAHDM_0006 | People at Solvay All Access |
| BW_QRY_CPHRPAHDM_0007 | Salary Information |
| BW_QRY_CPHRPAHDM_0008 | Hirings |
| BW_QRY_CPHRPAHDM_0009 | Global Assignment |
| BW_QRY_CPHRPAHDM_0010 | Terminations |
| BW_QRY_CPHRPAHDM_0011 | Workforce - sensitive |
| BW_QRY_CPHRPAHDM_0012 | Leavers Report - Global |
| BW_QRY_CPHRPANHR_0001 | Workforce Simplified |
| BW_QRY_CPHRPANHR_0002 | Workforce - Onboarding |
Data loading
| Main Process Chain | Final Info Provider | Frequency | Start Time | Duration |
|---|---|---|---|---|
| PC_HR_PA_E0 | ABHRECHDT, ABHRECEVT, ABHRHDCME | Daily | ~20:30pm CET | ~3.5h |
| PC_HR_PA_32 | ABHRSNAP1 | Monthly(7th workday, BE factory calendar) | ~4:00am CET | ~2min |
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)>