PA_TE_FTX

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PA_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 FWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL FWT Marital Status
M=Married
S=Single
5 FWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL FWT Allowances
6 FWT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL FWT Additional Amount
7 FWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL FWT Additional Percentage
8 SPECIAL_FWT_STATUS Character(1) VARCHAR2(1) NOT NULL Special FWT Status
A=Non-Resident Alien
E=Exempt (not subject to FIT)
G=Maintain gross (no tax WH)
N=None
9 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
E=Exempt
H=ER FICA Exmpt
M=Medicare only
N=Subject
10 FUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from FUT
11 EIC_STATUS Character(1) VARCHAR2(1) NOT NULL Earned Income Credit Status
M=Married, both spouses filing
N=Not applicable
S=Single,or Head of Household
U=Married without spouse filing
12 W2_EMPLID Character(11) VARCHAR2(11) NOT NULL Emplid getting w2/1099