Federal W-2 Input File Layout
The following tables lists and defines the contents of the RA, RE, RW, RO, RT, RU, and RF data records.
A complete W-2 data file for processing contains records RA through RF. For more information, refer to the Social Security Administration's Specifications for Filing Forms W-2 Electronically.
RA Record (Submitter Record)
Field Name | Length | Column # | Required | Costpoint Source | Notes |
---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Constant: RA | ||
Submitter's Employer Identification Number (EIN) | 9 | 3-11 | Y | TAXBLE_ENTITY.tax_id | The EIN used for User ID/Password registration. Must be only numeric characters, with hyphens omitted. Must begin with 07, 08, 09, 17, 18, 19, 28, 29, 49, 69, 70, 78, 79 or 89. |
User Identification (User ID) | 8 | 12-19 | Y | Screen User ID, restricted to a length of 8 characters. | The User ID for the employee who is attesting to the accuracy of this file. |
Software Vendor Code | 4 | 20-23 | 1401 | The numeric four-digit Software Vendor Identification Code assigned by the National Association of Computerized Tax Processors (NACTP htt://nactp.org). Only required for companies who entered 99 (off the shelf software) in the software code field in positions 36-37. Otherwise, position should be filled with blanks. | |
Blank | 5 | 24-28 | Filled with blanks. Reserved for SSA use. | ||
Resub Indicator | 1 | 29 | WFID Resub field on the Create Federal W-2 File screen. | If you entered a WFID Resub, value is 1. Otherwise, value entered should be 0. | |
Resub Wage File Identifier (WFID) | 6 | 30-35 | WFID Resub field on the Create Federal W-2 File screen. | If you entered a 1 for WFID Resub (position 29), Costpoint enters the WFID assigned by the SSA. Otherwise this position is filled with blanks. | |
Software Code | 2 | 36-37 | One of the following codes:
|
||
Company Name | 57 | 38-94 | TAXBLE_ENTITY.taxable_entity_name | The company name, left-justified and filled with blanks. | |
Location Address | 22 | 95-116 | TAXBLE_ENTITY.In_2_adr(comma)
TAXBLE_ENTITY.In_3_adr |
The company's location address (Attention, Suite, Room Number) Example: 2nd Floor, Suite 234
Should be left-justified and filled with blanks. |
|
Delivery Address | 22 | 117-138 | TAXBLE_ENTITY.In_1_adr | The company's delivery address (Street or Post Office Box)
Example: 123 Main Street Should be left-justified and filled with blanks. |
|
City | 22 | 139-160 | TAXBLE_ENTITY.city_name | The company's city, left-justified and filled with blanks. | |
U.S. State Abbreviation | 2 | 161-162 | The first five digits of TAXBLE_ENTITY.mail_state_dc
(if the code determines the taxable entity is a US state or commonwealth/territory). |
The company's state or commonwealth/territory. For a foreign address, this is filled with blanks. | |
U.S. Zip Code | 5 | 163-167 | The first five digits of TAXBLE_ENTITY.postal_cd (omit hyphen)
(if the code determines the taxable entity is a US state or commonwealth/territory). |
The company's zip code. | |
US Zip Code Extension | 4 | 168-171 | The four digits following the hyphen from the TAXBLE_ENTITY.postal_cd (Omit hyphen)
(if the code determines the taxable entity is a US state or commonwealth/territory) |
The submitter's four-digits extension of the zip code. If not applicable, fill with blanks. | |
Blank | 5 | 172-176 | Filled with blanks. Reserved for SSA use. | ||
Foreign State/Province | 23 | 177-199 | TAXBLE_ENTITY.mail_state_doc | If applicable, up to 23 characters for the company's foreign state province, left-justified and fill with blanks. Otherwise, filled with blanks. | |
Foreign Postal Code | 15 | 200-214 | TAXBLE_ENTITY.postal_cd | If applicable, the company's foreign postal code, left-justified and fill with blanks. Otherwise, filled with blanks | |
Country Code | 2 | 215-216 | COUNTRY_mag_media_cd | If one of the following applies, this position is filled with blanks.
|
|
Submitter Name | 57 | 217-273 | Y | TAXBLE_ENTITY.taxable_entity_name | The name of the organization to receive error notification if this file cannot be processed, left justified and filled with blanks. |
Location Address | 22 | 274-295 | No | TAXBLE_ENTITY.ln_2_adr (comma)
TAXBLE_ENTITY.In_3_adr |
The submitter's location address (Attention, Suite, Room Number, etc.).
Example: 2nd Floor, Suite 234 Left justified and filled with blanks. If blank, leave blank. |
Delivery Address | 22 | 296-317 | Y | TAXBLE_ENTITY.ln_1_adr | The submitter's delivery address (state or Post Office box), left-justified and filled with blanks. |
City | 22 | 318-339 | Y | TAXBLE_ENTITY.city_name | The submitter's city, left-justified and filled with blanks. |
US State Abbreviation | 2 | 340-341 | Y | TAXBLE_ENTITY.mail_state_dc
(if the code determines the taxable entity is a US state, commonwealth, or territory) |
The company's state or commonwealth/territory. A foreign address will be filled with blanks. |
US Zip Code | 5 | 342-346 | Y | The first five digits of TABLE_ENTITY.postal_cd (omit hyphen)
(if the code determines the taxable entity is a US state or commonwealth/territory). |
The company's zip code. |
US Zip Code Extension | 4 | 347-350 | The four digits following the hyphen from the TAXBLE_ENTITY.postal_cd (Omit hyphen)
(if the code determines the taxable entity is a US state or commonwealth/territory) |
The submitter's four-digits extension of the zip code. If not applicable, filled with blanks. | |
Blank | 5 | 351-355 | Fill with blanks. Reserved for SSA use. | ||
Foreign State/Province | 23 | 356-378 | TAXBLE_ENTITY.mail_state_doc | If applicable, up to 23 characters for the company's foreign state province, left-justified and filled with blanks. Otherwise, filled with blanks. | |
Foreign Postal Code | 15 | 379-393 | TAXBLE_ENTITY.postal_cd | The company's foreign postal code, left-justified and filled with blanks. Otherwise, filled with blanks. | |
Non-US Country Code | 2 | 394-395 | COUNTRY.mag_media_cd | If one of the following applies, this position is filled with blanks.
|
|
Contact Name | 27 | 396-422 | Y | MAG_MEDIA_RPT.contact_name | The name of the person to be contacted by SSA concerning processing problems, left-justified and filled with blanks. |
Contact Phone Number | 15 | 423-437 | Y | MAG_MEDIA_RPT.phone_no | The contact's telephone number with numeric values only (including area code). Must not include any special characters. |
Contact Phone Extension | 5 | 438-442 | MAG_MEDIA_RPT.ext_no | The contact's telephone extension, left-justified and filled with blanks. | |
Blank | 3 | 443-445 | Filled with blanks. Reserved for SSA use. | ||
Contact E-mail | 40 | 446-485 | Y | MAG_MEDIA_RPT.email | The contact’s E-Mail/Internet address.
This field may be upper and lower case. The rules for entering a valid E-Mail address for SSA’s purposes are as follows:
|
Blank | 3 | 486-488 | Filled with blanks. Reserved for SSA use. | ||
Contact Fax | 10 | 489-498 | MAG_MEDIA_RPT.fax | For US states and territories only, this position contains the contact's fax number, including area code. Otherwise, it is filled with blanks. | |
Blank | 1 | 499 | Filled with blanks. Reserved for SSA use. | ||
Preparer Code | 1 | 500 | MAG_MEDIA_RPT.preparer_cd | One of the following codes to indicate who prepared this file:
Note: If more than one code applies, use the one that best describes the person who prepared the file.
|
|
Blank | 12 | 501-512 | Filled with blanks. Reserved for SSA use. |
RE Record (Employer Record)
Field Name | Length | Column # | Required | Costpoint Source | Notes |
---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Constant: RE | ||
Tax Year | 4 | 3-6 | Y | Screen Payroll Year | The tax year for this report, including numeric characters only. |
Agent Indicator Code | 1 | 7 | If applicable, this position includes one of the following codes.
|
||
Employer/Agent Employer Identification Number (EIN) | 9 | 8-16 | Y | TAXBLE_ENTITY.tax_id |
|
Agent for EIN | 9 | 17-25 | Blank | If you entered a 1 in the Agent Indicator Code field, (position 7) enter the Employer's EIN for which you are an Agent. Otherwise, fill with blanks. | |
Terminating Business Indicator | 1 | 26 | Terminating Business check box. | Enter 1 if you have terminated your business during this tax year. Otherwise, enter 0. | |
Establishment Number | 4 | 27-30 | TAXBLE_ENTITY.mail_state_dc | For multiple RE Records with the same EIN, you may use this field to assign a unique identifier for each RE Record (i.e., store for factory locations or types of payroll). Enter any combination of blanks, numbers or letters. | |
Other EIN | 9 | 31-39 | Other EIN field | For the current tax year, if you submitted tax payments to the IRS under Form 941, 943, 944, CT-1 or Schedule H or W-2 data to SSA, and you used an EIN different from the EIN in positions 8 - 16, enter the other EIN.
Otherwise, fill with blanks. |
|
Employer Name | 57 | 40-96 | Y | TAXBLE_ENTITY.taxble_entity_name | Enter the name associated with the EIN entered in location 8-16.
Left-justify and fill with blanks. |
Location Address | 22 | 97-118 | TAXBLE_ENTITY.In_2_adr (coma)
T |
Enter the employer's location address (Attention, Suite, Room Number, etc.).
Example: 2nd Floor, Suite 234 Left justify and fill with blanks. |
|
Delivery Address | 22 | 296-317 | Y | TAXBLE_ENTITY.ln_1_adr | Enter the submitter's delivery address (state or Post Office box). Left-justify and fill with blanks. |
City | 22 | 141-162 | Y | TAXBLE_ENTITY.city_name | The submitter's city, left-justified and filled with blanks. |
US State Abbreviation | 2 | 163-164 | Y | TAXBLE_ENTITY.mail_state_dc
(if the code determines the taxable entity is a US state, commonwealth, or territory) |
Enter the company's state or commonwealth/territory. For a foreign address, fill with blanks. |
US Zip Code | 5 | 165-169 | Y | The first five digits of TABLE_ENTITY.postal_cd (omit hyphen)
(if the code determines the taxable entity is a US state or commonwealth/territory). |
The company's zip code. |
US Zip Code Extension | 4 | 170-173 | The four digits following the hyphen from the TAXBLE_ENTITY.postal_cd (Omit hyphen)
(if the code determines the taxable entity is a US state or commonwealth/territory) |
The submitter's four-digits extension of the zip code. If not applicable, filled with blanks. | |
Kind of Employer | 1 | 174 | Y | The appropriate kind of employer:
|
|
Blank | 4 | 175-178 | Filled with blanks. Reserved from SSA use. | ||
Foreign State/Province | 23 | 179-201 | TAXBLE_ENTITY.mail_state_doc | If applicable, up to 23 characters for the employer's foreign state province, left-justified and filled with blanks. Otherwise, filled with blanks. | |
Foreign Postal Code | 15 | 202-216 | TAXBLE_ENTITY.postal_cd | If applicable, the employer's foreign postal code, left-justified and filled with blanks. Otherwise, filled with blanks. | |
Non-US Country Code | 2 | 217-218 | COUNTRY.mag_media_cd | If one of the following applies, this position should be filled with blanks.
|
|
Employment Code | 1 | 219 | One of the following employment codes:
|
||
Tax Jurisdiction Code | 1 | 220 | Y | The value in the State field on the Manage W-2s form | A code that identifies the type of income tax withheld from the employee’s earnings.
|
Third-Party Sick Pay Indicator | 1 | 221 | FED_W2_FILE.third_party_sck_fl | Either 1 or 0 depending on the flag in Edit W-2. | |
Employer Contact Name | 27 | 222-248 | Contact Name field on the Manage Tax File Data screen. | The contact telephone number with numeric values only (including area code). Do not use any special characters.
Example: 1232345678 Left justified and filled with blanks. |
|
Employer Contact Phone Number | 15 | 249-263 | Extension field on the Manage Tax File Data screen. | The contact telephone extension with numeric values only. Do not use any special characters.
Example: 12345 Left justified and filled with blanks. |
|
Employer Contact Fax Number | 5 | 264-268 | Fax field on the Manage Tax File Data screen. | The employer’s contact fax number with numeric values only (including area code). Do not use any special characters.
Example: 1232345678 Otherwise, fill with blanks. For U.S. and U.S. territories only. |
|
Employer Contact E-Mail/Internet | 40 | 279-318 | E-mail field on the Manage Tax File Data screen. | Enter the employer’s contact E-Mail/Internet address.
This field may be upper and lower case. The contact’s E-Mail/Internet address. This field may be upper and lower case. The rules for entering a valid E-Mail address for SSA’s purposes are as follows:
|
|
Blank | 194 | 319-512 | Filled with blanks. Reserved for SSA use. |
RW Record (Employer Wage Record)
Field Name | Length | Column # | Required | Costpoint Source | Notes | |
---|---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Y | Constant - RW | ||
Social Security Number (SSN) | 9 | 3-11 | Y | EMPL.ssn_id
(no hyphens) |
The employee's SSN as shown on the original/replacement SSN card issued by SSA.
|
|
Employee First Name | 15 | 12-26 | Y | EMPL.first_name | ||
Employee Middle Name or Initial | 15 | 27-41 | EMPL.mid_name |
|
||
Employee Last Name | 20 | 42-61 | Y | EMPL.last_name | The employee's last name as shown on the social security card, left-justified and filled with blanks. | |
Suffix | 4 | 62-65 | EMPL.name_sfx_cd | If applicable, the employee's alphabetic suffix.
For example: SR, JR Left-justified and filled with blanks. Otherwise, filled with blanks. |
||
Location Address | 22 | 66-87 | EMPL.line_2_adr and
EMPL.line_3_adr |
The employee's location address (Attention, Suite, Room Number, etc.), left-justified and filled with blanks. | ||
Delivery Address | 22 | 88-109 | EMPL.line_1_adr | The employee's delivery address (Street or Post Office box), left-justified and filled with blanks. | ||
City | 22 | 110-131 | EMPL.city_name | |||
U.S. State Abbreviation | 2 | 132-133 | EMPL.mail_state_dc | The employee's alpha state postal abbreviation. For a foreign address, this should be filled with blanks. | ||
U.S. Zip Code | 5 | 134-138 | The first five digits of EMPL.postal_cd | The company's zip code. | ||
Zip Code Extension | 4 | 139-142 | EMPL.postal_cd | The submitter's four-digits extension of the zip code. If not applicable, filled with blanks. | ||
Blank | 5 | 143-147 | Filled with blanks. Reserved for SSA use. | |||
Foreign State/Province | 23 | 148-170 | EMPL.mail_state_dc | If applicable, this position is filled with the employee's foreign state/province, left-justified and filled with blanks. Otherwise, it should be filled with blanks. | ||
Foreign Postal Code | 15 | 171-185 | EMPL.postal_cd | If applicable, this position is filled with the employee's foreign postal code, left-justified and filled with blanks. Otherwise, it should be filled with blanks. | ||
Country Code | 2 | 186-187 | COUNTRY.mag_media_cd (where EMPL.country_cd = COUNTRY.country_cd) | If one of the following applies, this position is filled with blanks.
|
||
Wages, Tips and Other Compensation | 11 | 188-198 | FED_W2_FILE.fed_wages_amt |
|
||
Federal Income Tax Withheld | 11 | 199-209 | FED_W2_FILE.fed_wh_amt |
|
||
Social Security Wages | 11 | 210-220 | FED_W2_FILE.ssn_wages_amt |
|
||
Social Security Tax Withheld | 11 | 221-231 | FED_W2_FILE.ssn_wages_amt |
|
||
Medicare Wages & Tips | 11 | 232-242 | FED_W2_FILE.med_wages_amt |
|
||
Medicare Tax Withheld | 11 | 243-253 | FED_W2_FILE.med_wh_amt |
|
||
Social Security Tips | 11 | 254-264 | FED_W2_FILE.ssn_tips_amt |
|
||
Blank | 11 | 265-275 | Filled with blanks. Reserved for SSA use. | |||
Dependent Care Benefits | 11 | 276-286 | FED_W2_FILE.dep_care_amt |
|
||
Deferred Compensation Contributions to Section 401(k) | 11 | 287-297 | W-2 Box 12:Code D amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = D ) + 12: Code D xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like D %) |
|
||
Deferred Compensation Contributions to Section 403(b) | 298-308 | W-2 Box 12:Code E amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = E ) + 12: Code E xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like E %) |
|
|||
Deferred Compensation Contributions to Section 408(k)(6) | 309-319 | W-2 Box 12:Code F amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = F ) + 12: Code F xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like F %) |
|
|||
Deferred Compensation Contributions to Section 457(b) | 320-330 | W-2 Box 12:Code G amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = G ) + 12: Code G xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like G %) |
|
|||
Deferred Compensation Contributions to Section 501(c)(18)(D) | 11 | 331-341 | W-2 Box 12:Code G amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = H) + 12: Code H xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like H %) |
|
||
Blank | 11 | 342-352 | Filled with blanks. Reserved for SSA use. | |||
Non-qualified Plan Section 457 Distributions or Contributions | 11 | 353-363 | Zeroes |
|
||
Employer Contributions to a Health Savings Account | 11 | 364-374 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = W) |
|
||
Non-qualified Plan Not Section 457 Distributions or Contributions | 11 | 375-385 | FED_W2_FILE.nonqual_plan_amt |
|
||
Nontaxable Combat Pay | 11 | 386-396 | BOX_12_W2_FILE.box_12_amt
(where box_12_cd = Q) |
|
||
Blank | 22 | 397-407 | Filled with blanks. Reserved for SSA use. | |||
Employer Cost of Premiums for Group Term Life Insurance Over $50,000 | 11 | 408-418 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = C) |
|
||
Income from the Exercise of Nonstatutory Stock Options | 11 | 419-429 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = V) |
|
||
Deferrals Under a Section 409A Non-qualified Deferred Compensation Plan | 11 | 430-440 | W-2 Box 12:Code Y amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = Y) + 12: Code Y xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like Y %) |
|
||
Designated Roth Contributions to a Section 401(k) Plan | 441-451 | W-2 Box 12:Code AA amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd = AA) + 12: Code AA xx amount (BOX_12_W2_FILE.box_12_amt where BOX_12_W2_FILE.box_12_cd like AA %) |
|
|||
Designated Roth Contributions under a Section 403(b) Salary Reduction Agreement | 11 | 452-462 |
|
|||
Cost of Employer-Sponsored Health Coverage | 11 | 463-473 | BOX_12_W2_FILE Database Column: BOX_12_AMT (where BOX_12_CD = DD) |
|
||
Blank | 474-485 | Filled with blanks. Reserved for SSA use. | ||||
Statutory Employee Indicator | 1 | 486 | FED_W2_FILE.state_empl_fl |
|
||
Blank | 1 | 487 | Filled with blanks. Reserved for SSA use. | |||
Retirement Plan Indicator | 1 | 488 | FED_W2_FILE.pens_plan_fl |
|
||
Third-Party Sick Pay Indicator | 1 | 489 | FED_W2_FILE_third_party_sck_fl |
|
||
Blank | 23 | 490-512 | Filled with blanks. Reserved for SSA use. |
RO Record (Employee Wage Record)
This record should only be included if at least one of the amount fields is greater than zero.
Field Name | Length | Column # | Required | Costpoint Source | Notes |
---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Constant: RO | ||
Blank | 9 | 3-11 | Filled with blanks. Reserved for SSA use. | ||
Allocated Tips | 11 | 12-22 | FED_W2_FILE.alloc_tips_amt |
|
|
Uncollected Employee Tax on Tips | 11 | 23-33 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = A) plus BOX_12_W2_FILE.box_12_amt (Where box_12_cd = B) |
|
|
Medical Savings Account | 11 | 34-44 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = R) |
|
|
Simple Retirement Account | 11 | 45-55 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = S) |
|
|
Qualified Adoption Expenses | 11 | 56-66 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = T) |
|
|
Uncollected Social Security or RRTA Tax on Cost of Group Term Life Insurance over $50,000 | 11 | 67-77 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = M) |
|
|
Uncollected Medicare Tax on Cost of Group Term Life Insurance Over $50,000 | 11 | 78-88 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = N) |
|
|
Income Under a Nonqualified Deferred Compensation Plan That Fails to Satisfy Section 409A | 11 | 89-99 | BOX_12_W2_FILE.box_12_amt
(Where box_12_cd = Z) |
|
|
Blank | 11 | 100-110 | Filled with blanks. Reserved for SSA use. | ||
Designated Roth Contributions Under a Governmental Section 457(b) Plan | 11 | 111-121 |
|
||
Blank | 153 | 122-274 | Filled with blanks. Reserved for SSA use. | ||
Wages Subject to Puerto Rico Tax | 11 | 275-285 | STATE_W2_FILE.state_wages_amt
where (STATE_W2_FILE.state_cd = PR) |
|
|
Commissions Subject to Puerto Rico Tax | 11 | 286-296 | State wages, tips, etc. (Box 16)
This field should be zero-filled. |
|
|
Allowances Subject to Puerto Rico Tax | 11 | 297-307 | State wages, tips, etc. (Box 16)
This field should be zero-filled. |
|
|
Tips Subject to Puerto Rico Tax | 11 | 308-318 | State wages, tips, etc. (Box 16)
This field should be zero-filled. |
|
|
Total Wages, Commissions, Tips, and Allowances Subject to Puerto Rico Tax | 11 | 319-329 | STATE_W2_FILE.state_wages_amt
where (STATE_W2_FILE.state_cd = PR) |
|
|
Puerto Rico Tax Withheld | 11 | 330-340 | STATE_W2_FILE.state_wages_amt
where (STATE_W2_FILE.state_cd = PR) |
|
|
Retirement Fund Annual Contributions | 11 | 341-351 | BOX_12_W2_FILE.box_12_amt for Puerto Rico employees
(Sum amounts where box_12_cd = D,D xx, E, E xx, F, F xx, G, G xx, H, H xx, S, S xx and there is a record in the employee's STATE_W2_FILE where the STATE_CD =PR) (where xx is a two-digit numeric value representing the year for which catch-up contributions were made) |
|
|
Blank | 11 | 352-362 | Filled. Reserved for SSA use. | ||
Total Wages, Tips and Other Compensation Subject to Virgin Islands, or Guam, or American Samoa, or Northern Mariana Islands Income Tax | 11 | 363-373 | |||
Virgin Islands, or Guam or American Samoa, or Northern Mariana Islands Income Tax Withheld | 11 | 374-384 | STATE_W2_FILE.state_wh_amt
(Where state_cd = VI, AS, GU or MP) |
|
|
Blank | 128 | 385-512 | Filled with blanks. Reserved for SSA use. |
RT Record (Total Record)
Field Name | Length | Column # | Required | Costpoint Source | Notes |
---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Constant: RT | ||
Number of RW Records | 7 | 3-9 | Total number of RW records in the file |
|
|
Wages, Tips and Other Compensation | 15 | 10-24 | Total of all amounts in columns 188-198 from all RW records. |
|
|
Wages, Tips and Other Compensation | 15 | 25-39 | Total of all amounts in columns 199-209 from all RW records. |
|
|
Social Security Wages | 15 | 40-54 | Total of all amounts in columns 210-220 from all RW records |
|
|
Social Security Tax Withheld | 15 | 55-69 | Total of all amounts in columns 221-231 from all RW records |
|
|
Medicare Wages & Tips | 15 | 70-84 | Total of all amounts in columns 232-242 from all RW records |
|
|
85-99 | 15 | 85-99 | Total of all amounts in columns 243-253 from all RW records |
|
|
Social Security Tips | 15 | 100-114 | Total of all amounts in columns 254-264 from all RW records |
|
|
Blank | 15 | 115-129 | Filled with blanks. Reserved for SSA use. | ||
Dependent Care Benefits | 15 | 130-144 | Total of all amounts in columns 276-286 from all RW records |
|
|
Deferred Compensation Contributions to Section 401(k) | 15 | 145-159 | Total of all amounts in columns 287-298 from all RW records |
|
|
Deferred Compensation Contributions to Section 403(b) | 15 | 160-174 | Total of all amounts in columns 299-308 from all RW records |
|
|
Deferred Compensation Contributions to Section 408(k)(6) | 15 | 175-189 | Total of all amounts in columns 309-319 from all RW records |
|
|
15 | 190-204 | Total of all amounts in columns 320-330 from all RW records |
|
||
15 | 205-219 | Total of all amounts in columns 331-341 from all RW records |
|
||
Blank | 15 | 220-234 | Filled with blanks. Reserved for SSA use. | ||
Non-qualified Plan Section 457 Distributions or Contributions | 15 | 235-249 | Total of all amounts in columns 353-363 from all RW records |
|
|
Employer Contributions to a Health Savings Account | 15 | 250-264 | Total of all amounts in columns 364-374 from all RW records |
|
|
Non-qualified Plan Not Section 457 Distributions or Contributions | 15 | 265-279 | Total of all amounts in columns 375-385 from all RW records |
|
|
Nontaxable Combat Pay | 15 | 280-294 | Total of all amounts in columns 386-396 from all RW records |
|
|
Nontaxable Combat Pay | 15 | 295-309 | Total of all amounts in columns 463-473 from all RW records |
|
|
Employer Cost of Premiums for Group Term Life Insurance Over $50,000 | 15 | 310-324 | Total of all amounts in columns 408-418 from all RW records |
|
|
Income Tax Withheld by Third-Party Payer | 15 | 325-339 | Zeroes |
|
|
Income from the Exercise of Nonstatutory Stock Options | 15 | 340-354 | Total of all amounts in columns 419-429 from all RW records |
|
|
Deferrals Under a Section 409A Non-qualified Deferred Compensation Plan | 15 | 355-369 | Total of all amounts in columns 430-440 from all RW records |
|
|
Designated Roth Contributions to a Section 401(k) Plan | 15 | 370-384 | Total of all amounts in columns 441-451 from all RW records |
|
|
Designated Roth Contributions under a Section 403(b) Salary Reduction Agreement | 15 | 385-399 | Total of all amounts in columns 452-462 from all RW records |
|
|
Blank | 158 | 359-512 | Filled with blanks. Reserved for SSA use. |
RU Record (Total Record)
Field Name | Length | Column # | Required | Costpoint Source | Notes |
---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Constant: RU | ||
Number of RO Records | 7 | 3-9 | Total number of RO records in the file. |
|
|
Allocated Tips | 15 | 10-24 | Total of all amounts in columns 12-22 from all RO records. |
|
|
Uncollected Employee Tax on Tips | 15 | 25-39 | Total of all amounts in columns 23-33 from all RO records. |
|
|
Medical Savings Account | 15 | 40-54 | Total of all amounts in columns 34--44 from all RO records. |
|
|
Simple Retirement Account | 15 | 55-69 | Total of all amounts in columns 45-55 from all RO records. |
|
|
Qualified Adoption Expenses | 15 | 70-84 |
|
||
Uncollected Social Security or RRTA Tax on Cost of Group Term Life Insurance Over $50,000 | 15 | 85-99 |
|
||
Uncollected Medicare Tax on Cost of Group Term Life Insurance Over $50,000 | 15 | 100-114 | Total of all amounts in columns 78-88 from all RO records. |
|
|
Income Under Section 409A on a Non-qualified Deferred Compensation Plan | 15 | 115-129 | Total of all amounts in columns 89-99 from all RO records. |
|
|
Blank | 15 | 130-144 | Filled with blanks. Reserved for SSA use. | ||
Designated Roth Contributions Under a Governmental Section 457(b) Plan | 15 | 145-159 | Total of all amounts in columns 111-121 from all RO records in the file |
|
|
Blank | 15 | 160-354 | Filled with blanks. Reserved for SSA use. | ||
Wages Subject to Puerto Rico Tax | 15 | 355-369 | Total of all amounts in columns 275-285 from all RO records. |
|
|
Wages Subject to Puerto Rico Tax | 15 | 370-384 | Total of locations 286-296 from all RO records in the file. |
|
|
Allowance Subject to Puerto Rico Tax | 15 | 385-399 | Total of locations 297-307 from all RO records in the file. |
|
|
Tips Subject to Puerto Rico Tax | 15 | 400-414 | Total of locations 308-318 from all RO records in the file |
|
|
Total Wages, Commissions, Tips, and Allowances Subject to Puerto Rico Tax | 15 | 415-429 | Total of all amounts in columns 319-329 from all RO records. |
|
|
Puerto Rico Tax Withheld | 15 | 430-444 | Total of all amounts in columns 330-340 from all RO records. |
|
|
Retirement Fund Annual Contributions | 15 | 445-459 | Total of all amounts in locations 341-351 from all RO records. |
|
|
Total Wages, Tips and Other Compensation Subject to Virgin Islands, or Guam, or American Samoa, or Northern Mariana Islands Income Tax | 15 | 460-474 | Total of all amounts in columns 363-373 from all RO records. |
|
|
Virgin Islands, or Guam or American Samoa, or Northern Mariana Islands Income Tax Withheld | 15 | 475-489 | Total of all amounts in columns 374-384 from all RO records. |
|
|
Blank | 23 | 490-512 | Filled with blanks. Reserved for SSA use. |
RF Record (Final Record)
Field Name | Length | Column # | Required | Costpoint Source | Notes |
---|---|---|---|---|---|
Record Identifier | 2 | 1-2 | Constant: RF | ||
Blank | 5 | 3-7 | Filled with blanks. Reserved for SSA use. | ||
Number of RW Records | 9 | 8-16 | Total number of RW records in the file. | The total number of Code RW records reported on the entire file.
Right-justified and zero filled. |
|
Blank | 496 | 17-512 | Filled with blanks. Reserved for SSA use. |