The EFW2 Format for 2013 Annual and 2013-2014 Quarterly Reporting

Record Name: Code RA – Submitter Record#

ColumnDescriptionSource
1-2Record IdentifierConstant "RA"
3-11Submitter’s Employer ID number (EIN)
Numeric only
Derived from IDFDV, Field Identifier: ‘SUB-ER-EIN’
12-19User Identification (User ID)Derived from IDFDV, Field Identifier: ‘SUB-USER-ID’
20-23Software Vendor CodeDerived 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-28Blank
29Resub IndicatorDerived from IDFDV, Field Identifier: ‘SUB-RESUB-IND’
30-35Resub WFIDDerived from IDFDV, Field Identifier: ‘SUB-RESUB-WFID’
36-37Software CodeDerived from IDFDV, Field Identifier: ‘SUB-SOFTWARE’
38-94Company NameDerived from IDFDV, Field Identifier: ‘SUB-COMP-NAME’
95-116Location AddressDerived from IDFDV, Field Identifier: ‘SUB-COMP-LOCN’
117-138Delivery AddressDerived from IDFDV, Field Identifier: ‘SUB-COMP-DELIV’
139-160Company CityDerived from IDFDV, Field Identifier: ‘SUB-COMP-CITY’
161-162Company State AbbreviationDerived from IDFDV, Field Identifier: ‘SUB-COMP-STATE’
163-167Company ZIP CodeDerived from IDFDV, Field Identifier: ‘SUB-COMP-ZIP’
168-171Company ZIP Code extensionDerived from IDFDV, Field Identifier: ‘SUB-COMP-ZIP-EXT’
172-176Blank
177-199Company Foreign State/ProvinceDerived from IDFDV, Field Identifier: ‘SUB-COMP-F-STATE’
200-214Company Foreign Postal CodeDerived from IDFDV, Field Identifier: ‘SUB-COMP-F-POST’
215-216Company Country CodeDerived from IDFDV, Field Identifier: ‘SUB-COMP-COUNTRY’
217-273Submitter NameDerived from IDFDV, Field Identifier: ‘SUB-SUBM-NAME’
274-295Submitter Location AddressDerived from IDFDV, Field Identifier: ‘SUB-SUBM-LOCN’
296-317Submitter Delivery AddressDerived from IDFDV, Field Identifier: ‘SUB-SUBM-DELIV’
318-339Submitter CityDerived from IDFDV, Field Identifier: ‘SUB-SUBM-CITY’
340-341Submitter State AbbreviationDerived from IDFDV, Field Identifier: ‘SUB-SUBM-STATE’
342-346Submitter ZIP codeDerived from IDFDV, Field Identifier: ‘SUB-SUBM-ZIP’
347-350Submitter ZIP code extensionDerived from IDFDV, Field Identifier: ‘SUB-SUBM-ZIP-EXT’
351-355Blank
356-378Submitter Foreign State/ProvinceDerived from IDFDV, Field Identifier: ‘SUB-SUBM-F-STATE’
379-393Submitter Foreign Postal CodeDerived from IDFDV, Field Identifier: ‘SUB-SUBM-F-POST’
394-395Submitter Country CodeDerived from IDFDV, Field Identifier: ‘SUB-SUBM-COUNTRY’
396-422Contact NameDerived from IDFDV, Field Identifier: ‘SUB-CONT-NAME’
423-437Contact Phone NumberDerived from IDFDV, Field Identifier: ‘SUB-CONT-TEL’
438-442Contact Phone ExtensionDerived from IDFDV, Field Identifier: ‘SUB-CONT-TEL-EXT’
443-445Blank
446-485Contact E-mailDerived from IDFDV, Field Identifier: ‘SUB-CONT-EMAIL’

This is a required field.

486-488Blank
489-498Contact FAXDerived from IDFDV, Field Identifier: ‘SUB-CONT-FAX’
499-499Preferred Method of Problem Notification CodeDerived from IDFDV, Field Identifier: ‘SUB-CONT-METH’

This field is not used since 2012, leave the IDFDV value blank.

500-500Preparer CodeDerived from IDFDV, Field Identifier: ‘SUB-PREPARER’
501-512Blank