{"id":9566,"date":"2023-07-13T14:01:21","date_gmt":"2023-07-13T18:01:21","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/?post_type=ht_kb&p=9566"},"modified":"2026-10-22T12:40:09","modified_gmt":"2026-10-22T16:40:09","slug":"edi-file-mapping","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/edi-file-mapping\/","title":{"rendered":"Electronic Data Interchange (EDI) File Mapping"},"content":{"rendered":"\n

Return to File Formats & Field Values<\/a><\/p>\n\n\n\n

Note:<\/strong> Download EDI File Mapping for Data Elements<\/strong><\/a> for details on mapping A3 data elements to Excel\/text file fields.<\/p>\n\n\n\n

The tables below outline how EDI file fields map to Excel\/text file fields.<\/p>\n\n\n\n

Header Record<\/h2>\n\n\n\n
Excel\/Text Field<\/strong><\/th>EDI Field(s)<\/strong><\/th><\/tr><\/thead>
Record Type<\/td>N\/A<\/td><\/tr>
School Code<\/td>ENT03, ENT04, ENT05<\/td><\/tr>
Branch Code<\/td>ENT03, ENT04, ENT05<\/td><\/tr>
Academic Term<\/td>ENT08, ENT09<\/td><\/tr>
Compulsory Term Flag<\/td>ENR11<\/td><\/tr>
Certification Date<\/td>ENR12, ENR13<\/td><\/tr>
Filler<\/td>N\/A<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Detail Records<\/h2>\n\n\n\n
Excel\/Text Field<\/strong><\/th>EDI Field(s)<\/strong><\/th><\/tr><\/thead>
Record Type<\/td>N\/A<\/td><\/tr>
Student SSN<\/td>ENT03, ENT04<\/td><\/tr>
First Name<\/td>IN201, IN202<\/td><\/tr>
Middle Initial<\/td>IN201, IN202<\/td><\/tr>
Last Name<\/td>IN201, IN202<\/td><\/tr>
Name Suffix<\/td>IN201, IN202<\/td><\/tr>
Previous SSN<\/td>ENT06, ENT07<\/td><\/tr>
Previous Last Name<\/td>IN201, IN202<\/td><\/tr>
Enrollment Status (campus-level)<\/td>ENR01<\/td><\/tr>
Status Start Date<\/td>DTP01, DTP02, DTP03<\/td><\/tr>
Street Line 1<\/td>N301<\/td><\/tr>
Street Line 2<\/td>N302<\/td><\/tr>
City<\/td>N401<\/td><\/tr>
State<\/td>N402<\/td><\/tr>
Country<\/td>N404<\/td><\/tr>
Anticipated Graduation Date<\/td>ENR03, ENR04<\/td><\/tr>
Birth Date<\/td>DMG01, DMG02<\/td><\/tr>
Term Begin Date<\/td>DTP01, DTP02, DTP03<\/td><\/tr>
Term End Date<\/td>DTP01, DTP02, DTP03<\/td><\/tr>
Filler<\/td>N\/A<\/td><\/tr>
Directory Block Indicator<\/td>ENR10<\/td><\/tr>
NCES CIP Code for Major 1<\/td>FOS01, FOS02, FOS03<\/td><\/tr>
NCES CIP Code for Major 2<\/td>FOS01, FOS02, FOS03<\/td><\/tr>
Major Course of Study 1<\/td>FOS04<\/td><\/tr>
Major Course of Study 2<\/td>FOS04<\/td><\/tr>
Class<\/td>SES10<\/td><\/tr>
First Time Full Time<\/td>ENR19<\/td><\/tr>
Degree Seeking<\/td>ENR09<\/td><\/tr>
High School Code<\/td>ENT01, ENT02, ENT03, ENT04 (Loop 4)<\/td><\/tr>
Gender<\/td>DMG03<\/td><\/tr>
Race\/Ethnicity<\/td>DMG05<\/td><\/tr>
College Student ID<\/td>ENT01, ENT02, ENT03, ENT04 (Loop 3)<\/td><\/tr>
State Student ID<\/td>ENT05, ENT06, ENT07 (Loop 3)<\/td><\/tr>
Email<\/td>PER01, PER03, PER04<\/td><\/tr>
Good Student<\/td>ENR20<\/td><\/tr>
Middle Name<\/td>IN201, IN202<\/td><\/tr>
Filler<\/td>N\/A<\/td><\/tr>
Veteran’s Status Indicator<\/td>NTE02<\/td><\/tr>
Commit ID<\/td>NTE02<\/td><\/tr>
Pell Grant Recipient<\/td>SUM10<\/td><\/tr>
Remedial Flag<\/td>SUM02<\/td><\/tr>
Citizenship Flag<\/td>DMG06<\/td><\/tr>
Student Phone Type<\/td>PER05<\/td><\/tr>
Preferred Phone Flag<\/td>PER09<\/td><\/tr>
Student Phone Country Code<\/td>PER06<\/td><\/tr>
Student Phone Number<\/td>PER08<\/td><\/tr>
Move To OPEID<\/td>ENT04<\/td><\/tr>
Program Indicator<\/td>SUM03<\/td><\/tr>
Program 1 CIP Code<\/td>FOS03<\/td><\/tr>
Program 1 CIP Year<\/td>FOS04<\/td><\/tr>
Program 1 Credential Level<\/td>SES10<\/td><\/tr>
Program 1 Published Program 1 Length<\/td>FOS06<\/td><\/tr>
Program 1 Published Program Length Measurement<\/td>FOS05<\/td><\/tr>
Program 1 Weeks Title IV Academic Year<\/td>FOS07<\/td><\/tr>
Program 1 Begin Date<\/td>ENR04<\/td><\/tr>
Program 1 Special Program Indicator<\/td>NTE02<\/td><\/tr>
Program 1 Enrollment Status<\/td>ENR01<\/td><\/tr>
Program 1 Enrollment Status Effective Date<\/td>ENR13<\/td><\/tr>
Program 2 CIP Code<\/td>FOS03<\/td><\/tr>
Program 2 CIP Year<\/td>FOS04<\/td><\/tr>
Program 2 Credential Level<\/td>SES10<\/td><\/tr>
Program 2 Published Program Length<\/td>FOS06<\/td><\/tr>
Program 2 Published Program Length Measurement<\/td>FOS05<\/td><\/tr>
Program 2 Weeks Title IV Academic Year<\/td>FOS07<\/td><\/tr>
Program 2 Begin Date<\/td>ENR04<\/td><\/tr>
Program 2 Special Program Indicator<\/td>NTE02<\/td><\/tr>
Program 2 Enrollment Status<\/td>ENR01<\/td><\/tr>
Program 2 Enrollment Status Effective Date<\/td>ENR13<\/td><\/tr>
Program 3 CIP Code<\/td>FOS03<\/td><\/tr>
Program 3 CIP Year<\/td>FOS04<\/td><\/tr>
Program 3 Credential Level<\/td>SES10<\/td><\/tr>
Program 3 Published Program Length<\/td>FOS06<\/td><\/tr>
Program 3 Published Program Length Measurement<\/td>FOS05<\/td><\/tr>
Program 3 Weeks Title IV Academic Year<\/td>FOS07<\/td><\/tr>
Program 3 Begin Date<\/td>ENR04<\/td><\/tr>
Program 3 Special Program Indicator<\/td>NTE02<\/td><\/tr>
Program 3 Enrollment Status<\/td>ENR01<\/td><\/tr>
Program 3 Enrollment Status Effective Date<\/td>ENR13<\/td><\/tr>
Program 4 CIP Code<\/td>FOS03<\/td><\/tr>
Program 4 CIP Year<\/td>FOS04<\/td><\/tr>
Program 4 Credential Level<\/td>SES10<\/td><\/tr>
Program 4 Published Program Length<\/td>FOS06<\/td><\/tr>
Program 4 Published Program Length Measurement<\/td>FOS05<\/td><\/tr>
Program 4 Weeks Title IV Academic Year<\/td>FOS07<\/td><\/tr>
Program 4 Begin Date<\/td>ENR04<\/td><\/tr>
Program 4 Special Program Indicator<\/td>NTE02<\/td><\/tr>
Program 4 Enrollment Status<\/td>ENR01<\/td><\/tr>
Program 4 Enrollment Status Effective Date<\/td>ENR13<\/td><\/tr>
Program 5 CIP Code<\/td>FOS03<\/td><\/tr>
Program 5 CIP Year<\/td>FOS04<\/td><\/tr>
Program 5 Credential Level<\/td>SES10<\/td><\/tr>
Program 5 Published Program Length<\/td>FOS06<\/td><\/tr>
Program 5 Published Program Length Measurement<\/td>FOS05<\/td><\/tr>
Program 5 Weeks Title IV Academic Year<\/td>FOS07<\/td><\/tr>
Program 5 Begin Date<\/td>ENR04<\/td><\/tr>
Program 5 Special Program Indicator<\/td>NTE02<\/td><\/tr>
Program 5 Enrollment Status<\/td>ENR01<\/td><\/tr>
Program 5 Enrollment Status Effective Date<\/td>ENR13<\/td><\/tr>
Program 6 CIP Code<\/td>FOS03<\/td><\/tr>
Program 6 CIP Year<\/td>FOS04<\/td><\/tr>
Program 6 Credential Level<\/td>SES10<\/td><\/tr>
Program 6 Published Program Length<\/td>FOS06<\/td><\/tr>
Program 6 Published Program Length Measurement<\/td>FOS05<\/td><\/tr>
Program 6 Weeks Title IV Academic Year<\/td>FOS07<\/td><\/tr>
Program 6 Begin Date<\/td>ENR04<\/td><\/tr>
Program 6 Special Program Indicator<\/td>NTE02<\/td><\/tr>
Program 6 Enrollment Status<\/td>ENR01<\/td><\/tr>
Program 6 Enrollment Status Effective Date<\/td>ENR13<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Trailer Record<\/h2>\n\n\n\n

No Excel\/text file trailer record fields are required for EDI implementation.<\/p>\n\n\n\n

Return to File Formats & Field Values<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Return to File Formats & Field Values Note: 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…<\/p>\n","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[135],"ht-kb-tag":[],"class_list":["post-9566","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-file-formats-and-field-values"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/comments?post=9566"}],"version-history":[{"count":23,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9566\/revisions"}],"predecessor-version":[{"id":12019,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9566\/revisions\/12019"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/media?parent=9566"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-category?post=9566"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-tag?post=9566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}