Termed employee report with both Manager hierarchy AND final salary

Summary:

Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND also final salary?

Content (required):

Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND final salary?

I have seen many samples here for termed employee reports but they all talk about either Manager hierarchy OR final salary; but not both. I need to include both in the report along with many employee demographic info.

I tried to write a lSQL with Worker Assignment Event Real Time, Salary History and Worker Assignment Real Time SAs but the join and group by doesn't seem to be working.