Country code/name used when payroll was processed for an employee
Please share the table from which we can get the country that is/was used when the payroll was processed for the employee
Assuming the work location country of an employee is XX as of payroll Run date, and after payroll is completed HRBP entered transfer transaction with a retro date. This transfer transaction resulted into a change in country of work location.
So today if we try to get the location_id from per_all_assignments_m as of payroll run date and further join it to per_locations we may get the country of the work location that was entered with a retro date, but what if we would like to know the country that was used when payroll was run, do we have a table from which we can get this.