This page (revision-34) was last changed on 26-Nov-2021 10:22 by Meg McFarland

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
34 26-Nov-2021 10:22 24 KB Meg McFarland to previous
33 26-Nov-2021 10:22 24 KB Meg McFarland to previous | to last
32 26-Nov-2021 10:22 24 KB Meg McFarland to previous | to last
31 26-Nov-2021 10:22 17 KB Meg McFarland to previous | to last
30 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
29 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
28 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
27 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
26 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
25 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
24 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
23 26-Nov-2021 10:22 16 KB Meg McFarland to previous | to last
22 26-Nov-2021 10:22 14 KB kparrott to previous | to last
21 26-Nov-2021 10:22 14 KB kparrott to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 108 added one line
|222-512 MA|Blank|
At line 109 removed 3 lines
222-512 MA|Blank|
At line 112 added 21 lines
|1-2|Record Identifier|Constant "RS"
|3-4|State Code\\ \\Numeric Code, use ‘25’ for Massachusetts|
|5-9 MA|Blank|
|10-18|Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’ (seq 2500)\\ \\If an invalid SSN is encountered, this field is entered with zeroes
|19-33|Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
|34-48|Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
|49-68|Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
|69-72|Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
|73-94|Employee Location Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
|95-116|Employee Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
|117-138|Employee City|Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’ (seq 2620)
|139-140|Employee State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’ (seq 2630)
|141-145|Employee ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP’ (seq 2640)
|146-149|Employee ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
|150-247 MA|Blank|
|248-267|State Employer Account Number|Derived from [IDFDV] Field Identifier: ‘W2-STATE-REGIST’ for the reporting State\\ \\When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from [IDGV] for the SUI Registration of the state\\ \\Leave blank for Massachusetts
|268-273|Blank|
|274-275|State code, appropriate FIPS postal numeric code|Derived from the State being reported\\ \\e.g. Massachusetts numeric code is "25"
|276-286|State Taxable Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’(7020) and ‘W2-ST-WAGE-WORK’ (7030)
|287-297|State Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ (7040) and ‘W2-ST-TAX-WORK’ (7050)
|298-512 MA|Blank|
At line 115 removed 49 lines
1-2 - Record Identifier
- Constant "RS"
3-4 - State Code
- Numeric Code, use ‘25’ for Massachusetts.
5-9 MA|Blank|
10-18 - Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’ (seq 2500)
- if an invalid SSN is encountered, this field is entered with zeroes.
19-33 - Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
34-48 - Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
49-68 - Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
69-72 - Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
73-94 - Employee Location Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
95-116 - Employee Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
117-138 - Employee City|Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’ (seq 2620)
139-140 - Employee State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’ (seq 2630)
141-145 - Employee ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP’ (seq 2640)
146-149 - Employee ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
150-247 MA|Blank|
248-267 - State Employer Account Number|Derived from [IDFDV] Field Identifier: ‘W2-STATE-REGIST’ for the reporting State
- When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from IDGV screen for the SUI Registration of the State
- Leave Blank for Massachusetts
268-273|Blank|
274-275 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported
- e.g. Massachusetts numeric code is "25"
276-286 - State Taxable Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’(7020) and ‘W2-ST-WAGE-WORK’ (7030)
287-297 - State Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ (7040) and ‘W2-ST-TAX-WORK’ (7050)
298-512 MA|Blank|
At line 138 added 5 lines
|1-2|Record Identifier|Constant "RT"
|3-9|Number of RS Records\\ \\Total number of code "RS" records reported since last code "RE" record|
|10-24 MA|Total state taxable wages|
|25-39 MA|Total state income tax withheld|
|40-512 MA|Blank|
At line 169 removed 15 lines
1-2 - Record Identifier
- Constant "RT"
3-9 - Number of RS Records
- Total number of code "RS" records reported since last code "RE" record
10-24 MA - Total state taxable wages
-
25-39 MA - Total state income tax withheld
40-512 MA|Blank|
At line 189 changed one line
*Annual Form Code – Use the standard supplied form code HL$US-W2-2012. The Variables need to be entered in this form code for specific use in the installation.
*Annual Form Code – Use the standard supplied form code HL$US-W2-2012. The variables need to be entered in this form code for specific use in the installation.
At line 191 changed one line
*Use the supplied form code ‘HL$US-QTR-2012’. The Variables need to be entered in this form code for specific use in the installation.
*Use the supplied form code ‘HL$US-QTR-2012’. The variables need to be entered in this form code for specific use in the installation.
At line 198 changed one line
(Please note that the following ‘Not Required’ fields may or may not always contain BLANKS).
%%information Please note that the following ‘Not Required’ fields may or may not always contain blanks.%%
At line 200 changed one line
Note: Columns marked with MA indicates it is a Massachusetts specific requirement which is not the standard record format
%%information Note: Columns marked with MA indicates it is a Massachusetts specific requirement which is not the standard record format.%%
At line 164 added 12 lines
|1-1|Record Identifier|Constant ‘A’
|2-5 MA|Blank|
|6-14|Transmitter’s Federal EIN\\ \\Enter only numeric characters; omit hyphens, prefixes and suffixes|Derived from [IDFDV] Field Identifier: ‘TRAN EIN’
|15-23 MA|Blank|
|24-73|Transmitter Name\\ \\The transmitter name of the organization submitting the file|Derived from [IDFDV] Field Identifier: ‘TRAN NAME’
|74-113|Transmitter Street Address\\ \\The street address of the organization submitting the file|Derived from [IDFDV] Field Identifier: ‘TRAN ADDRESS’
|114-138|Transmitter City\\ \\The city of the organization submitting the file|Derived from [IDFDV] Field Identifier: ‘TRAN CITY’
|139-140|Transmitter State\\ \\The standard two character FIPS postal abbreviation|Derived from [IDFDV] Field Identifier: ‘TRAN STATE’
|141-153|Blank|
|154-158|Transmitter ZIP Code\\ \\A valid ZIP code|Derived from [IDFDV] Field Identifier: ‘TRAN ZIP CODE’
|159-163|Transmitter ZIP Code extension\\ \\Use this field as necessary for the four digit extension of ZIP code. Include hyphen in position 159|Derived from [IDFDV] Field Identifier:‘TRAN ZIP EXTN’ (include ‘-‘ in position 159)
|164-275 MA|Blank|
At line 205 removed 32 lines
1-1 - Record Identifier.
- Constant ‘A’.
2-5 MA|Blank|
6-14 - Transmitter’s Federal EIN
- Enter only numeric characters; omit hyphens, prefixes and suffixes|Derived from [IDFDV] Field Identifier: ‘TRAN EIN’
15-23 MA|Blank|
24-73 - Transmitter Name.
- Enter the transmitter name of the organization submitting the file|Derived from [IDFDV] Field Identifier: ‘TRAN NAME’
74-113 - Transmitter Street Address.
- Enter the street address of the organization submitting the file|Derived from [IDFDV] Field Identifier: ‘TRAN ADDRESS’
114-138 - Transmitter City.
- Enter the city of the organization submitting the file|Derived from [IDFDV] Field Identifier: ‘TRAN CITY’
139-140 - Transmitter State.
- Enter the standard two character FIPS postal abbreviation|Derived from [IDFDV] Field Identifier: ‘TRAN STATE’
141-153|Blank|
154-158 - Transmitter ZIP Code.
- Enter a valid ZIP code|Derived from [IDFDV] Field Identifier: ‘TRAN ZIP CODE’
159-163 - Transmitter ZIP Code extension.
- Use this field as necessary for the four digit extension of ZIP code. Include hyphen in position 159|Derived from [IDFDV] Field Identifier:‘TRAN ZIP EXTN’ (include ‘-‘ in position 159)
164-275 MA|Blank|
At line 240 changed 2 lines
1-1 - Record Identifier.
- Constant ‘E’.
|1-1|Record Identifier|Constant ‘E’
At line 243 changed one line
2-5 MA|Blank|
|2-5 MA|Blank|
At line 245 changed 2 lines
6-14 - Federal EIN
- Enter only numeric characters
|6-14|Federal EIN\\ \\Enter only numeric characters