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 RA) 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 one line
!Record Name: Code RO
At line 7 changed 25 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.__
|100-110|Blank|Fill with blanks. Reserved for SSA use.
|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.
|144-274|Blank|Fill with blanks. Reserved for SSA use.
|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.__
|352-362|Blank|Fill with blanks. Reserved for SSA use.
|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.__
|385-512|Blank|Fill with blanks. Reserved for SSA use.
|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-264|Blank|
;Location 265 to 362: For Puerto Rico employees only.
||Column||Description||Source
|265|Civil Status
|266-274|Spouse’s SSN|Blank
|275-285|Wages Subject to Puerto Rico Tax|Stored as zeroes
|286-296|Commissions Subject to Puerto Rico Tax|Stored as zeroes
|297-307|Allowances Subject to Puerto Rico Tax|Stored as zeroes
|308-318|Tips Subject to Puerto Rico Tax|Stored as zeroes
|319-329|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax|Stored as zeroes
|330-340|Puerto Rico Tax Withheld|Stored as zeroes
|341-351|Retirement Fund Subject to Puerto Rico Tax|Stored as zeroes
|352-362|Blank|
;Location 363 to 384:For Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees.
||Column||Description||Source
|363-373|Total wages, tips and other compensation subject to Virgin Islands income tax|Stored as zeroes
|374-384|Virgin Islands, etc… Income Tax Withheld|Stored as zeroes
|385-512|Blank|