ps_local_tax_tbl Locality Names?

[StevenB]

Howdy all,

We use PS HRMS 7.5 with Payroll Interface. We're in the process of outsourcing administration of our stock options to a third party. In doing so, we need to pass tax rates to the vendor for each employee. Most of this data is handled by our payroll vendor ADP, but we can't get what we need from them.

So, we're trying to map our employees in PeopleSoft to the correct tax rates in PeopleSoft's tax tables, but we don't have much experience with those tables.

So far, we've chosen the following tables and fields to pull the appropriate rates:

Federal tax rate
Table: ps_state_tax_tbl
Field: supl_wage_rt
Criteria: state='$U', maximum effective date

Medicare tax rate
Table: st_oth_tax_tbl
Field: tax_rt
Criteria: state='$U', tax_class='F',maximum effective date

Social Security tax rate
Table: st_oth_tax_tbl
Field: tax_rt
Criteria: state='$U', tax_class='D',maximum effective date

State tax rate
Table: ps_state_tax_tbl
Field: supl_wage_rt

Local tax rate
Table: local_tax_tbl
Field: resident_tax_rt
Criteria:

SUI (State Unemployment Insurance) tax rate
Table: ps_st_oth_tax_tbl
Field: tax_rt
Criteria:
tax_class='V'
maximum effective date
ee_er_tax_type in ('B','E')?

SDI (State Disability Insurance) tax rate
Table: ps_st_oth_tax_tbl
Field: tax_rt
Criteria:
tax_class='D'
maximum effective date
ee_er_tax_type in ('B','E')?

My questions are as follows:

1. In the ps_local_tax_tbl, if you look at the locality_name field, many of the locality names are duplicated, sometimes with an acronym in parentheses, such as "CAGIT", "CEDIT, "COIT". I believe it's only for localities in Indiana. Anyone have any idea what those are for?

2. Within PeopleSoft, how do I choose the appropriate SUI/SDI tax rate to apply to an employee? (Not employer) Any thoughts on that one?

Thanks!
Steve Battisti