US Payroll Report for Tax code

We are working on a Report which needs Balance Category Order, Tax code and State using BI publisher. But not able to get the correct table for Tax code and state. Need this data as its available in Run Results. I am refereeing the report Third party Periodic Tax Extract flow.

I want below details using SQL query.

AssignmentID

PersonID

Payroll Relationship Number

Balance Category Order

Tax Code

State