The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the NACHA Record 7 – Addenda record in the CTX file.
|
Field Name |
Description |
Position |
Length |
Data Source or Valid Values |
|---|---|---|---|---|
|
RECORD TYPE CODE |
Identifies the record type. |
1-1 |
1 |
The valid value is 7. |
|
ADDENDA TYPE CODE |
NACHA code indicating the type of addenda record.
|
2-3 |
2 |
The valid value is 5 (Addenda Record with payment-related information). |
|
FIELD SEPARATOR |
Delimiter character separating data elements in the addenda record. |
4-4 |
1 |
The valid value is *. |
|
EMPLOYER FEIN |
The employer's Federal Employer Identification Number.
|
5-14 |
10 |
Retrieved from the Employer FEIN field on the CT Paid Leave Report - Employer Information page. |
|
FIELD SEPARATOR |
Delimiter character separating data elements in the addenda record. |
15-15 |
1 |
The valid value is *. |
|
PAY PERIOD START DATE |
The beginning date of the pay/reporting period for this contribution
|
16-25 |
10 |
Retrieved from the Check Issue Start Date field on the CT Paid Leave Report - Load page. |
|
FIELD SEPARATOR |
Delimiter character separating data elements in the addenda record. |
26-26 |
1 |
The valid value is *. |
|
PAY PERIOD END DATE |
The ending date of the pay/reporting period for this contribution.
|
27-36 |
10 |
Retrieved from the Check Issue End Date field on the CT Paid Leave Report - Load page. |
|
FIELD SEPARATOR |
Delimiter character separating data elements in the addenda record. |
37-37 |
1 |
The valid value is *. |
|
TOTAL CONTRIBUTION FOR THIS EMPLOYER |
The total dollar amount of Connecticut Paid Leave contributions included in this payment.
|
38-48 |
11 |
Calculated from the sum of all employee Deduction values loaded during the data extraction process. |
|
FIELD SEPARATOR |
Delimiter character separating data elements in the addenda record. |
49-49 |
1 |
The valid value is *. |
|
TOTAL WAGES FOR THIS EMPLOYER |
The total wages subject to CT Paid Leave deductions for all employees this quarter. |
50-60 |
11 |
Calculated from the sum of all employee Total Wages values loaded during the data extraction process. |
|
UNUSED |
This field is not used. |
61-83 |
23 |
spaces |
|
SPC ADDENDA SEQUENCE NUMBER |
The sequence number for State Payment Code (SPC) addenda records.
|
84-87 |
4 |
Retrieved from the SPC Addenda Sequence Number field on the CT Paid Leave Report - CTX File page. |
|
ENTRY DETAIL SEQUENCE NUMBER |
A sequential number assigned to each entry detail record in the ACH batch.
|
88-94 |
7 |
Retrieved from the Entry Detail Sequence Number field on the CT Paid Leave Report - CTX File page. |