OTBI report to fetch

Summary

Report to extract

Content

I am trying to pull a report for e employees where the net payment is <=500 for the date range . To pull this record I used "Payroll-Payroll balances real time subject area" . I am able to get the net payment for active employees but the challenge is fetching TERMED/INACTIVE employees in the report . 
I tried union with " Workforce management -Worker assignment real time " Subject area , But this did not fetch any results nor I can pull the active/inactive from the payroll balance real time subject area 

I need Person number , name, Balance name , base Dimension Name , User category name  and Balance value from Payroll-Payroll balances real time subject area