Need a query that combines both termination transaction details with the employee details.

Hi

I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for a custom audit report. We want to see if terminations are being processed/approved timely and put a dollar amount to it. Any help with be appreciated.

Jose