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. |
