The SSA EFW2 Format (Record RA) for Annual and Quarterly Reporting

State Media Magnetic Media Reporting - SSA EFW2 File Format#

Record Name: Code RT - Total Record #

ColumnDescriptionSource
1-2Record IdentifierConstant "RT"
3-9Number of RW RecordsTotal number of code "RW" records reported since last code "RE" record
10-24Wages, Tips and Other CompensationDerived from IDFDV Field Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
25-39Federal Income Tax WithheldDerived from IDFDV Field Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
40-54Social Security WagesDerived from IDFDV Field Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
55-69Social Security Tax WithheldDerived from IDFDV Field Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
70-84Medicare Wages and TipsDerived from IDFDV Field Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
85-99Medicare Tax WithheldDerived from IDFDV Field Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
100-114Social Security TipsDerived from IDFDV Field Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
115-129Advanced Earned Income CreditDerived from IDFDV Field Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
130-144Dependent Care BenefitsDerived from IDFDV Field Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
145-159Deferred Compensation Contributions to Section 401(k)Derived from IDFDV Field Identifier: ‘W2-CODE-D’, total of all code "RW" records since last "RE" record
160-174Deferred Compensation Contributions to Section 403(b)Derived from IDFDV Field Identifier: ‘W2-CODE-E’, total of all code "RW" records since last "RE" record
175-189Deferred Compensation Contributions to Section 408(k)(6)Derived from IDFDV Field Identifier: ‘W2-CODE-F’, total of all code "RW" records since last "RE" record
190-204Deferred Compensation Contributions to Section 457(b)Derived from IDFDV Field Identifier: ‘W2-CODE-G’, total of all code "RW" records since last "RE" record
205-219Deferred Compensation Contributions to Section 501(c)(18)(D)Derived from IDFDV Field Identifier: ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
220-234Filler
235-249Non-Qualified Plan Section 457Derived from IDFDV Field Identifier: ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
250-264Employer Contribution to a Health Savings AccountDerived from IDFDV Field Identifier: ‘W2-CODE-W’, total of all code ‘RW’ records since last ‘RE’ record
265-279Non-Qualified Plan Not Section 457Derived from IDFDV Field Identifier: ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
280-309Blank
310-324Employer Cost of Premiums for Group Term Life Insurance over $50000Derived from IDFDV Field Identifier: ‘W2-CODE-C’, total of all code "RW" records since last "RE" record
325-339Income Tax Withheld by Third-Party PayerDerived from IDFDV Field Identifier: ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
340-354Income from Non-statutory Stock optionsDerived from IDFDV Field Identifier: ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
355-512Blank