{"id":10072,"date":"2023-09-08T16:23:24","date_gmt":"2023-09-08T20:23:24","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/?post_type=ht_kb&#038;p=10072"},"modified":"2026-10-22T12:15:06","modified_gmt":"2026-10-22T16:15:06","slug":"file-formats-and-field-values","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/file-formats-and-field-values\/","title":{"rendered":"File Formats &#038; Field Values"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Review the file formats, field descriptions, and accepted values for Excel\/text files and electronic data interchange (EDI) files.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-f56f613f wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\" style=\"font-style:normal;font-weight:600\"><span style=\"font-size: 29px;\"><span style=\"font-size: 29px;\">Excel\/Text Files<\/span><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/excel-text-file-format\/\">Excel\/Text File Format<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/excel-text-file-header-record\/\">Header Record<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/excel-text-file-detail-records\/\">Detail Records<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/excel-text-file-trailer-record\/\">Trailer Record<\/a><\/span><\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\" style=\"font-style:normal;font-weight:600\"><span style=\"font-size: 29px;\">EDI Files<\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/edi-file-format\/\">EDI File Format<\/a><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/theclearinghouse.download\/edimappinga3\">EDI File Mapping<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/sample-edi-record\/\">Sample EDI Record<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/edi-file-header-segments\/\">Header Segments<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/edi-file-detail-segments\/\">Detail Segments<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/edi-file-trailer-segments\/\">Trailer Segments<\/a><\/span><\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h2 class=\"wp-block-heading\" style=\"font-style:normal;font-weight:600\"><span style=\"font-size: 29px;\"><span style=\"font-size: 29px;\">Resources<\/span><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/valid-state-codes\/\">Valid State\/Province Codes<\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-size: 16px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/valid-country-codes\/\">Valid Country Codes<\/a><\/span><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Review the file formats, field descriptions, and accepted values for Excel\/text files and electronic data interchange (EDI) files. Excel\/Text Files EDI Files Resources<\/p>\n","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[19],"ht-kb-tag":[],"class_list":["post-10072","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-enrollment-reporting-overview"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/10072","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=10072"}],"version-history":[{"count":23,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/10072\/revisions"}],"predecessor-version":[{"id":12002,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/10072\/revisions\/12002"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/media?parent=10072"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-category?post=10072"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-tag?post=10072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}