Need to create a report in BI for costing

Summary

Need to create a report in BI for costing which gives the details of the temporary job worked by an employee

Content

In our organization, we have employees working for different departments on a casual basis besides their regular job. In order to enter

the costing to the right GL account, we are trying to create a report in BI which gives the details of an employee who worked casually with information such as the temp job worked, rate, hours worked and the earnings element for a given payperiod.

Is there such a report exists? What payroll tables we need to connect with the pay_cost_allocations_f and per_jobs table in order to create this?