The SSA EFW2 Format (Record RA) for Annual and Quarterly Reporting !!State Media Magnetic Media Reporting - SSA EFW2 File Format !Record Name: Code RO ||Column||Description||Source |1-2|Record Identifier|Constant ‘RO’ |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|