Termination Report Unable to Pull In Salaries

Summary

Trying to pull a historical report of terminations in a certain location with salary amount at time of term

Content

Hi - I have looked into a number of posts regarding this topic, however I have not found the solution. I am trying to build a termination report that looks at specific locations over a period of time. I am able to pull all the information I need except for salary details. I am using the Salary History Details Real Time subject area along with Worker Assignment Event Real Time. When I take the termination action reasons criteria off, I can pull in salary details, but it doesn't show up on any of the termination rows.