YE_AMOUNTS

(SQL Table)
Index Back

W-2 Amounts

This record contains the amounts used on the W-2.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
4 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
A=T4A Slip
B=Business Payrolls Survey - CAN
C=WCB Assessable Earnings
E=Record of Employment
F=940 - Annual Employer's FUTA
I=W-2VI
J=W-2cVI
M=W-2GU
N=W-2cGU
P=W-2PR
Q=W-2cPR
R=RL-1 Slip
S=W-2AS
T=T4 Slip
U=W-2cAS
V=RL-2 Slip
W=W-2
X=W-2c
Y=1099-R
Z=1042-S
5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
6 BOX Character(4) VARCHAR2(4) NOT NULL Box
7 STATE Character(6) VARCHAR2(6) NOT NULL State
8 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
9 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
10 RES_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
11 W2_AMOUNT Signed Number(15,2) DECIMAL(13,2) NOT NULL W-2 Amount