Business ByDesign Employee Master Data Report
With the 1908 release of Business ByDesign, a new report called the Employee Master Data report was delivered, that is based on a new data source by the same name (ID: HCMPAB008). This report can be accessed from the Personnel Administration work center – Analytical Reports view.
In this blog post, I’d like to demonstrate how this can be used.
Using this report, the user can view the Biographical data, Workplace and Private address, Payment and Bank information, Work Agreement and Organizational assignment data. There are several pre-delivered Report views that help segregating this information.
Using the Validity Period selection parameter, the user can choose whether they want to view the snapshot of data that is valid as of a specific date, or all the records that are valid during a specific period.
What is the key feature behind this report ?
Customers have often mentioned that they would like to track if employees change details pertaining to bank, biographical data, private address etc via the Employee Self Services features.
This report helps administrators know which employees have been updated with a particular period. This is achieved via the search parameter “Changed within period” – all employees whose data has changed within the selected period (that by default is set to Current Month) are part of the report result.
In the above example, we see that only three employees have had changes done in the current month.
This is especially useful when administrators need to update payroll provider systems if there is a change in any relevant employee master data.
If there has been a new record created, this can be visible using the pre-delivered views itself – the user can toggle between the different views to find if there are any new records created.
In the below example, the user sees that for employee Bill Warner, there is a new record for Biographical data, where there is a change in the Marital status. This change is valid from 7th July 2019.
But in many cases, there might be an update to an existing record. For such update scenarios, to know exactly what change was made, the user can navigate to the employee’s personnel file via the Employee Overview factsheet.
Filling the appropriate period in the Changes Made From and Changes Made To, you can get the list of changes.
In the example from the screenshot below, you can see that Iris Green has a new bank account, that was made by the administrator Eddie Smoke.
One can use this report to create custom ODATA services, and connect external systems like a payroll provider system. Using the available selection parameters, the payroll provider system can query the ByD system for employee master data updates, with the payroll period being an input to the “Changed within Period” selection attribute.
To know how to create ODATA services out of reports, please refer to the blog post by my colleague
Knut Heusermann – OData for SAP Business ByDesign Analytics
I hope you find this report to be useful. If you have any questions, please enter them as comments below, and I will address them.