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

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
10 26-Nov-2021 10:22 11 KB mmcfarland to previous
9 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
8 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
6 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
5 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
4 26-Nov-2021 10:22 11 KB mmcfarland to previous | to last
3 26-Nov-2021 10:22 8 KB mmcfarland to previous | to last
2 26-Nov-2021 10:22 8 KB mmcfarland to previous | to last
1 26-Nov-2021 10:22 182 bytes mmcfarland to last

Page References

Incoming links Outgoing links
W 2_EFW 2_RECORD_RW...nobody
W2_EFW2_RECORD_RW

Version management

Difference between version and

At line 1 changed one line
The SSA EFW2 Format (Record RW) for Annual and Quarterly Reporting
!State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting
At line 3 changed one line
!!State Media Magnetic Media Reporting - SSA EFW2 File Format
!!Record Name: Code RW - Employee Wage Record
At line 5 removed one line
!Record Name: Code RW - Employee Wage Record
At line 8 changed 2 lines
|3-11|Social Security Number|Required. Enter the employee's SSN. \\If an invalid SSN is encountered, this field is filled with zeros. \\Derived from the ‘W2-EE-SSN’ (seq 2500) [IDFDV] Field Identifier.
|12-26|Employee First Name|Required. Enter the employee's first name. \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-FIRST-NAME’ (seq 2510) [IDFDV] Field Identifier.
|3-11|Social Security Number|Required. \\ Enter the employee's SSN. \\If an invalid SSN is encountered, this field is filled with zeros. \\Derived from the ‘W2-EE-SSN’ (seq 2500) [IDFDV] Field Identifier.
|12-26|Employee First Name|Required. \\ Enter the employee's first name. \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-FIRST-NAME’ (seq 2510) [IDFDV] Field Identifier.
At line 11 changed one line
|42-61|Employee Last Name|Required. Enter the employee's last name. \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-LAST-NAME’ (seq 2530) [IDFDV] Field Identifier.
|42-61|Employee Last Name|Required. \\ Enter the employee's last name. \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-LAST-NAME’ (seq 2530) [IDFDV] Field Identifier.
At line 16 changed 3 lines
|132-133|Employee State Abbreviation|Enter the employee's State or commonwealth/territory. For a foreign address, fill with blanks. \\Derived from the ‘W2-EE-STATE’ (seq 2630) [IDFDV] Field Identifier.
|134-138|Employee ZIP Code|Enter the employee's ZIP code. For a foreign address, fill with blanks. \\Derived from the ‘W2-EE-ZIP’ (seq 2640) [IDFDV] Field Identifier.
|139-142|Employee ZIP Code Extension|Enter the employee's four-digit ZIP code extension. If not applicable, fill with blanks. \\Derived from the ‘W2-EE-ZIP-EXT’ (seq 2650) [IDFDV] Field Identifier.
|132-133|Employee State Abbreviation|Enter the employee's State or commonwealth/territory. \\ For a foreign address, fill with blanks. \\Derived from the ‘W2-EE-STATE’ (seq 2630) [IDFDV] Field Identifier.
|134-138|Employee ZIP Code|Enter the employee's ZIP code. \\ For a foreign address, fill with blanks. \\Derived from the ‘W2-EE-ZIP’ (seq 2640) [IDFDV] Field Identifier.
|139-142|Employee ZIP Code Extension|Enter the employee's four-digit ZIP code extension. \\ If not applicable, fill with blanks. \\Derived from the ‘W2-EE-ZIP-EXT’ (seq 2650) [IDFDV] Field Identifier.
At line 20 changed one line
|148-170|Employee Foreign State/Province|If applicable, enter the employee's foreign State/Province. \\ Left justify and fill with blanks. \\Derived from the ‘W2-EE-F-STATE’ (seq 2660) [IDFDV] Field Identifier.
|148-170|Employee Foreign State/Province|If applicable, enter the employee's foreign State/Province. \\ Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from the ‘W2-EE-F-STATE’ (seq 2660) [IDFDV] Field Identifier.
At line 22 changed 14 lines
|186-187|Employee Country Code|If one of the following applies, fill with blanks: \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code. \\ Derived from the ‘W2-EE-COUNTRY’ (seq 2680) [IDFDV] Field Identifier.
|188-198|Wages, Tips and Other Compensation|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-FIT-WAGE’ (seq 3000) [IDFDV] Field Identifier. \\ \\__Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.__
|199-209|Federal Income Tax Withheld|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-FIT-TAX’ (seq 3010) [IDFDV] Field Identifier.
|210-220|Social Security Wages|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-SSN-WAGE’ (seq 3020) [IDFDV] Field Identifier.
|221-231|Social Security Tax Withheld|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-SSN-TAX’ (seq 3030) [IDFDV] Field Identifier.
|232-242|Medicare Wages and Tips|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-MEDI-WAGE’ (seq 3040) [IDFDV] Field Identifier.
|243-253|Medicare Tax Withheld|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-MEDI-TAX’ (seq 3050) [IDFDV] Field Identifier.
|254-264|Social Security Tips|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-SSN-TIP’ (seq 3060) [IDFDV] Field Identifier.
|265-275|Blank|Reserved for SSA use.
|276-286|Dependent Care Benefits|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-DEP-CARE’ (seq 3090) [IDFDV] Field Identifier.
|287-297|Deferred Compensation Contributions to Section 401(k) (Code D)|No negative amounts. \\Right justify and zero fill. \\ Derived from the ‘W2-CODE-D’ (seq 4030) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico.__
|298-308|Deferred Compensation Contributions to Section 403(b) (Code E)|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-CODE-E’ (seq 4040) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico.__
|309-319|Deferred Compensation Contributions to Section 408(k)(6) (Code F)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-F’ (seq 4050) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico.__
|320-330|Deferred Compensation Contributions to Section 457(b) (Code G)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-G’ (seq 4060) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico.__
|186-187|Employee Country Code|If one of the following applies, fill with blanks: \\ \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code. \\ Derived from the ‘W2-EE-COUNTRY’ (seq 2680) [IDFDV] Field Identifier.
|188-198|Wages, Tips and Other Compensation|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-FIT-WAGE’ (seq 3000) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.__
|199-209|Federal Income Tax Withheld|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-FIT-TAX’ (seq 3010) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.__
|210-220|Social Security Wages|Zero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is __'Q-MGQE' or 'X-Railroad'.__ \\ \\If Employment Code is __'H-Household'__ and the tax year is 1994 or later, the __sum__ of this field and the Social Security Tips field must be __equal to or greater than__ the annual Household minimum for the tax year being reported. Otherwise, reports zeros. \\ \\ The __sum of__ this field and the Social Security Tips field should __not__ exceed the annual maximum Social Security wage base for the tax year being reported. \\ \\ No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-SSN-WAGE’ (seq 3020) [IDFDV] Field Identifier.
|221-231|Social Security Tax Withheld|Zero fill if the Employment Code reported in position 219 of the preceeding RE (Employer_ Record is __'Q-MGQE' or 'X-Railroad'.__ \\ \\ If the Employement Code is __not 'Q-MGQE' or 'X-Railroad'__ and the amount in this field is greater than zero, then the Social Security Wages field and/or the Social Security Tips field must be greater than zero. \\ \\No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-SSN-TAX’ (seq 3030) [IDFDV] Field Identifier.
|232-242|Medicare Wages and Tips|Zero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is __'X-Railroad'.__ \\ \\If Employment Code is __'H-Household'__ and the tax year is 1994 or later, this field must be __equal to or greater than__ the annual Household minimum for the tax year being reported. Otherwise, fill with zeros. \\ \\ No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-MEDI-WAGE’ (seq 3040) [IDFDV] Field Identifier.
|243-253|Medicare Tax Withheld|Zero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is __'X-Railroad'.__ \\ \\No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-MEDI-TAX’ (seq 3050) [IDFDV] Field Identifier.
|254-264|Social Security Tips|Zero fill if the Employment Code reported in position 219 of the preceding RE (Employer) Record is __'Q-MGQE' or 'X-Railroad'.__ \\ \\The __sum__ of this field and the Social Security Wages field should __not__ exceed the annual maximum Social Security wage base for the tax year being reported. Otherwise, reports zeros. \\ \\If Employment Code is __'H-Household'__ and the tax year is 1994 or later, the __sum__ of this field and the Social Security Wages field must be __equal to or greater than__ the annual Household minimum for the tax year being reported. Otherwise, report zeros. \\ \\No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-SSN-TIP’ (seq 3060) [IDFDV] Field Identifier.
|265-275|Blank|Fill with blanks. Reserved for SSA use.
|276-286|Dependent Care Benefits|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-DEP-CARE’ (seq 3090) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico, Virgin Islands, American Samoa, Guam or Northern Mariana Islands employees.__
|287-297|Deferred Compensation Contributions to Section 401(k) (Code D)|No negative amounts. \\Right justify and zero fill. \\ Derived from the ‘W2-CODE-D’ (seq 4030) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico employees.__
|298-308|Deferred Compensation Contributions to Section 403(b) (Code E)|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-CODE-E’ (seq 4040) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico employees.__
|309-319|Deferred Compensation Contributions to Section 408(k)(6) (Code F)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-F’ (seq 4050) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico employees.__
|320-330|Deferred Compensation Contributions to Section 457(b) (Code G)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-G’ (seq 4060) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico employees.__
At line 37 changed 4 lines
|342-352|Blank|Reserved for SSA use.
|353-363|Non-qualified Plan Section 457 Distributions or Contributions|No negative amounts. \\ Right justify and zero fill.\\ Derived from the ‘W2-NQUAL-457’ (seq 3102) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico.__
|364-374|Employer Contributions to a Health Savings Account (Code W)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-W’ (seq 4190) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico or Noerthern Mariana Islands employees.__
|375-385|Non-qualified Plan Not section 457 Distributions or Contributions|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-NQUAL-N457’ (seq 3104) [IDFDV] Field Identifier.
|342-352|Blank|Fill with blanks. Reserved for SSA use.
|353-363|Nonqualified Plan Section 457 Distributions or Contributions|No negative amounts. \\ Right justify and zero fill.\\ Derived from the ‘W2-NQUAL-457’ (seq 3102) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico employees.__
|364-374|Employer Contributions to a Health Savings Account (Code W)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-W’ (seq 4190) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|375-385|Nonqualified Plan Not Section 457 Distributions or Contributions|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-NQUAL-N457’ (seq 3104) [IDFDV] Field Identifier. \\__Does not apply to Puerto Rico employees.__
At line 43 changed 2 lines
|408-418|Employer Cost of Premiums for Group Term Life Insurance Over $50,000 (Code C)|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-CODE-C’ (seq 4020) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico.__
|419-429|Income from the Exercise of Non-Statutory Stock Options (Code V)|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-CODE-V’ (seq 4180) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico.__
|408-418|Employer Cost of Premiums for Group Term Life Insurance Over $50,000 (Code C)|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-CODE-C’ (seq 4020) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico employees.__
|419-429|Income from the Exercise of Non-Statutory Stock Options (Code V)|No negative amounts. \\Right justify and zero fill. \\Derived from the ‘W2-CODE-V’ (seq 4180) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico employees.__
At line 53 changed 2 lines
|488|Retirement Plan Indicator|Enter "1" for a sick pay indicator. Otherwise, enter "0" (zero). \\ Derived from the ‘W2-RETIRE-PLAN’ (seq 6020) [IDFDV] Field Identifier.
|489|Third-Party Sick Pay Indicator|Enter "1" for a retirement plan. Otherwise, enter "0" (zero). Derived from the ‘W2-3PARTY-SICK’ (seq 6060) [IDFDV] Field Identifier.
|488|Retirement Plan Indicator|Enter "1" for a retirement plan. Otherwise, enter "0" (zero). \\ Derived from the ‘W2-RETIRE-PLAN’ (seq 6020) [IDFDV] Field Identifier.
|489|Third-Party Sick Pay Indicator|Enter "1" for a sick pay indicator. Otherwise, enter "0" (zero). Derived from the ‘W2-3PARTY-SICK’ (seq 6060) [IDFDV] Field Identifier.
At line 55 added one line
This page (revision-10) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop