VERIF_FORMW2_13(SQL Table) |
Index Back |
---|---|
Wages and Tax StatementVerification Form W2 - Wages and Tax Statement |
# | 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 |