VERIF_FORMW2_13

(SQL Table)
Index Back

Wages and Tax Statement

Verification Form W2 - Wages and Tax Statement

  • Parent record: VERIFICATION
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: STUDENT_AID

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    5 SCH_NBR Character(4) VARCHAR2(4) NOT NULL Schedule Number
    6 W2_BOX13_CODE Character(2) VARCHAR2(2) NOT NULL This field is used in Financial Aid - Application Data Verification.
    A=Uncollected SS/RRTA tax on tip
    AA=401(k) Roth Contributions
    B=Uncollected Medicare tax tips
    BB=403(b) Roth Contributions
    C=Group-term life insurance > 50
    D=Elective deferrals - 401(k)
    E=Elective deferrals - 403(b)
    F=Elective deferrals - 408(k)
    G=Deferrals to 457(b)
    H=Elective deferrals - 501(c)18D
    J=Nontaxable sick pay
    K=Excess golden parachute pymnt
    L=Business expense reimbursement
    M=SS/RRTA tax on life insurance
    N=Medicare tax on life insurance
    P=Excludable moving expense
    Q=Nontaxable Combat Pay
    R=Med savings acct - employer
    S=Salary reduction 408(p) SIMPLE
    T=Adoption benefits
    V=Nonstatutory Stock Options
    W=Health Savings Account
    Y=Deferrals under section 409A
    Z=Income under section 409A
    7 W2_BOX13_AMOUNT Signed Number(7,0) DECIMAL(6) NOT NULL W2 Box 13 Amount
    8 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year
    9 W2_BOX13_CODE_2012 Character(2) VARCHAR2(2) NOT NULL This field is used in Financial Aid - Application Data Verification.
    A=Uncollected SS/RRTA tax on tip
    AA=401(k) Roth Contributions
    B=Uncollected Medicare tax tips
    BB=403(b) Roth Contributions
    C=Group-term life insurance > 50
    CC=HIRE exempt wages and tips
    D=Elective deferrals - 401(k)
    E=Elective deferrals - 403(b)
    F=Elective deferrals - 408(k)
    G=Deferrals to 457(b)
    H=Elective deferrals - 501(c)18D
    J=Nontaxable sick pay
    K=Excess golden parachute pymnt
    L=Business expense reimbursement
    M=SS/RRTA tax on life insurance
    N=Medicare tax on life insurance
    P=Excludable moving expense
    Q=Nontaxable Combat Pay
    R=Med savings acct - employer
    S=Salary reduction 408(p) SIMPLE
    T=Adoption benefits
    V=Nonstatutory Stock Options
    W=Health Savings Account
    Y=Deferrals under section 409A
    Z=Income under section 409A
    10 W2_BOX13_CODE_2014 Character(2) VARCHAR2(2) NOT NULL This field is used in Financial Aid - Application Data Verification.
    A=Uncollected SS/RRTA tax on tip
    AA=401(k) Roth Contributions
    B=Uncollected Medicare tax tips
    BB=403(b) Roth Contributions
    C=Group-term life insurance > 50
    D=Elective deferrals - 401(k)
    DD=Employer Health Coverage
    E=Elective deferrals - 403(b)
    EE=457(b) Roth Contributions
    F=Elective deferrals - 408(k)
    G=Deferrals to 457(b)
    H=Elective deferrals - 501(c)18D
    J=Nontaxable sick pay
    K=Excess golden parachute pymnt
    L=Business expense reimbursement
    M=SS/RRTA tax on life insurance
    N=Medicare tax on life insurance
    P=Excludable moving expense
    Q=Nontaxable Combat Pay
    R=Med savings acct - employer
    S=Salary reduction 408(p) SIMPLE
    T=Adoption benefits
    V=Nonstatutory Stock Options
    W=Health Savings Account
    Y=Deferrals under section 409A
    Z=Income under section 409A