This page (revision-20) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by mmcfarland

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
20 26-Nov-2021 10:22 6 KB Meg McFarland to previous
19 26-Nov-2021 10:22 6 KB Meg McFarland to previous | to last
18 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
17 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
16 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
15 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
14 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
13 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
12 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
11 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
10 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
9 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
8 26-Nov-2021 10:22 7 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 8 KB mmcfarland to previous | to last
6 26-Nov-2021 10:22 8 KB mmcfarland to previous | to last
5 26-Nov-2021 10:22 8 KB mmcfarland to previous | to last
4 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
3 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
2 26-Nov-2021 10:22 5 KB mmcfarland to previous | to last
1 26-Nov-2021 10:22 3 KB mmcfarland to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed one line
The SSA EFW2 Format (Record RA) for Annual and Quarterly Reporting
!State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting
At line 3 changed 3 lines
!!State Media Magnetic Media Reporting - SSA EFW2 File Format
!Record Name: Code RT - Total Record
!!Record Name: Code RT - Total Record
At line 8 changed 28 lines
|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.
|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 employees.__ \\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 employees.__ \\ 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 employees.__ \\ Right justify and zero fill.
|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 employees.__ \\ Right justify and zero fill.
|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. \\ 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. \\Total Federal Income Tax withheld by third-parties (generally insurance companies) from sick or disability payments made to your employees. \\ __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. \\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 employees.__ \\ Right justify and zero fill.
|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.
|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.
|400-414|Permitted Benefits Under a Qualified Small Employer Health Reimbursement Arrangement (Code FF)|Total of all "RW" records since last "RE" record. \\Right justify and zero fill.
At line 35 added one line