Reporting on candidate address

Content

We do not have any type of HCM or system that loads new hires from Taleo into our payroll system. Right now its done via an email notification and I'm trying to create an analysis for them to at least get it into a single spreadsheet. One of the things payroll needs is address. However I'm having issues trying to get that into an analysis. I either get the address history or nothing at all, despite the candidate having address on their general profile filled out.

Any tips? I've tried using Candidate address history and that isn't working.

Thanks!