This page (revision-27) 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
27 26-Nov-2021 10:22 4 KB Meg McFarland to previous
26 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last
25 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last
24 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last
23 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last
22 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last
21 26-Nov-2021 10:22 4 KB Meg McFarland to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed one line
!State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting
The SSA EFW2 Format (Record RO) for Annual and Quarterly Reporting
At line 3 changed one line
!!Record Name: Code RO - Employee Wage Record
!!State Media Magnetic Media Reporting - SSA EFW2 File Format
At line 5 added 2 lines
!Record Name: Code RO - Employee Wage Record
At line 7 changed 9 lines
|3-11|Blank|Fill with blanks. Reserved for SSA use.
|12-22|Allocated Tips|No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-ALLOC-TIP’ (seq 3070)
|23-33|Uncollected Employee Tax on Tips (Codes A and B)|Combine the uncollected Social Security tax and the uncollected Medicare tax. \\No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’ (seq 4010)
|34-44|Medical Savings Account (Code R)|No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-R’ (seq 4150). \\ \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|45-55|Simple Retirement Account (Code S)|No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-S’ (seq 4160). \\ \\__Does not apply to Puerto Rico employees.__
|56-66|Qualified Adoption Expenses (Code T)|No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-T’ (seq 4170). \\ \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|67-77|Uncollected Social Security or RRTA Tax on Cost of Group Term \\Life Insurance over $50,000 (Code M)|No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-M’ (seq 4110). \\ \\__Does not apply to Puerto Rico employees.__
|78-88|Uncollected Medicare Tax on Cost of Group Term Life Insurance \\over $50,000 (Code N)|No negative amounts. \\Right justify and zero fill. \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-N’ (seq 4120). \\ \\__Does not apply to Puerto Rico employees.__
|89-99|Income Under a Nonqualified Deferred Compensation Plan \\That Fails to Satisfy Section 409A (Code Z)|No negative amounts. \\Right justify and zero fill. \\ \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|3-11|Blank|
|12-22|Allocated Tips|Derived from [IDFDV] Field Identifier: ‘W2-ALLOC-TIP’ (seq 3070)
|23-33|Uncollected Employee Tax on Tips|A combination of the uncollected social security tax and the uncollected medicare tax\\ \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’ (seq 4010)
|34-44|Medical Savings Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-R’ (seq 4150)
|45-55|Simple Retirement Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-S’ (seq 4160)
|56-66|Qualified Adoption Expenses|Derived from [IDFDV] Field Identifier: ‘W2-CODE-T’ (seq 4170)
|67-77|Uncollected SSA tax on Group Ins > 50000|Derived from [IDFDV] Field Identifier: ‘W2-CODE-M’ (seq 4110)
|78-88|Uncollected Medicare tax on Group Ins > 50000|Derived from [IDFDV] Field Identifier: ‘W2-CODE-N’ (seq 4120)
|89-99|Income Under a Nonqualified Deferred Compensation Plan That Fails to Satisfy Section 409A (Code Z)
At line 17 changed 3 lines
|111-121|Designated Roth Contributions Under a Governmental \\Section 457(b) Plan )(Code EE)|No negative amounts. \\Right justify and zero fill. \\ \\__Does not apply to Puerto Rico or Northern Mariana Islands employees.__
|122-132|Income from Qualified Grants Under Section 83(i) (Code GG)|No negative amounts. \\Right justify and zero fill.
|133-143|Aggregate Deferrals Under Section 83(i) Elections as of \\the Close of the Calendar Year (Code HH)|No negative amounts. \\Right justify and zero fill.
|111-121|Designated Roth Contributions Under a Governmental Section 457(b) Plan )(Code EE)
|122-132|Income from Qualified Grants Under Section 83(i) (Code GG)
|133-143|Aggregate Deferrals Under Section 83(i) Elections as of the Close of the Calendar Year (Code HH)
At line 21 changed 7 lines
|275-285|Wages Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill.\\ \\__For Puerto Rico employees only.__
|286-296|Commissions Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill. \\ \\__For Puerto Rico employees only.__
|297-307|Allowances Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill. \\ \\__For Puerto Rico employees only.__
|308-318|Tips Subject to Puerto Rico Tax|SNo negative amounts. \\Right justify and zero fill. \\ \\__For Puerto Rico employees only.__
|319-329|Total Wages, Commissions, Tips, and Allowances \\ Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill. \\ \\__For Puerto Rico employees only.__
|330-340|Puerto Rico Tax Withheld|No negative amounts. \\Right justify and zero fill. \\ \\__For Puerto Rico employees only.__
|341-351|Retirement Fund Annual Contributions|No negative amounts. \\Right justify and zero fill. \\ \\__For Puerto Rico employees only.__
;Location 275 to 351: For Puerto Rico employees only.
|275-285|Wages Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
|286-296|Commissions Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
|297-307|Allowances Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
|308-318|Tips Subject to Puerto Rico Tax|SNo negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
|319-329|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
|330-340|Puerto Rico Tax Withheld|No negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
|341-351|Retirement Fund Annual Contributions Subject to Puerto Rico Tax|No negative amounts. \\Right justify and zero fill.\\__For Puerto Rico employees only.__
At line 29 changed 2 lines
|363-373|Total Wages, Tips and Other Compensation Subject to \\Virgin Islands, Guam, American Samoa or Northern Mariana Islands Income Tax|No negative amounts. \\Right justify and zero fill. \\ \\__For Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees only.__
|374-384|Virgin Islands, American Samoa, Guam, or \\ Northern Mariana Islands Income Tax Withheld|No negative amounts. \\Right justify and zero fill. \\ \\__For Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees only.__
;Location 363 to 384: For Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees only.
||Column||Description||Source
|363-373|Total Wages, Tips and Other Compensation subject to Virgin Islands, American Samoa, Guam, or Northern Mariana Islands Income Tax|No negative amounts. \\Right justify and zero fill.
|374-384|Virgin Islands, American Samoa, Guam, or Northern Mariana Islands Income Tax Withheld|No negative amounts. \\Right justify and zero fill.