Combine report from ATS and employees

We would like a report that combines the ATS applicant and employee information.

This will enable us to track vacancies filled with the correct information, and remove the need to pull reports then manually consolidate them in Excel.

For example a applicant enters their name on the vacancy application. When we then convert them to an employee, the name may be changed (e.g. from their known as name to full ID name).

Option 1 - include the employee ID number of the successfully candidate in the ATS candidate report

Option 2 - include the ID of the vacancy (or vacancy name) in the employees report