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 #

ColumnDescriptionSource
1-2Record IdentifierConstant "RT"
3-9Number of RW RecordsTotal number of "RW" records reported since last "RE" record.
Right justify and zero fill.
10-24Wages, Tips and Other CompensationTotal 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-39Federal Income Tax WithheldTotal 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-54Social Security WagesTotal 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-69Social Security Tax WithheldTotal 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-84Medicare Wages and TipsTotal 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-99Medicare Tax WithheldTotal 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-114Social Security TipsTotal 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-129BlankFill with blanks. Reserved for SSA use.
130-144Dependent Care BenefitsTotal 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-159Deferred 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-174Deferred 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-189Deferred 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-204Deferred 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-219Deferred 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-234BlankFill with blanks. Reserved for SSA use.
235-249Nonqualified Plan Section 457 Distributions or ContributionsTotal 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-264Employer 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-279Nonqualified Plan Not Section 457 Distributions or ContributionsTotal 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-294Nontaxable 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-309Cost 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-324Employer 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-339Income Tax Withheld by Payer of Third-Party Sick PayTotal 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-354Income 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-369Deferrals 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-384Designated 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-399Designated 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-414Permitted 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-512BlankFill with blanks. Reserved for SSA use.

This particular version was published on 26-Nov-2021 10:22 by mmcfarland.Top