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

!!State Media Magnetic Media Reporting - SSA EFW2 File Format

!Record Name: Code RT - Total Record 
||Column||Description||Source
|1-2|Record Identifier|Constant "RT"
|3-9|Number of RW Records|Total number of code "RW" records reported since last code "RE" record
|10-24|Wages, Tips and Other Compensation|Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
|25-39|Federal Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
|40-54|Social Security Wages|Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
|55-69|Social Security Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
|70-84|Medicare Wages and Tips|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
|85-99|Medicare Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
|100-114|Social Security Tips|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
|115-129|Advanced Earned Income Credit|Derived from [IDFDV] Field Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
|130-144|Dependent Care Benefits|Derived from [IDFDV] Field Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
|145-159|Deferred 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-174|Deferred 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-189|Deferred 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-204|Deferred 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-219|Deferred 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-234|Filler 
|235-249|Non-Qualified Plan Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
|250-264|Employer Contribution to a Health Savings Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-W’, total of all code ‘RW’ records since last ‘RE’ record
|265-279|Non-Qualified Plan Not Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
|280-294|Nontaxable Combat Pay (Code Q)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|295-309|Cost of Employer-Sponsored Health Coverage (Code DD)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|310-324|Employer Cost of Premiums for Group Term Life Insurance over $50,000 (Code C)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico employees.__ \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-C’
|325-339|Income Tax Withheld by Payer of Third-Party Sick Pay|Total Federal Income Tax withheld by third-parties (generally insurance companies) from sick or disability payments made to your employees. \\Right justify and zero fill. \\__Does not apply to Puerto Rico employees.\\__Derived from [IDFDV] Field Identifier: ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
|340-354|Income from the Exercise of Non-statutory Stock Options (Code V)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico employees.__ \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’
|355-369|Deferrals Under a Section 409A Nonqualified Deferred Compensation Plan (Code Y)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|370-384|Designated Roth Contributions to a Section 401(k) Plan (Code AA)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico employees.__
|385-399|Designated Roth Contributions to a Section 403(b) Salary Reduction Agreement (Code BB)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico employees.__
|400-414|Permitted Benefits Under a Qualified Small Employer Health Reimbursement Arrangement (Code FF)|Total for all RW (Employee) Records reported since the last RE (Employer) Record. \\Right justify and zero fill. 
|415-512|Blank|Fill with blanks.  Reserved for SSA use.