W2_AMOUNTS

(SQL Table)
 Index Back

W-2 Amounts

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

  • Parent record: W2_DATA

    • # 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 W2_AMOUNT Signed Number(15,2) DECIMAL(13,2) NOT NULL W-2 Amount