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
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 RO - Employee Wage Record
At line 5 changed one line
!Record Name: Code RO
||Column||Description||Source
|1-2|Record Identifier|Constant ‘RO’
|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.