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|IDGR#RegistrationsTab] 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|