Return File - File Layout and Data Mapping

The default file name for the Return file is CT Paid Leave Report_Return File_<YYYY_Q#>.csv.

For the latest file layout information, search for and refer to the current file specification document, Connecticut Paid Leave File Specification Toolkit, on the CT Paid Leave website.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Return file.

Column	Column Name	Description	Data Source or Valid Values
A	DocumentCount	The number of documents in the return file.	The valid value is 1 and is hardcoded.
B	AmendedReturn	Indicates whether this return is an amended/corrected filing.	Valid values: True False Retrieved from the Amended Return field on the CT Paid Leave Report - Return File page.
C	TaxPeriodStartDate	The beginning date of the tax reporting period (quarter).	Retrieved from the Check Issue Start Date field on the CT Paid Leave Report - Load page.
D	TaxPeriodEndDate	The ending date of the tax reporting period (quarter).	Retrieved from the Check Issue End Date field on the CT Paid Leave Report - Load page.
E	PreparerLegalName	The name of your organization.	Retrieved from the Employer Legal Name field on the CT Paid Leave Report - Employer Information page.
F	PreparerFEIN	Employer Identification Number (EIN) assigned by the IRS.	Retrieved from the Employer FEIN field on the CT Paid Leave Report - Employer Information page.
G	SettlementDate	The date and time when the return file was generated.	The valid value is the current date/time when the file was created.
H	ReturnTotalContributionsDue	The total amount of Connecticut Paid Leave contributions due for this return.	Calculated from the sum of all employee Deduction values loaded during the data extraction process.
I	EmployerFEIN	The Employer Identification Number (EIN) assigned by the IRS.	Retrieved from the Employer FEIN field on the CT Paid Leave Report - Employer Information page.
J	EmployerLegalName	The name of your organization.	Retrieved from the Employer Legal Name field on the CT Paid Leave Report - Employer Information page.
K	EmployerTaxPayerID	The employer's Connecticut Paid Leave taxpayer identification number.	Retrieved from the Taxpayer ID Number field on the CT Paid Leave Report - Employer Information page.
L	IndividualName	The full name of the individual employer (for sole proprietors/individuals). This field is blank if the employer is a corporation/business entity.	Retrieved from the First Name, Middle Name, and Last Name fields on the CT Paid Leave Report - Employer Information page.
M	FName	The contact person’s first name. This field is used for sole proprietors and is blank for business entities.	Retrieved from the First Name field on the CT Paid Leave Report - Employer Information page.
N	MName	The contact person’s middle name. This field is used for sole proprietors and is blank for business entities.	Retrieved from the Middle Name field on the CT Paid Leave Report - Employer Information page.
O	LName	The contact person’s last name. This field is used for sole proprietors and is blank for business entities.	Retrieved from the Last Name field on the CT Paid Leave Report - Employer Information page.
P	BusAdrStreet1	The first line of your organization's address.	Retrieved from the Street Address 1 field on the CT Paid Leave Report - Employer Information page.
Q	BusAdrStreet2	The second line of your organization's address.	Retrieved from the Street Address 2 field on the CT Paid Leave Report - Employer Information page.
R	BusAdrStreet3	The third line of your organization's address.	Retrieved from the Street Address 3 field on the CT Paid Leave Report - Employer Information page.
S	BusAdrCity	The city of your organization's address.	Retrieved from the City field on the CT Paid Leave Report - Employer Information page.
T	BusAdrStateCode	The state of your organization's address.	Retrieved from the State field on the CT Paid Leave Report - Employer Information page.
U	BusAdrPostalCode	The five-digit zip code of your organization's address, followed by the four-digit zip code extension if available.	Retrieved from the Zip Code and Zip Extn fields on the CT Paid Leave Report - Employer Information page.
V	BusAdrCountry	The country code of your organization's address.	The valid value is USA and is hardcoded.
W	FrgnAdrStreet1	The first line of your organization's foreign address. This field is blank.	Not applicable
X	FrgnAdrStreet2	The second line of your organization's foreign address. This field is blank.	Not applicable
Y	FrgnAdrStreet3	The third line of your organization's foreign address. This field is blank.	Not applicable
Z	FrgnAdrCity	The city of your organization's foreign address. This field is blank.	Not applicable
AA	FrgnAdrStateCode	The state or province of your organization's foreign address. This field is blank.	Not applicable
AB	FrgnAdrPostalCode	The postal code of your organization's foreign address. This field is blank.	Not applicable
AC	FrgnAdrCountry	The country code of your organization's foreign address. This field is blank.	Not applicable
AD	TotalWagesThisPeriod	The total wages subject to CT Paid Leave deductions for all employees this quarter.	Calculated from the sum of all employee Total Wages values loaded during the data extraction process.
AE	TotalContributionsDue	The total CT Paid Leave contributions due for this quarter.	Calculated from the sum of all employee Deduction values loaded during the data extraction process.
AF	ReportingQuarter	The quarter being reported.	Valid values: 1 2 3 4 Retrieved from the Quarter field on the CT Paid Leave Report - Load page.
AG	ReportingYear	The four-digit year being reported.	Retrieved from the Year field on the CT Paid Leave Report - Load page.
AH	FullQuarter	Indicates whether this represents a full quarter of employment.	Valid values: True False Calculated based on the employment period.
AI	CTEmployeeCount	The total number of employees with CT Paid Leave wages this quarter.	Calculated count of employees with loaded data.
AJ	CTGrossWages	The total gross wages for all CT employees this quarter.	Calculated from the sum of all employee Gross Wages values loaded during the data extraction process.
AK	CTGrossWagesEmployeeCount	The number of employees with gross wages subject to CT Paid Leave.	Calculated count of employees with non-zero gross wages.
AL	PaymentAmountTotal	The total payment amount being submitted with this return.	Calculated from the sum of all employee Deduction values loaded during the data extraction process.
AM	IsFinalReturn	Indicates whether this is the employer's final return (account closure).	Valid values: True False Retrieved from the Final Return field on the CT Paid Leave Report - Return File page.
AN	PayCycle	The employer's payroll frequency for this quarter	Valid values: Weekly Bi-Weekly Semi-monthly Monthly Multiple Pay Cycles Other Retrieved from the Pay Cycle field on the CT Paid Leave Report - Return File page.