NA Payroll

Tax Tables :


Federal tax rate
Table: ps_state_tax_tbl
Field: supl_wage_rt
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')?



Deduction

• Deduction code can be classified as follows

*Value	Effective Date	Status	*Long Name	*Short Name
A	1/1/1900	Active	After-Tax	After-Tax
B	1/1/1900	Active	Before-Tax	Before-Tax
L	1/1/1900	Active	QC Taxable Benefit	Tx Ben QC
N	1/1/1900	Active	Nontaxable Benefit	Nontaxable
P	1/1/1900	Active	Nontaxable Btax Benefit	PTax Ben
T	1/1/1900	Active	Taxable Benefit	Taxable

•  Ex. 401k is both  deductible from employee and employer, then we need to insert two row in tax class tab of deduction.

Tax_class

*Value	Effective Date	Status	*Long Name	*Short Name
A	1/1/1900	Active	Non-resident alien (1042)	1042
B	1/1/1900	Active	Local - Employer and Employee	Loc ER/EE
C	1/1/1900	Active	Earned Income Credit	Earned Inc
D	1/1/1900	Active	OASDI/Disability - EE	OASDI/EE
E	1/1/1900	Active	OASDI/Disability - ER	OASDI/ER
F	1/1/1900	Active	FICA Med Hospital Ins / EE	MED/EE
G	1/1/1900	Active	OASDI/EE - tips	OASDItipEE
H	1/1/1900	Active	Withholding	Withholdng
J	1/1/1900	Active	OASDI/ER - tips	OASDItipER
K	1/1/1900	Active	Excise	Excise
L	1/1/1900	Active	NJ Supl Workforce Admin Fund	NJ SWAF
M	1/1/1900	Active	New Jersey WDPF	NJ WDPF
N	1/1/1900	Active	New Jersey HCSF	NJ HCSF
P	1/1/1900	Active	Emergncy & Municipal Servcs Tx	EMS Tax
Q	1/1/1900	Active	FICA Med Hospital Ins / ER	Med/ER
R	1/1/1900	Active	Local ER	Local ER
S	1/1/1900	Active	Unemployment - Special	UI - Spcl
T	1/1/1900	Active	FICA Med Hospital Ins /EE-tips	Med/EE/tip
U	1/1/1900	Active	Unemployment ER	Unempl ER
V	1/1/1900	Active	Unemployment EE	Unempl EE
W	1/1/1900	Active	Voluntary Disability Plan EE	Vol Dis/EE
X	1/1/1900	Active	Voluntary Disability Plan ER	Vol Dis/ER
Z	1/1/1900	Active	FICA Med Hospital Ins /ER-tips	Med/ER/tip

• The TAX  deducted for an employee  are found in  PS_PAY_TAX
• PS_PY_TAX_GL_CLASS – This table has the payroll – tax – gl classification. 1. PYGL_GROUP_TYPE which has following xlat values

*Value	Effective Date	Status	*Long Name	*Short Name
F	1/1/1900	Active	Federal	Federal
L	1/1/1900	Active	Local	Local
S	1/1/1900	Active	State	State

PS_PAY_CHECK  = For gross and net

PS_PAY_DEDUCTION = Deduction

PS_PAY_TAX  = Tax deduction

PS_PAY_OTH_EARNS = OTHER EARNINGS

PS_PAY_SPCL_EARNS = SPECIAL EARNINGS