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 RA) 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 changed one line
!Record Name: Code RW - Employee Wage Record
||Column||Description||Source
|1-2|Record Identifier|Constant "RW"
|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.
|27-41|Employee Middle Name or Initial|If applicable, enter the employee's middle name or initial. \\Left Justify and fill with blanks. Otherwise, fill with blanks. \\Derived from the ‘W2-EE-MIDDLE’ (seq 2520) [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.
|62-65|Employee Suffix|If applicable, enter the employee's alphabetic suffix. \\ Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from the ‘W2-EE-SUFFIX’ (seq 2540) [IDFDV] Field Identifier.
|66-87|Employee Location Address|Enter the employee's location address (Attention, Suite, Room Number, etc.) \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-LOCN-ADDR’ (seq 2600) [IDFDV] Field Identifier.
|88-109|Employee Delivery Address|Enter the employee's delivery address (Street or Post Office Box). \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-DELIV-ADDR’ (seq 2610) [IDFDV] Field Identifier.
|110-131|Employee City|Enter the employee's City. \\Left justify and fill with blanks. \\Derived from the ‘W2-EE-CITY’ (seq 2620) [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.
|143-147|Blank|Fill with blanks. Reserved for SSA use.
|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.
|171-185|Employee Foreign Postal Code|If applicable, enter the employee's foreign postal code. \\Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from the ‘W2-EE-F-POSTAL’ (seq 2670) [IDFDV] Field Identifier.
|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.__
|331-341|Deferred Compensation Contributions to Section 501(c)(18)(D) (Code H)|No negative amounts. \\ Right justify and zero fill. \\Derived from the ‘W2-CODE-H’ (seq 4070) [IDFDV] Field Identifier. \\ __Does not apply to Puerto Rico employees.__
|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.__
|386-396|Nontaxable Combat Pay (Code Q)|No negative amounts. \\ Right justify and zero fill. \\ __Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|397-407|Blank|Fill with blanks. Reserved for SSA use.
|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.__
|430-440|Deferrals Under a Section 409A Non-Qualified Deferred Compensation Plan (Code Y)|No negative amounts. \\ Right justify and zero fill. \\ __Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|441-451|Designated Roth Contributions to a Section 401 (k) Plan (Code AA)|No negative amounts. \\ Right justify and zero fill. \\ __Does not apply to Puerto Rico employees.__
|452-462|Designated Roth Contributions to a Section 403 (b) Salary Reduction Agreement (Code BB)|No negative amounts. \\Right justify and zero fill. \\ __Does not apply to Puerto Rico employees.__
|463-473|Cost of Employer-Sponsored Health Coverage (Code DD)|No negative amounts. \\Right justify and zero fill. \\ __Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|474-484|Permitted Benefits Under a Qualified Small Employer Health Reimbursement Arrangement (Code FF)|No negative amounts. \\ Right justify and zero fill.
|485|Blank|Fill with blanks. Reserved for SSA use.
|486|Statutory Employee Indicator|Enter "1" for statutory employee. Otherwise, enter "0" (zero). \\Derived from the ‘W2-STAT-EE’ (seq 6000) [IDFDV] Field Identifier.
|487|Blank|Fill with blanks. Reserved for SSA use.
|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.
|490-512|Blank|Fill with blanks. Reserved for SSA use.
This page (revision-10) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop