This page (revision-14) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by kparrott

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
14 26-Nov-2021 10:22 6 KB Meg McFarland to previous
13 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
12 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
11 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
10 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
9 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
8 26-Nov-2021 10:22 6 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 3 KB kparrott to previous | to last
6 26-Nov-2021 10:22 3 KB kparrott to previous | to last
5 26-Nov-2021 10:22 3 KB kparrott to previous | to last
4 26-Nov-2021 10:22 3 KB kparrott to previous | to last
3 26-Nov-2021 10:22 3 KB kparrott to previous | to last
2 26-Nov-2021 10:22 3 KB kparrott to previous | to last
1 26-Nov-2021 10:22 3 KB kparrott to last

Page References

Incoming links Outgoing links
W 2_EFW 2_RECORD_RA...nobody
W2_EFW2_RECORD_RA

Version management

Difference between version and

At line 1 changed one line
The EFW2 Format (Record RA) for 2016 Annual and 2016-2017 Quarterly Reporting
!State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting
At line 3 changed one line
||Column ||Description||Source
!!Record Name: Code RA - Submitter Record
||Column||Description||Source
At line 5 changed 39 lines
|3-11|Submitter’s Employer ID number (EIN)\\Numeric only|Derived from [IDFDV], Field Identifier: ‘SUB-ER-EIN’
|12-19|User Identification (User ID)|Derived from [IDFDV], Field Identifier: ‘SUB-USER-ID’
|20-23|Software Vendor Code|Derived from [IDFDV], Seq# 1035 Field Identifier: ‘SUB-VENDOR’\\ \\This optional Vendor Code will not be provided, if the users do not have a Vendor Code, leave this blank
|24-28|Blank|
|29|Resub Indicator|Derived from [IDFDV], Field Identifier: ‘SUB-RESUB-IND’
|30-35|Resub WFID|Derived from [IDFDV], Field Identifier: ‘SUB-RESUB-WFID’
|36-37|Software Code|Derived from [IDFDV], Field Identifier: ‘SUB-SOFTWARE’
|38-94|Company Name|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-NAME’
|95-116|Location Address|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-LOCN’
|117-138|Delivery Address|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-DELIV’
|139-160|Company City|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-CITY’
|161-162|Company State Abbreviation|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-STATE’
|163-167|Company ZIP Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-ZIP’
|168-171|Company ZIP Code extension|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-ZIP-EXT’
|172-176|Blank|
|177-199|Company Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-STATE’
|200-214|Company Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-POST’
|215-216|Company Country Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-COUNTRY’
|217-273|Submitter Name|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-NAME’
|274-295|Submitter Location Address|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-LOCN’
|296-317|Submitter Delivery Address|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-DELIV’
|318-339|Submitter City|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-CITY’
|340-341|Submitter State Abbreviation|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-STATE’
|342-346|Submitter ZIP code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP’
|347-350|Submitter ZIP code extension|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP-EXT’
|351-355|Blank|
|356-378|Submitter Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-STATE’
|379-393|Submitter Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-POST’
|394-395|Submitter Country Code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-COUNTRY’
|396-422|Contact Name|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-NAME’
|423-437|Contact Phone Number|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL’
|438-442|Contact Phone Extension|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL-EXT’
|443-445|Blank|
|446-485|Contact E-mail|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-EMAIL’\\ \\This is a required field
|486-488|Blank|
|489-498|Contact FAX|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-FAX’
|499-499|Preferred Method of Problem Notification Code|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-METH’\\ \\This field is not used since 2012, leave the [IDFDV] value blank.
|500-500|Preparer Code|Derived from [IDFDV], Field Identifier: ‘SUB-PREPARER’
|501-512|Blank|
|3-11|Submitter’s Employer ID Number (EIN)|Required. \\Derived from the ‘SUB-ER-EIN’ [IDFDV] Field Identifier (seq 1000). \\Numeric only.
|12-19|User Identification (User ID)|Required.\\Enter the eight-character BSO User ID assigned to the employee who is attesting to the accuracy of this file.
|20-23|Software Vendor Code|Enter the numeric four-digit Software Vendor Identification Code assigned by the National Association of Computerized Tax Processors (NACTP). \\ \\If "99 (Off-the-Shelf Software)" is entered in the Software Code field (positions 36-37) enter the Software Vendor Code. \\ Otherwise, fill with blanks.
|24-28|Blank|Fill with blanks. Reserved for SSA use.
|29|Resub Indicator|Enter "1" if this file is being resubmitted. Otherwise, enter "0" (zero).
|30-35|Resub Wage File Identifier (WFID)|If "1" was entered in Resub Indicator field (position 29), enter the WFID displayed on the notice SSA sent. Otherwise, fill with blanks.
|36-37|Software Code|Enter "99" to indicate 'Off-the-Shelf Software'
|38-94|Company Name|Enter the Company Name. \\Left justify and fill with blanks.
|95-116|Location Address|Enter the company's location address (Attention, Suite, Room Number, etc). \\Left justify and fill with blanks
|117-138|Delivery Address|Enter the company's delivery address (Street or Post Office Box).\\Example: 123 Main Street. \\Left justify and fill with blanks
|139-160|City|Enter the company's city. \\ Left justify and fill with blanks
|161-162|State Abbreviation|Enter the company's State or commonwealth/territory. \\Use a postal abbreviation. For a foreign address, fill with blanks
|163-167|ZIP Code|Enter the company's ZIP code. For a foreign address, fill with blanks
|168-171|ZIP Code Extension|Enter the company's four-digit extension of the ZIP code. If not applicable, fill with blanks
|172-176|Blank|Fill with blanks. Reserved for SSA use.
|177-199|Foreign State/Province|If applicable, enter the company's foreign State/Province. \\ Left justify and fill with blanks. Otherwise, fill with blanks.
|200-214|Foreign Postal Code|If applicable, enter the company's foreign postal code. \\ Left justify and fill with blanks. Otherwise, fill with blanks.
|215-216|Country Code|If one of the following applies, fill with blanks: \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code.
|217-273|Submitter Name|Required. \\ Enter the name of the organization's submitter to receive error notification if this file cannot be processed. \\ Left Justify and fill with blanks. \\ Derived from the ‘SUB-SUBM-NAME’ [IDFDV] Field Identifier (seq 1150).
|274-295|Submitter Location Address|Enter the submitter's location address (Attention, Suite, Room Number, etc.) \\Left justify and fill with blanks. \\Derived from the ‘SUB-SUBM-LOCN’ [IDFDV] Field Identifier (seq 1160).
|296-317|Submitter Delivery Address|Required. \\ Enter the submitter's delivery address (Street or Post Office Box). \\Left justify and fill with blanks. \\Derived from the ‘SUB-SUBM-DELIV’ [IDFDV] Field Identifier (seq 1170).
|318-339|Submitter City|Required. \\ Enter the submitter's city. \\Left justify and fill with blanks. \\Derived from the ‘SUB-SUBM-CITY’ [IDFDV] Field Identifier (seq 1180).
|340-341|Submitter State Abbreviation|Required. \\ Enter the submitter's State or commonwealth/territory. Use a postal abbreviation. \\For a foreign address, fill with blanks. \\ Derived from the ‘SUB-SUBM-STATE’ [IDFDV] Field Identifier (seq 1190).
|342-346|Submitter ZIP Code|Required. \\ Enter the submitter's ZIP Code. \\For a foreign address, fill with blanks. \\Derived from the ‘SUB-SUBM-ZIP’ [IDFDV] Field Identifier (seq 1200).
|347-350|Submitter ZIP Code extension|Enter the submitter's four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from the ‘SUB-SUBM-ZIP-EXT’ [IDFDV] Field Identifier (seq 1210).
|351-355|Blank|Fill with blanks. Reserved for SSA use
__IMPORTANT NOTE:__ If using a foreign address, the foreign State/Province (postions 356-378), Foreign Postal Code (positions 379-393) and the Contry Code (positions 394-395) are required to be completed.
|356-378|Foreign State/Province|If applicable, enter the submitter's foreign State/Province. \\ Left justify and fill with blanks. Otherwise, fill with blanks.
|379-393|Foreign Postal Code|If applicable, enter the submitter's foreign Postal Code. \\ Left justify and fill with blanks. Otherwise, fill with blanks.
|394-395|Country Code|If one of the following applies, fill with blanks \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code.
|396-422|Contact Name|Required. \\ Enter the name of the person to be contacted by SSA concerning processing problems. \\Left justify and fill with blanks. \\Derived from the ‘SUB-CONT-NAME’ [IDFDV] Field Identifier (seq 1250).
|423-437|Contact Phone Number|Required. \\ Enter the contact's phone number with numeric valies only (including area code). Do not use any special characters. \\Left justify and fill with blanks. \\ \\__NOTE: It is imperative that the contact's telephone number be entered in the appropriate positions. Failure to include correct and complete submitter contact information may, in some cases, delay the timely processing of your file.__ \\ \\Derived from the ‘SUB-CONT-TEL’ [IDFDV] Field Identifier (seq 1260).
|438-442|Contact Phone Extension|Enter the contact's telephone extension. \\Left justify and fill with blanks.\\ Derived from the ‘SUB-CONT-TEL-EXT’ [IDFDV] Field Identifier (seq 1270).
|443-445|Blank|Fill with blanks. Reserved for SSA use.
|446-485|Contact E-mail/Internet|Enter the contact's e-mail/internet address. \\Derived from the ‘SUB-CONT-EMAIL’ [IDFDV] Field Identifier (seq 1280).
|486-488|Blank|Fill with blanks. Reserved for SSA use.
|489-498|Contact Fax|If applicable, enter the contact's fax number (including area code). Otherwise, fill with blanks. \\Derived from the ‘SUB-CONT-FAX’ [IDFDV] Field Identifier (seq 1290).
|499|Blank|Fill with blanks. Reserved for SSA use.
|500|Preparer Code|Enter one of the following codes to indicate who prepared this file: \\* A = Accounting Firm \\* L = Self Prepared \\* S = Service Bureau \\* P = Parent Company \\* O = Other\\ \\If more than one code applies, use the code that best describes who prepared this file.
|501-512|Blank|Fill with blanks. Reserved for SSA use.
This page (revision-14) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop