Wiki: W 2_EFW 2_RECORD

The EFW2 Format (Record RE) for 2013 Annual and 2013-2014 Quarterly Reporting

Column	Description	Source
1-2	Record Identifier	Constant "RE"
3-6	Tax year CCYY	From user specified FROM-TO period converted to CCYY
7	Agent Indicator Code	Derived from IDFDV, Field Identifier: ‘W2-ER-AGENT-IND’
8-16	Employer/Agent EIN	System derived the applicable Federal reporting EIN, from IDGV or IDGR If on RPYEU selection screen the ‘Combined Fed Regist#’ toggle is ‘checked’, then this Employer/Agent EIN is retrieved from IDFDV, Field Identifier: ‘W2-ER-EIN’, otherwise the EIN is derived for every Code RE record
17-25	Agent for EIN	Derived from IDFDV, Field Identifier: ‘W2-ER-FOR-EIN’
26	Terminating Business Indicator	Derived from IDFDV, Field Identifier: ‘W2-ER-TERM-BUS’
27-30	Establishment Number	Derived from IDFDV, Field Identifier: ‘W2-ER-ESTAB’
31-39	Other EIN	Derived from IDFDV, Field Identifier: ‘W2-ER-OTHER-EIN’
40-96	Employer Name	Derived from IDFDV, Field Identifier: ‘W2-ER-NAME’
97-118	Employer Location Address	Derived from IDFDV, Field Identifier: ‘W2-ER-LOCN-ADDR’
119-140	Employer Delivery Address	Derived from IDFDV, Field Identifier: ‘W2-ER-DELIV-ADDR’
141-162	Employer City	Derived from IDFDV, Field Identifier: ‘W2-ER-CITY’
163-164	Employer State Abbreviation	Derived from IDFDV, Field Identifier: ‘W2-ER-STATE’
165-169	Employer ZIP Code	Derived from IDFDV, Field Identifier: ‘W2-ER-ZIP’
170-173	Employer ZIP Code Extension	Derived from IDFDV, Field Identifier: ‘W2-ER-ZIP-EXT’
174-174	Kind of Employer	Derived from IDFDV, Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)
175-178	Blank
179-201	Employer Foreign State/Province	Derived from IDFDV, Field Identifier: ‘W2-ER-F-STATE’
202-216	Employer Foreign Postal Code	Derived from IDFDV, Field Identifier: ‘W2-ER-F-POSTAL’
217-218	Employer Country Code	Derived from IDFDV, Field Identifier: ‘W2-ER-COUNTRY’ If Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this field is blank. Otherwise, this is a Foreign Country Code and the Field Identifier: ‘W2-ER-COUNTRY’ is already retrieved from IDCO UDF ‘ISO COUNTRY CODE’ with the two character ISO Country Code. Note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank. If Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed If Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed If Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Country Code is printed.
219	Employment Code	From IDGR ‘W2 Employment Type’ or IPRLU FICA and Medicare method If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting Otherwise, the W2 Type of employment is derived from IDGR Registration tab ‘W2 Emp Type’. A set of code RE, RW/RO/RS, RT/RU records will be generated for different types of employment.
220	Tax Jurisdiction Code	Derived from IDFDV, Field Identifier: ‘W2-ER-TAX-JURIS’
221	Third-Party Sick Pay Indicator	Derived from IDFDV, Field Identifier: ‘SUB-3RD-PARTY-SICK’
222-248	Employer Contact Name	Derived from IDFDV, Field Identifier: ‘W2-ER-CTAC-NAME’
249-263	Employer Contact Phone	Derived from IDFDV, Field Identifier: ‘W2-ER-CTAC-PHONE’
264-268	Employer Contact Extension	Derived from IDFDV, Field Identifier: ‘W2-ER-CTAC-EXT’
269-278	Employer Contact FAX	Derived from IDFDV, Field Identifier: ‘W2-ER-CTAC-FAX’
279-318	Employer Contact EMAIL	Derived from IDFDV, Field Identifier: ‘W2-ER-CTAC-EMAIL’
319-512	Blank