BI Report to get the previous and present records of job, salary amount, department and grade.

Hi Team,

I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports.

Parameters: -
Action Code, from date and to date

Actually, it should work on below cases without any issues
1. If in a same day multiple changes done should also fetch the previous and present values
2. Should also fetch the records which are updated in assignment or change salary screens based on date from and date to parameters.