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 "RW" records reported since last  "RE" record.  \\Right justify and zero fill.
|10-24|Wages, Tips and Other Compensation|Total of all  "RW" records since last "RE" record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands emplyees.__ \\Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’
|25-39|Federal Income Tax Withheld|Total of all "RW" records since last "RE" record. \\Right justify and zero fill. \\__Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands emplyees.__ \\Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’ 
|40-54|Social Security Wages|Total of all "RW" records since last "RE" record. \\_Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "Q-MQGE" or "X-Railroad".__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’
|55-69|Social Security Tax Withheld|Total of all "RW" records since last "RE" record. \\_Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "Q-MQGE" or "X-Railroad".__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’
|70-84|Medicare Wages and Tips|Total of all "RW" records since last "RE" record. \\ __Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "X-Railroad".__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’
|85-99|Medicare Tax Withheld|Total of all "RW" records since last "RE" record. \\ __Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "X-Railroad".__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-MEDI-TAX’
|100-114|Social Security Tips|Total of all "RW" records since last "RE" record. \\ __Zero fill if the Employment Code is position 219 of the preceeding RE Employer Record is "Q-MQGE" or "X-Railroad".__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-SSN-TIP’
|115-129|Blank|Fill with blanks.  Reserved for SSA use.
|130-144|Dependent Care Benefits|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands emplyees.__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-DEP-CARE’ 
|145-159|Deferred Compensation Contributions to Section 401(k) (Code D)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-D’
|160-174|Deferred Compensation Contributions to Section 403(b)(Code E)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-E’
|175-189|Deferred Compensation Contributions to Section 408(k)(6) (Code F)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill.  \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-F’
|190-204|Deferred Compensation Contributions to Section 457(b) (Code G)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__  \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-G’
|205-219|Deferred Compensation Contributions to Section 501(c)(18)(D) (Code H)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill.  \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-H’
|220-234|Blank|Fill with blanks.  Reserved for SSA use. 
|235-249|Nonqualified Plan Section 457 Distributions or Contributions|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-457’
|250-264|Employer Contribution to a Health Savings Account (Code W)|Total of all "RW" records since last "RE" record. \\No negative amounts.  \\ __Does not apply to Puerto Rico or Northern Mariana Islands emplyees.__\\Right justify and zero fill.  \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-W’
|265-279|Nonqualified Plan Not Section 457 Distributions or Contributions|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-N457’
|280-294|Nontaxable Combat Pay (Code Q)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico or Northern Mariana Islands emplyees.__  \\Right justify and zero fill. \\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 of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico or Northern Mariana Islands emplyees.__ \\Right justify and zero fill. \\ 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 of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\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 of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\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’
|340-354|Income from the Exercise of Non-statutory Stock Options (Code V)|Total of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\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 of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico or Northern Mariana Islands emplyees.__  \\Right justify and zero fill. \\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 of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\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 of all "RW" records since last "RE" record. \\ __Does not apply to Puerto Rico employees.__ \\Right justify and zero fill. \\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.