Query to fetch the employee assignment history.

We require a report that captures the complete assignment change history for employees, along with the associated action codes, details of the attributes that were changed, and any changes in salary.

We would appreciate your assistance in identifying the appropriate approach or providing the required data extraction.

These columns we need to fetch in the report.

Person Number, Person Name, Work Email, Legal Employer, Worker Type, Hire Date, Action, Action Reason, Start Date, End Date, Salary Amount, Annual Salary, Annualize Full-Time Salary, Grade, Assignment Status, Primary Assignment, Position Code, Position Name, Job Code, Job Name, Department

Thank you.