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

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

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
7 26-Nov-2021 10:22 21 KB Meg McFarland to previous
6 26-Nov-2021 10:22 20 KB Meg McFarland to previous | to last
5 26-Nov-2021 10:22 20 KB Meg McFarland to previous | to last
4 26-Nov-2021 10:22 20 KB Meg McFarland to previous | to last
3 26-Nov-2021 10:22 20 KB Meg McFarland to previous | to last
2 26-Nov-2021 10:22 20 KB Meg McFarland to previous | to last
1 26-Nov-2021 10:22 12 KB unknown to last

Page References

Incoming links Outgoing links
Tax Reporting - CT
Tax Reporting - CT

Version management

Difference between version and

At line 3 changed one line
!!!Colorado Annual and Quarterly Reporting
!!!Connecticut Annual and Quarterly Reporting
At line 5 removed 3 lines
!!What's New for Tax Year 2011
There are no noted file format changes in wage reporting for tax year 2011 for the state of Connecticut.
At line 9 changed one line
This document contains abbreviated set up requirement for the specific state only, please refer to the general document (US_Annual_Qtrly_Reporting_GEN) for other setup procedure that may also be required.
This document contains abbreviated set up requirements for the State of Connecticut only. Please refer to the general document [Tax Reporting - US General] for other setup procedures that may also be required.
At line 17 changed 2 lines
*The Connecticut Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 (formerly MMREF1) file format, and the filing of Quarterly UI wages via magnetic media using the [ICESA] format.
*Record Codes required for the W2 reporting are: Code RA,RE,RS,RT,RF; and for the UI wage reporting are: Codes ‘E’,’S’,’F’.
*The Connecticut Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 file format, and the filing of Quarterly UI wages via magnetic media using the [ICESA] format.
*Record Codes required for the W2 reporting are Code RA, RE, RS, RT, RF. Record Codes E, S and F are required for UI wage reporting.
At line 23 changed 4 lines
!Annual W2 Wage Reporting – EFW2 (formerly MMREF-1) format
[RPYEU] must be run and the following selected to generate Connecticut State file information:
|Media Format:|State File Format
|Select State:|Connecticut, USA
!Annual W2 Wage Reporting – EFW2 Format
[RPYEU] must be run with the following report parameters and filters defined to generate the Connecticut State file information:\\ \\
__RPYEU Report Parameters__
|Annual Form Code|Use standard form code, such as 'HL$US-W2-YYYY'
|Period Type|Mandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period.
|Media Format|Mandatory. Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
|Media File Name|Mandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced
__RPYEU Report Filters__
|Select State: Connecticut, USA
At line 28 changed one line
!!State Media Magnetic Media Reporting – EFW2 (Formerly MMREF1) Format
!!State Media Magnetic Media Reporting – EFW2 Format
At line 32 changed 33 lines
|3-11|Submitter’s Employer ID number (EIN)\\ \\Numeric only|Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’ (seq 1000)
|12-37 CT|Not Required by the state of Connecticut|
|38-94|Company Name|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-NAME’ (seq 1050)
|95-116|Location Address|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-LOCN’ (seq 1060)
|117-138|Delivery Address|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-DELIV’ (seq 1070)
|139-160|Company City|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-CITY’ (seq 1080)
|161-162|Company State Abbreviation|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-STATE’ (seq 1090)
|163-167|Company ZIP code|Derived from v, Field Identifier: ‘SUB-COMP-ZIP’ (seq 1100)
|168-171|Company ZIP code extension|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-ZIP-EXT’ (seq 1110)
|172-176|Blank|
|177-199|Company Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-STATE’ (seq 1120)
|200-214|Company Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130)
|215-216|Company Country Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140)
|217-273|Submitter Name|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
|274-295|Submitter Location Address|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
|296-317|Submitter Delivery Address|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
|318-339|Submitter City|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
|340-341|Submitter State Abbreviation|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
|342-346|Submitter ZIP code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
|347-350|Submitter ZIP code extension|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
|351-355|Blank|
|356-378|Submitter Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
|379-393|Submitter Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
|394-395|Submitter Country Code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
|396-422|Contact Name|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
|423-437|Contact Phone Number|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
|438-442|Contact Phone Extension|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
|443-445|Blank|
|446-485|Contact E-mail|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
|486-488|Blank|
|489-498|Contact FAX|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
|499-500 CT|Not Required by the state of Connecticut|
|501-512|Blank|
|3-11|Submitter’s Employer ID number (EIN)|Enter the submitter’s FEIN. \\Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’ (seq 1000)
|12-19 CT|User Identification|Enter the User Identification
|20-23 CT|Software Vendor Code|Not Required by the State of Connecticut. Fill with blanks
|24-28 CT|Blank|Not Required by the State of Connecticut. Fill with blanks
|24-28 CT|Not Required|
|29 CT|Resub Indicator|Enter “1” if a file is being resubmitted. Otherwise, fill with blanks
|30-35 CT|Resub WFID|If you entered “1” in the Resub Indicator field (location 29), enter the word “AMEND”. Otherwise, Fill with blanks
|36-37 CT|Software Code|Not Required by the State of Connecticut. Fill with blanks
|38-94|Company Name|Enter the name of the company to receive EFW2 annual filing instructions. \\Left justify and fill with blanks.\\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-NAME’ (seq 1050)
|95-116|Location Address|Enter the company’s location address (attention, suite, room number, etc. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-LOCN’ (seq 1060)
|117-138|Delivery Address|Enter the company’s delivery address (street or post office box). \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-DELIV’ (seq 1070)
|139-160|City|Enter the company’s city. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-CITY’ (seq 1080)
|161-162|State Abbreviation|Enter the company’s state. Use a standard postal abbreviation. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-STATE’ (seq 1090)
|163-167|ZIP Code|Enter the company’s ZIP code. For a foreign address, fill with blanks. \\Derived from [IDFDV] Field Identifier: ‘SUB-COMP-ZIP’ (seq 1100)
|168-171|ZIP Code Extension|Enter the company’s four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-ZIP-EXT’ (seq 1110)
|172-176|Blank|Fill with blanks
|177-199|Foreign State/Province|If applicable, enter the company’s foreign state or province. Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-STATE’ (seq 1120)
|200-214|Foreign Postal Code|If applicable, enter the company’s foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130)
|215-216|Country Code|Enter the applicable country code. \\Derived from [IDFDV], Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140)
|217-273|Submitter Name|Enter the name of the organization submitting this file. Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
|274-295|Submitter Location Address|Enter the location address of the organization submitting this file. Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
|296-317|Submitter Street Address|Enter the street address of the submitter (street or post office box). \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
|318-339|Submitter City|Enter the submitter’s city. Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
|340-341|Submitter State Abbreviation|Enter the submitter’s state. Use a standard postal abbreviation for a foreign address and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
|342-346|Submitter ZIP Code|Enter the submitter’s ZIP code. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
|347-350|Submitter ZIP Code Extension|Enter the submitter’s four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
|351-355|Blank|Fill with blanks
|356-378|Submitter Foreign State/Province|If applicable, enter the submitter's foreign state or province. Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
|379-393|Submitter Foreign Postal Code|If applicable, enter the submitter's foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
|394-395|Submitter Country Code|Enter the applicable country code. \\Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
|396-422|Contact Name|Enter the name of the person to be contacted by DRS concerning processing problems. \\Derived from [IDFDV], Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
|423-437|Contact Phone Number|Enter the contact’s telephone number (including area code). Left Number justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
|438-442|Contact Phone Extension|Enter the contact’s telephone extension. Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
|443-445|Blank|Fill with blanks
|446-485|Contact E-mail|Required. Enter the contact’s electronic mail or Internet address. Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
|486-488|Blank|Fill with blanks
|489-498|Contact FAX|__For U.S. and U.S. Territories only:__ If applicable, enter the contact’s FAX number (including area code). Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
|499|Preferred Method of Problem Notification Code|Not Required by the State of Connecticut. Fill with blanks
|500|Preparer Code|Not Required by the State of Connecticut. Fill with blanks
|501-512|Blank|Fill with blanks
At line 69 changed 4 lines
|3-6|Tax year CCYY|From user specified FROM-TO period converted to CCYY
|7 CT|Not Required by the state of Connecticut|
|8-16|Employer/Agent EIN|System derived the applicable Federal reporting EIN, from [IDGV] or [IDGR]
|17-39 CT|Not Required by the state of Connecticut|
|3-6|Tax year YYYY|Required. Enter the reporting year. \\From user specified FROM-TO period converted to YYYY
|7 CT|Agent Indicator Code|Not Required by the State of Connecticut. Fill with blanks
|8-16|Employer's Identification Number EIN|Enter only numeric characters. Omit hyphens, prefixes and suffixes. \\System derived the applicable Federal reporting EIN, from [IDGV] or [IDGR]
|17-39 CT|Not Required by the State of Connecticut. Fill with blanks
At line 74 changed 12 lines
|97-118 |Employer Location Address|Derived from [IDFDV], Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
|119-140|Employer Delivery Address|Derived from [IDFDV], Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
|141-162|Employer City|Derived from [IDFDV], Field Identifier: ‘W2-ER-CITY’ (seq 2040)
|163-164|Employer State Abbreviation|Derived from [IDFDV], Field Identifier: ‘W2-ER-STATE’ (seq 2050)
|165-169|Employer ZIP Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
|170-173|Employer ZIP Code Extension|Derived from [IDFDV], Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
|174-178|Blank|
|179-201|Employer Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
|202-216|Employer Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
|217-218|Country Code|Derived from [IDFDV], Field Identifier ‘W2-ER-COUNTRY’ (seq 2100)
|219-221 CT|Not Required by the state of Connecticut|
|222-512|Blank|
|97-118 |Employer Location Address|Enter the employer's location address (attention, suite, room number, etc. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
|119-140|Employer Delivery Address|Enter the employer's delivery address (street or post office box). \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
|141-162|Employer City|Enter the employer's city. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-CITY’ (seq 2040)
|163-164|Employer State Abbreviation|Enter the employer's state. Use a standard postal abbreviation. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-STATE’ (seq 2050)
|165-169|Employer ZIP Code|Enter the employer's ZIP code. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
|170-173|Employer ZIP Code Extension|Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
|174-178|Kind of Employer|Enter the Kind of Employer as entered on the file submitted to the SSA. \\Left justify and fill with blanks.
|179-201|Employer Foreign State/Province|If applicable, enter the employer’s foreign state or province. \\ Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
|202-216|Employer Foreign Postal Code|If applicable, enter the employer’s foreign postal code. \\Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
|217-218|Country Code|Enter the applicable country code. \\Derived from [IDFDV], Field Identifier ‘W2-ER-COUNTRY’ (seq 2100)
|219 CT|Employment Code|Not Required by the State of Connecticut. Fill with blanks
|220|Tax Jurisdiction Code|Enter the Tax Jurisdiction Code
|221-318|Blank|Fill with blanks
|319-512|Fill with blanks. Reserved for SSA use.
At line 104 added one line
__Specific to the State of Conneticut
At line 90 changed 2 lines
|3-4|State code, appropriate FIPS postal numeric code|system Derived from the State being reported\\ \\e.g. Connecticut is code "09"
|5-9|Taxing Entity Code\\ \\Not required|
|3-4|State code|Enter the appropriate FIPS postal numeric code. Connecticut is code "09". \\System derived from the State being reported
|5-9|Taxing Entity Code|Not required
At line 97 changed 6 lines
|73-94|Employee Location Address|Derived from [IDFDV], Field Identifier: ‘W2-EE-LOCN-ADDR’
|95-116|Employee Delivery Address|Derived from [IDFDV], Field Identifier: ‘W2-EE-DELIV-ADDR’
|117-138|Employee City|Derived from [IDFDV], Field Identifier: ‘W2-EE-CITY’
|139-140|Employee State Abbreviation|Derived from [IDFDV], Field Identifier: ‘W2-EE-STATE’
|141-145 |Employee ZIP Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP’
|146-149 |Employee ZIP Code Extension|Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP-EXT’
|73-94|Employee Location Address|Enter the employee's location address (attention, suite, room number, etc. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: W2-EE-LOCN-ADDR
|95-116|Employee Delivery Address|Enter the employee's delivery address (street or post office box). \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-DELIV-ADDR’
|117-138|Employee City|Enter the employee's city. \\Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-CITY’
|139-140|Employee State Abbreviation|Enter the employee's state. Use a standard postal abbreviation. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-STATE’
|141-145 |Employee ZIP Code|Enter the employee's ZIP code. For a foreign address, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP’
|146-149 |Employee ZIP Code Extension|Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP-EXT’
At line 104 changed 11 lines
|155-177|Employee Foreign State/Province\\ \\Not read by PA Revenue|Derived from [IDFDV], Field Identifier: ‘W2-EE-F-STATE’
|178-192|Employee Foreign Postal Code\\ \\Not read by PA Revenue|Derived from [IDFDV], Field Identifier: ‘W2-EE-F-POSTAL’
|193-194|Employee Country Code\\ \\Not read by PA Revenue|Derived from [IDFDV], Field Identifier: ‘W2-EE-COUNTRY’
|195-247 CT|Not Required by the state of Connecticut|
|248-267|State Employer Account Number|Derived from [IDFDV], Field Identifier: ‘W2-STATE-REGIST’ for the reporting State
|268-273|Blank|
|274-275|State code, appropriate FIPS postal numeric code|system Derived from the State being reported\\ \\e.g. Connecticut is code "09"
|276-286|State Taxable Wages|Derived from [IDFDV], Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
|287-297|State Income Tax Withheld|Derived from [IDFDV], Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
|298-487 CT|Not required|
|488-512|Blank|
|155-177|Employee Foreign State/Province|If applicable, enter the employee’s foreign state or province. \\ Left justify and fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-F-STATE’
|178-192|Employee Foreign Postal Code|If applicable, enter the employee’s foreign postal code. \\Left justify and fill with blanks. Otherwise, fill with blanks. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-F-POSTAL’
|193-194|Employee Country Code|Enter the applicable country code. \\Derived from [IDFDV], Field Identifier: ‘W2-EE-COUNTRY’
|195-247 CT|Not Required|Fill with blanks
|248-267|State Employer Account Withholding Number|Enter the 9-digit Connecticut Withholding Tax number FEIN. \\Left justify and fill with blanks. Derived from [IDFDV], Field Identifier: ‘W2-STATE-REGIST’ for the reporting State
|268-273|Blank|Fill with blanks
|274-275|State code|Enter the appropriate FIPS postal numeric code. \\Connecticut is code "09" \\System derived from the State being reported
|276-286|State Taxable Wages|Required. Right justify and zero fill. \\Derived from [IDFDV], Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
|287-297|State Income Tax Withheld|Required. Right justify and zero fill. \\Derived from [IDFDV], Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
|298-487 CT|Not required|Fill with blanks
|488-512|Blank|Fill with blanks
At line 133 added one line
At line 119 changed 4 lines
|3-9|Number of Code RS Record in previous Code RE Record|system derived number of all Code RS records in previous Code RE record
|10-24|Total State Taxable Wages|System derived Total State Taxable Wages of all Code RS records in previous Code RE record
|25-39|Total State Taxes|System derived Total State Taxes of all Code RS records in previous Code RE record
|40-512|Blank|
|3-9|Number of Employees|Enter the total number of RS records reported since the last code RE record. \\Right justify and zero fill.\\System derived number of all Code RS records on the entire file
|10-24|State Taxable Wages|Enter the total for all code RS records reported since the last code RE record. \\Right justify and zero fill. \\System derived Total State Taxable Wages of all Code RS records on the entire file
|25-39|State Income Tax Withheld|Enter the total for all code RS records reported since the last code RE record. \\Right justify and zero fill. \\System derived Total State Taxes of all Code RS records on the entire file
|40-512|Blank
At line 127 changed 3 lines
|3-11|Number of Code RS Record on the entire file|System derived number of all Code RS records on the entire file
|12-27|Total State Taxable Wages|System derived Total State Taxable Wages of all Code RS records on the entire file
|28-43|Total State Taxes|System derived Total State Taxes of all Code RS records on the entire file
|3-11|Number of Employees|Enter the total number of code RS records recorded on the entire file.\\System derived number of all Code RS records on the entire file
|12-27|State Taxable Wages|Enter the grand total of all code RS records on this file. \\Right justify and zero fill. \\System derived Total State Taxable Wages of all Code RS records on the entire file
|28-43|State Income Tax Withheld|Enter the grand total of all code RS records on this file. Right justify and zero fill. \\System derived Total State Taxes of all Code RS records on the entire file
At line 133 changed 3 lines
[RPYEU] must be run and the following selected to generate Connecticut State file information:
|Media Format:|State File Format
|Select State:|Connecticut, USA
[RPYEU] must be run with the following report parameters and filters defined to generate the Connecticut State file information: \\ \\
__RPYEU Report Parameters__
|Quarterly Form Code|Mandatory. Quarterly Form Code HL$US-W2-20YY, defined on the IDFDV form. \\Must be entered in order to produce the UI wage file in [ICESA] format. \\NOTE: Always use the current year form code. __DO NOT__ use a prior year form code as the Identifiers may be obsolete.
|Period Type|Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period.
|Media Format|Mandatory. Enter State SUI File Format. Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
|Media File Name|Mandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced
At line 137 changed 6 lines
*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.
*The ‘Quarterly Form Code’ must be entered in order to produce the UI wage file in [ICESA] format. – 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.
*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.
\\
__RPYEU Report Filters__
|Select State: Connecticut, USA
At line 147 changed 15 lines
|2-3 CT|Last Month of the Quarter 03,06,09,12|
|4-5 CT|Two Digit Year|
|6-14|Federal EIN \\ \\Numeric only|
|15-23|Blank|
|24-73|Employer name|Derived from the Entity
|74-113|Street address|Derived from the Entity Location
|114-138|City|Derived from the Entity Location
|139-140|State (use a standard FIPS postal abbreviation)|Derived from the Entity Location
|141-148|Blank|
|149-153|ZIP code extension (including ‘-‘ in position 149)|Derived from the Entity Location
|154-158|ZIP code or foreign postal code|Derived from the Entity Location
|159-159 CT|Name code|Constant ‘S’
|160-160|Type of employment|Derived from [IDFDV], Field Identifier: ‘TYPE OF EMPLOYMENT’
|161-162|Blocking Factor\\ \\Maximum 25|
|163-168 CT|Blank|
|2-3 CT|Quarterly Period|Enter the last month of the Quarter, such as 03, 06, 09 or 12
|4-5 CT|Yearly Period|Required. Enter the last two digits of the reporting year. \\From user defined FROM-TO period converted to YY
|6-14|Federal EIN|Enter the employer's Identification Number EIN. \\Enter only numeric characters. Omit hyphens, prefixes and suffixes. \\System derived the applicable Federal reporting EIN, from [IDGV] or [IDGR]
|15-23 CT|Reserved|Fill with blanks
|24-73|Employer Name|Enter the name of the Employer\\Left justify and fill with blanks.\\Derived from the Entity
|74-113|Street Address|Enter the employer's street address (attention, suite, room number, etc. \\Left justify and fill with blanks. \\Derived from the Entity Location
|114-138|City|Enter the employer's city. \\Left justify and fill with blanks. \\Derived from the Entity Location
|139-148|State Address|Enter the Postal Abbreviation of the State and fill with blanks. \\For a foreign address, fill with blanks. \\Derived from the Entity Location
|149 CT|Hyphen|Constant "-"
|150-153|ZIP Code Extension|Enter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Derived from the Entity Location
|154-158|ZIP Code or Foreign Postal Code|Enter the employer's ZIP code. For a foreign address, fill with blanks. \\Derived from the Entity Location
|159-159 CT|Employee Name code|Enter Constant ‘S’
|160|Type of employment|Enter ‘A’ for Agriculture, ‘F’ for Federal Government, ‘H’ for Household, ‘M’ for Military, ‘X’ for Railroad, ‘R’ for Regular (all others) \\Derived from [IDFDV], Field Identifier: ‘TYPE OF EMPLOYMENT’
|161-162|Blocking Factor|Fill with zeroes
|163-168 CT|Reserved|Fill with blanks
At line 163 changed 3 lines
|171-175 CT|Blank|
|176-182 CT|Unemployment Compensation Number|Derived from the [IDGV] State SUI Registration
|183-276 CT |Blank|
|171-175 CT|Reserved|Fill with blanks
|176-182 CT|CT Number|Enter the employer's Unemployment Compensation Number \\Derived from the [IDGV] State SUI Registration
|183-275 CT|Reserved|Fill with blanks
|276 CT|Special Use|Reserved, use only as instructed
At line 170 changed 13 lines
|2-10|Employee SSN Number|
|11-37 CT|Employee Name Last Name, First Name|
|38-77 CT|Employee Address|
|78-102 CT|Employee City|
|103-112 CT|Employee State|
|113-117 CT|Employee Zip Code Extension (including ‘-‘ in position 113)|
|118-122 CT|Employee Zip Code|
|123 CT|Blank|
|124-125 CT|Connecticut Employer FIPS Code|Constant ‘09’
|126-131 CT|Blank|
|132-140 CT|State Quarterly SUI Gross Wages|Derived from ‘SUI TOTAL WAGES’
|141-149 CT|State Taxable Wages|From ‘SUI TOTAL WAGES’
|150-276 CT |Blank|
|2-10|Employee SSN Number|Enter the employee’s social security number. If not known, fill with blanks \\Do not enter dashes or any other special characters
|11-37 CT|Employee Name|Enter the employee's last Name and first Name
|38-77 CT|Employee Address|Enter the employee's address
|78-102 CT|Employee City|Enter the employee's City
|103-112 CT|Employee State|Enter the employee's State
|113 CT|Hyphen|Constant "-"
|114-117 CT|Employee Zip Code Extension|Enter the employee's four-digit extension of the ZIP code. If not applicable, fill with blanks. \\Include hyphen ‘-‘ in position 113.
|118-122 CT|Employee Zip Code|Enter the employee's ZIP code. For a foreign address, fill with blanks.
|123 CT|Reserved|Fill with blanks
|124-125 CT|CT FIPS Code|Constant ‘09’ \\Enter the Connecticut Employer FIPS Code
|126-131 CT|Reserved|Fill with blanks
|132-140 CT|State Quarterly SUI Gross Wages|Enter the total quarterly gross wages subject to CT Unemployment Tax \\Derived from ‘SUI TOTAL WAGES’
|141-149 CT|State Taxable Wages|Enter the total quarterly earnings subject to CT Unemployment Tax \\Derived from ‘SUI TOTAL WAGES’
|150-275 CT|Reserved|Fill with blanks
|276 CT|Special Use|Reserved, use only as instructed
At line 187 changed 16 lines
|2-8 CT|Number of employees\\ \\Total number of code "S" records on file|
|9 CT|Blank|
|10-25 CT|Total Taxable Wages|
|26 CT|Blank|
|27-42 CT|Total Excess Wages|
|43 CT|Blank|
|44-59 CT|Total Gross Wages|
|60 CT|Blank|
|61-71 CT|Remittance Amount|
|72-72 CT|Blank|
|73-77 CT|Total Employees with TAXABLE Wages that were paid during the Pay Period in which the twelve day of the first month in the Quarter falls|
|78 CT|Blank|
|79-83 CT| Total Employees with TAXABLE Wages that were paid during the Pay Period in which the twelve day of the second month in the Quarter falls|
|84 CT|Blank|
|85-89 CT|Total Employees with TAXABLE Wages that were paid during the Pay Period in which the twelve day of the third month in the Quarter falls|
|90-276 CT|Blank|
|2-8 CT|Number of employees|Total number of code "S" records on file
|9 CT|Reserved|Fill with blanks
|10-25 CT|Total Taxable Wages|Enter the total taxableble wages
|26 CT|Reserved|Fill with blanks
|27-42 CT|Total Excess Wages|Enter the total excess wages
|43 CT|Reserved|Fill with blanks
|44-59 CT|Total Gross Wages|Enter the total gross wages
|60 CT|Reserved|Fill with blanks
|61-71 CT|Remittance Amount|
|72-72 CT|Reserved|Fill with blanks
|73-77 CT|1st Month Count|Enter the total number of employees with taxable wages that were paid during the Pay Period where the 12th day of the first month in the Quarter falls
|78 CT|Reserved|Fill with blanks
|79-83 CT|2nd Month Count|Enter the total number of employees with taxable wages that were paid during the Pay Period where the 12th day of the second month in the Quarter falls
|84 CT|Reserved|Fill with blanks
|85-89 CT|3rd Month Count|Enter the total number of employees with taxable wages that were paid during the Pay Period where the 12th day of the third month in the Quarter falls
|90-276 CT|Reserved|Fill with blanks
This page (revision-7) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop