Return to File Formats & Field Values The following is a sample enrollment reporting record for John Doe Student, Jr., translated into EDI format. EDI Transmission Data Element Name(s) ISA|00| |00| |ZZ|SCTSCTXML000000|ZZ|CLEARINGHOUSE00|091116|1135|U|00300|000000001|0|P|: Interchange Control Header GS|SV|SCTSCTXML000000|CLEARINGHOUSE00|20091116|1135|000000001|X|005010 Functional Group Header; EDI version 5010 ST|190|1111XQ567 Begin Transaction Set 190; Control No. 1111XQ567 BGN|11|1111XQ567|20180515|1135|ES Response […]
Electronic Data Interchange (EDI) File Mapping
Return to File Formats & Field Values Download EDI File Mapping for Data Elements for details on mapping A3 data elements to Excel/text file fields. The tables below outline how EDI file fields map to Excel/text file fields. Header Record Excel/Text Field EDI Field(s) Record Type N/A School Code ENT03, […]
EDI File Trailer Segments
Return to File Formats & Field Values Transaction Set Trailer (SE) This segment indicates the end of the transaction set and provides the count of the transmitted segments, including the header (ST) and trailer (SE) segments. It is the last segment of the transaction set. Reference Designator Data Element Name […]
EDI File Detail Segments
Return to File Formats & Field Values Beginning Segment (BGN) This segment indicates the purpose, date, and time of the transaction and the beginning of a transaction set. The identification and verification routine includes a reference number assigned by the sending institution or agency and the date and time of […]
EDI File Header Segments
Return to File Formats & Field Values Interchange Control Header (ISA) This segment starts and identifies an interchange of one or more functional groups and interchange-related control segments. The Interchange Control Header (ISA) and Interchange Control Trailer (IEA) segments perform the following functions: Contain one or more functional groups or […]
EDI File Format
Return to File Formats & Field Values Electronic data interchange (EDI) enrollment reporting files are organized as follows: HEADER SEGMENTS Interchange Control Header (ISA) Functional Group Header (GS) Start of Student Enrollment Verification Transaction Set (190) Transaction Set Header (ST) DETAIL SEGMENTS Beginning Segment (BGN) School Enrollment Information (ENR) Date […]
Transmitting Files
How to Transmit Files Transmit your enrollment reporting files through the Clearinghouse Secure FTP site. See our Secure FTP Knowledge Base for information on how to use the Secure FTP Site to transmit files. Transmission Schedule Once your institution has completed a full academic year, the Clearinghouse will generate a […]
Excel/Text File Trailer Record
Return to File Formats & Field Values For fixed width format, the total trailer record length is 1250 bytes. For Excel/text tab delimited format, the total trailer record length is 12 columns. All fields in the trailer record are required. Excel Column Field Name Characters Bytes Format Description A Record […]
Excel/Text File Detail Records
Return to File Formats & Field Values For fixed width format, the total detail record length is 1250 bytes. For Excel/text tab delimited format, the total header record length is 109 columns. Create one detail record for each student. Excel Column Field Name Characters Bytes Required Format Description A Record […]
Excel/Text File Header Record
Return to File Formats & Field Values For fixed width format, the total header record length is 1250 bytes. For Excel/text tab delimited format, the total header record length is eight columns. All fields in the header record are required. Excel Column Field Name Characters Bytes Format Description A Record […]