This page (revision-18) was last changed on 26-Nov-2021 10:22 by kparrott

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

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
18 26-Nov-2021 10:22 7 KB kparrott to previous
17 26-Nov-2021 10:22 7 KB kparrott to previous | to last
16 26-Nov-2021 10:22 8 KB kparrott to previous | to last
15 26-Nov-2021 10:22 8 KB kparrott to previous | to last
14 26-Nov-2021 10:22 13 KB eyeung to previous | to last
13 26-Nov-2021 10:22 13 KB eyeung to previous | to last
12 26-Nov-2021 10:22 12 KB rforbes to previous | to last
11 26-Nov-2021 10:22 12 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
10 26-Nov-2021 10:22 12 KB jmyers to previous | to last
9 26-Nov-2021 10:22 12 KB jmyers to previous | to last
8 26-Nov-2021 10:22 12 KB jmyers to previous | to last
7 26-Nov-2021 10:22 13 KB jmyers to previous | to last
6 26-Nov-2021 10:22 14 KB jmyers to previous | to last
5 26-Nov-2021 10:22 14 KB jmyers to previous | to last
4 26-Nov-2021 10:22 14 KB jmyers to previous | to last
3 26-Nov-2021 10:22 14 KB jmyers to previous | to last
2 26-Nov-2021 10:22 13 KB jmyers to previous | to last
1 26-Nov-2021 10:22 13 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 20 added 6 lines
*Annual Form Code’ – use the standard supplied form code HL$US-W2-2012. You will have to enter The ‘Variables’ needs to be entered into this Form Code for specific use in the installation.
*The ‘Quarterly Form Code’ must be left blank in order to produce UI wage file in EFW2format
*Period Type: Quarter.
*Period End Date: Enter the quarter end date, i.e. 30-Jun-2011.
*Media File Type: State SUI File Format.
*If the Directory Name/Media File Name is not supplied, an output file will not be produced.
At line 27 added 3 lines
!!State UI Wage Magnetic Media Reporting - EFW2 File Format
%%information Please note that the following ‘Not Required’ fields may or may not always contain blanks.%%
%%information Note: Columns with NH indicates it is a New Hampshire specific requirement which is not the standard record format.%%
At line 22 changed 6 lines
- Annual Form Code’ – use the standard HighLine supplied form code HL$US-W2-2012. You will have to enter the ‘Variables’ in this Form Code for use specifically in your installation.
- The ‘Quarterly Form Code’ must be left blank in order to produce UI wage file in EFW2format
- Period Type: Quarter.
- Period End Date: Enter the quarter end date, i.e. 30-Jun-2011.
- Media File Type: State SUI File Format.
- If the Directory Name/Media File Name is not supplied, an output file will not be produced.
!Record Name: Code RA - Transmitter Record (same as Federal code RA)
||Column||Description||Source
At line 29 removed 15 lines
STATE UI Wage MAGNETIC MEDIA REPORTING – EFW2 File Format
(Please note that the following ‘Not Required’ fields may or may not always contain BLANKS).
Note: Columns with NH indicates it is a New Hampshire specific requirement which is not the standard record format
Record name: Code RA - Transmitter Record (same as Federal code RA)
Column Description
At line 48 changed 2 lines
- Numeric only
- Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’
- Numeric only|Derived from [IDFDV] Field Identifier: ‘SUB-ER-EIN’
At line 51 changed 2 lines
12-28 - Personal Identification Number (PIN) and Software Vendor Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-PIN-NUMBER’ (seq 1010)
12-28 - Personal Identification Number (PIN) and Software Vendor Code|Derived from [IDFDV] Field Identifier: ‘SUB-PIN-NUMBER’ (seq 1010)
At line 56 changed 2 lines
29 - Resub Indicator
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-IND’
29 - Resub Indicator|Derived from [IDFDV] Field Identifier: ‘SUB-RESUB-IND’
At line 59 changed 2 lines
30-35 - Resub WFID
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-WFID’
30-35 - Resub WFID|Derived from [IDFDV] Field Identifier: ‘SUB-RESUB-WFID’
At line 62 changed 2 lines
36-37 - Software Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SOFTWARE’
36-37 - Software Code|Derived from [IDFDV] Field Identifier: ‘SUB-SOFTWARE’
At line 65 changed 2 lines
38-94 - Company Name
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-NAME’
38-94 - Company Name|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-NAME’
At line 68 changed 2 lines
95-116 - Location Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-LOCN’
95-116 - Location Address|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-LOCN’
At line 71 changed 2 lines
117-138 - Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-DELIV’
117-138 - Delivery Address|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-DELIV’
At line 74 changed 2 lines
139-160 - Company City
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-CITY’
139-160 - Company City|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-CITY’
At line 77 changed 2 lines
161-162 - Company State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-STATE’
161-162 - Company State Abbreviation|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-STATE’
At line 80 changed 2 lines
163-167 - Company ZIP code
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP’
163-167 - Company ZIP Code|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-ZIP’
At line 83 changed 2 lines
168-171 - Company ZIP code extension
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP-EXT’
168-171 - Company ZIP code extension|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-ZIP-EXT’
At line 88 changed 2 lines
177-199 - Company Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-STATE’
177-199 - Company Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-F-STATE’
At line 91 changed 2 lines
200-214 - Company Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-POST’
200-214 - Company Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-F-POST’
At line 94 changed 2 lines
215-216 - Company Country Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-COUNTRY’
215-216 - Company Country Code|Derived from [IDFDV] Field Identifier: ‘SUB-COMP-COUNTRY’
At line 97 changed 2 lines
217-273 - Submitter Name
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-NAME’
217-273 - Submitter Name|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-NAME’
At line 100 changed 2 lines
274-295 - Submitter Location Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-LOCN’
274-295 - Submitter Location Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-LOCN’
At line 103 changed 2 lines
296-317 - Submitter Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-DELIV’
296-317 - Submitter Delivery Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-DELIV’
At line 106 changed 2 lines
318-339 - Submitter City
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-CITY’
318-339 - Submitter City|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-CITY’
At line 109 changed 2 lines
340-341 - Submitter State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-STATE’
340-341 - Submitter State Abbreviation|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-STATE’
At line 112 changed 2 lines
342-346 - Submitter ZIP code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP’
342-346 - Submitter ZIP Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP’
At line 115 changed 2 lines
347-350 - Submitter ZIP code extension
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP-EXT’
347-350 - Submitter ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP-EXT’
At line 120 changed 2 lines
356-378 - Submitter Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-STATE’
356-378 - Submitter Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-F-STATE’
At line 123 changed 2 lines
379-393 - Submitter Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-POST’
379-393 - Submitter Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-F-POST’
At line 126 changed 2 lines
394-395 - Submitter Country Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-COUNTRY’
394-395 - Submitter Country Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-COUNTRY’
At line 129 changed 2 lines
396-422 - Contact Name
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-NAME’
396-422 - Contact Name|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-NAME’
At line 132 changed 2 lines
423-437 - Contact Phone Number
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL’
423-437 - Contact Phone Number|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL’
At line 135 changed 2 lines
438-442 - Contact Phone Extension
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL-EXT’
438-442 - Contact Phone Extension|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL-EXT’
At line 140 changed 2 lines
446-485 - Contact E-mail
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-EMAIL’
446-485 - Contact E-mail|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-EMAIL’
At line 145 changed 2 lines
489-498 - Contact FAX
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-FAX’
489-498 - Contact FAX|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-FAX’
At line 148 changed 2 lines
499-499 - Preferred Method of Problem Notification Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-METH’
499-499 - Preferred Method of Problem Notification Code|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-METH’
At line 151 changed 2 lines
500-500 - Preparer Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-PREPARER’
500-500 - Preparer Code|Derived from [IDFDV] Field Identifier: ‘SUB-PREPARER’
At line 156 changed one line
Record name: Code RE - Employer Record (same as Federal code RE)
!Record Name: Code RE - Employer Record (same as Federal code RE)
||Column||Description||Source
At line 158 removed 2 lines
Column Description
At line 166 changed 2 lines
7 - Agent Indicator Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-AGENT-IND’
7 - Agent Indicator Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-AGENT-IND’
At line 172 changed 2 lines
17-25 - Agent for EIN
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-FOR-EIN’
17-25 - Agent for EIN|Derived from [IDFDV] Field Identifier: ‘W2-ER-FOR-EIN’
At line 175 changed 2 lines
26 - Terminating Business Indicator
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’
26 - Terminating Business Indicator|Derived from [IDFDV] Field Identifier: ‘W2-ER-TERM-BUS’
At line 178 changed 2 lines
27-30 - Establishment Number
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ESTAB’
27-30 - Establishment Number|Derived from [IDFDV] Field Identifier: ‘W2-ER-ESTAB’
At line 181 changed 2 lines
31-39 - Other EIN
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-OTHER-EIN’
31-39 - Other EIN|Derived from [IDFDV] Field Identifier: ‘W2-ER-OTHER-EIN’
At line 184 changed 2 lines
40-96 - Employer Name
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-NAME’
40-96 - Employer Name|Derived from [IDFDV] Field Identifier: ‘W2-ER-NAME’
At line 187 changed 2 lines
97-118 - Employer Location Address
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-LOCN-ADDR’
97-118 - Employer Location Address|Derived from [IDFDV] Field Identifier: ‘W2-ER-LOCN-ADDR’
At line 190 changed 2 lines
119-140 - Employer Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-DELIV-ADDR’
119-140 - Employer Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-ER-DELIV-ADDR’
At line 193 changed 2 lines
141-162 - Employer City
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-CITY’
141-162 - Employer City|Derived from [IDFDV] Field Identifier: ‘W2-ER-CITY’
At line 196 changed 2 lines
163-164 - Employer State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-STATE’
163-164 - Employer State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-ER-STATE’
At line 199 changed 2 lines
165-169 - Employer ZIP Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP’
165-169 - Employer ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP’
At line 202 changed 2 lines
170-173 - Employer ZIP Code Extension
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP-EXT’
170-173 - Employer ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP-EXT’
At line 207 changed 2 lines
179-201 - Employer Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-STATE’
179-201 - Employer Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘W2-ER-F-STATE’
At line 210 changed 2 lines
202-216 - Employer Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-POSTAL’
202-216 - Employer Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-F-POSTAL’
At line 213 changed 2 lines
217-218 - Employer Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’
217-218 - Employer Country Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-COUNTRY’
At line 223 changed 2 lines
220 - Tax Jurisdiction Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TAX-JURIS’
220 - Tax Jurisdiction Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-TAX-JURIS’
At line 226 changed 2 lines
221 - Third-Party Sick Pay Indicator
- Derived from IDFDV screen, Field Identifier: ‘SUB-3RD-PARTY-SICK’
221 - Third-Party Sick Pay Indicator|Derived from [IDFDV] Field Identifier: ‘SUB-3RD-PARTY-SICK’
At line 231 changed one line
Record name: Code RS - State Record
!Record Name: Code RS - State Record
||Column||Description||Source
At line 233 removed 2 lines
Column Description
At line 245 changed 2 lines
10-18 - Social Security Number
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’
10-18 - Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’
At line 249 changed 2 lines
19-33 - Employee First Name
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’
19-33 - Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’
At line 252 changed 2 lines
34-48 - Employee Middle Name or Initial
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’
34-48 - Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’
At line 255 changed 2 lines
49-68 - Employee Last Name
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’
49-68 - Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’
At line 258 changed 2 lines
69-72 - Employee Suffix
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’
69-72 - Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’
At line 261 changed 2 lines
73-94 - Employee Location Address
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’
73-94 - Employee Location Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’
At line 264 changed 2 lines
95-116 - Employee Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’
95-116 - Employee Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’
At line 267 changed 2 lines
117-138 - Employee City
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’
117-138 - Employee City|Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’
At line 270 changed 2 lines
139-140 - Employee State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’
139-140 - Employee State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’
At line 273 changed 2 lines
141-145 - Employee ZIP Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’
141-145 - Employee ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP’
At line 276 changed 2 lines
146-149 - Employee ZIP Code Extension
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’
146-149 - Employee ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’
At line 281 changed 2 lines
155-177 - Employee Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’
155-177 - Employee Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘W2-EE-F-STATE’
At line 284 changed 2 lines
178-192 - Employee Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’
178-192 - Employee Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-F-POSTAL’
At line 287 changed 2 lines
193-194 - Employee Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
193-194 - Employee Country Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-COUNTRY’
At line 291 changed one line
||Column||Description||Source
At line 299 changed 2 lines
203-213 - State Quarterly Unemployment Insurance Total Wages
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
203-213 - State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
At line 328 changed one line
||Column||Description||Source
At line 333 changed 2 lines
276-286 - State Taxable Wages
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
276-286 - State Taxable Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
At line 336 changed 2 lines
287-297 - State Income Tax Withheld
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
287-297 - State Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
At line 364 changed one line
Record name: Code RF - Final Record
!Record Name: Code RF - Final Record
||Column||Description||Source
At line 366 removed 2 lines
Column Description