GPUS_FWT_ER

(SQL Table)
Index Back

Company Federal Tax Data

Company Federal Tax Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 GPUS_FICA_EE Character(1) VARCHAR2(1) NOT NULL FICA Status Employee
E=Exempt
M=Medicare Only
N=Subject

Default Value: N

5 GPUS_FICA_ER Character(1) VARCHAR2(1) NOT NULL FICA Status Employee
E=Exempt
M=Medicare Only
N=Subject

Default Value: N

6 GPUS_FUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from FUTA

Y/N Table Edit

Default Value: N