How to derive 'Change Effective on' attribute in custom ADP Workforce Now integration.
We are in process of creating custom ADP Workforce Now Integration, Where we need to derive one field which is 'change effective on' based on changes happened on employees job change/department change or address change/salary change.
- Employee hired on 12-Dec-2023
- Employee Job Changed on 15-Dec-2023
- Employee Address changed on 10-Jan-2024
- Employee Salary changed on 20-Jan-2024
Extract should be able to generate 4 'change effective on' and record should look like below