Report not pulling correct salary info

Summary:

We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few different subject areas, and each attempt we run into different problems. I'll provide what subject areas we used and how we tried reporting on this, and what the problems were. Hopefully someone can give some guidance on the best angle to tackle this report. Attached as an excel sheet is a sample of what the export should look like.

Content (please ensure you mask any confidential information):

The requirement for this report is to display every employee who was active from the start of our pay cycle for 2024, through the end of June. If anyone was an active employee during this time period, even if they terminated/retired during it, should be included. The report includes mostly person and job info, but the problematic piece is the salary. Below are a few examples of attempts and issues with each subject area.