Synchronization of data among multiple enterprise systems is a common challenge faced by many organizations and payroll seems to be the most common system. Much of the information can be updated by many stakeholders of the system such as Regional administrators, global administrators, IT staff, payroll administrators, and employees So how do you determine what records have changed and what information needs to be synchronized to downstream systems?
Delta reporting is to monitor Employee management records for changes to specific employee fields, producing a report outlining all employee records updated within a specific date range. Primarily used when synchronizing employee changes to external systems such as payroll or IT.
The delta Report is a value-added report that is used to trace and figure out the changes that are done for employees within a specific period. Working with OrangeHRM, the user can define the employee fields that must be tracked for updates.
Step 1 - Go to Reports and Analytics -> Employee Management -> Employee Data Export
For example on May 1st, the base salary is updated from $50,000 to $53,000 with an immediate effect. At the end of the month, the Payroll administrator can run a delta report for changes made during the month of May and the delta report will include details of the above record. The payroll administrator will, therefore, know that this is the only record to be updated within the payroll system.
When you choose the date range in which you would want to track the changes done to employee Job and Salary details, the validate function can be clicked to enable the ‘EXPORT” button which is used to download a CSV file with the information needed.
Step 2 - Could you complete the following fields to define the desired search criteria
Filter |
Description |
Report Type |
Select All Employees if you wanted to check the info Select the option "Changed Employees" to examine just the employees who have had their jobs and salaries changed. |
Employment status |
Selecting the employment status will help you limit your options even further. |
Location |
Selecting the Location will help you limit your options even further. |
Sub Unit |
Selecting the Subunit will help you limit your options even further. |
Changed From/To |
Defining a data period will help you limit your options even further. |