NACHA Record 7 – Addenda Record - File Layout and Data Mapping
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 gross wages subject to Connecticut Paid Leave for all employees this quarter. | 50-60 | 11 | Calculated from the sum of all employee Gross 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. |