Federal/State Remittance Report

This report shows taxable wages and withheld for following categories
1) Federal
2) Medicare (Employee and Employer)
3) Social Security (Employee and Employer)
4) State
5) SUI (Employee and Employer)

RDF file behind this report is PAYUSFTR.rdf under $PAY_TOP/reports/US directory.

The report calculates wages and withheld based on whether Federal/State run balances are valid or not.

If balances are not valid then use package: pay_us_taxbal_view_pkg.us_gp_gre_jd_ctd otherwise uses view pay_us_state_tax_bal_gre_v which in turn calls pay_us_tax_bals_pkg.us_tax_balance.

This view use two tables
1) pay_balance_sets which provides the ability to group related balances for reporting purposes
2) PAY_US_ASG_REPORTING : denormalized table used to improve the performance of some US balance reports. This table is maintained through the Employee Tax Information form(PAYEETAX.fmb) and the assignment form. It's primary purpose is to speed access to balances by filtering the assignments based first on tax unit id and then on jurisdiction code.

The balances used in this report are group level balances with dimension GRE in JD Run. The following query you can use to check whether balances are correct or not.

SELECT prb.*
FROM pay_run_balances prb,
pay_defined_balances pdb,
pay_balance_dimensions pbd,
pay_balance_types pbt
WHERE prb.defined_balance_id = pdb.defined_balance_id
AND pdb.balance_type_id = pbt.balance_type_id
AND pdb.balance_dimension_id = pbd.balance_dimension_id
AND pbt.balance_name = 'SUI ER Taxable'
AND pbd.dimension_name = 'GRE in JD Run'
and prb.effective_date = '05-Mar-2009'

If balances are not correct then run the process Generate Run balances process with particular balance and dimension.