YE_AMOUNTS(SQL Table) |
Index Back |
---|---|
W-2 AmountsThis 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 |