| PWRS941 (Version 8.7.A)
This is a new report that will be used to reconcile cumulative state tax amounts between Banner production instances and the Payroll Aggregate Warehouse.
This "OUS Created" process was initially cloned from SunGard's PXRP941 process. In PXRP941, the SQL for the 1042 selection checks the exemption code and tax rate in the PHR1042 table. For some reason, this piece had been removed from our PWRS941 process and needed to be added back in.
Modifications were made in version 8.5.C to break down the totals to show the amount for each state versus having just one lump sum under the State column.|