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 |
