{"id":9300,"date":"2023-07-03T19:20:44","date_gmt":"2023-07-03T23:20:44","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/?post_type=ht_kb&#038;p=9300"},"modified":"2026-10-22T12:47:57","modified_gmt":"2026-10-22T16:47:57","slug":"excel-text-file-trailer-record","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/excel-text-file-trailer-record\/","title":{"rendered":"Excel\/Text File Trailer Record"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a class=\"heroickb_exit_link\" href=\"?hkb-redirect&#038;nonce=cf94397aa5&#038;check=7ckbr&#038;redirect=https%3A%2F%2Fhelp.studentclearinghouse.org%2Fcompliancecentral%2Fknowledge-base%2Ffile-formats-and-field-values%2F&#038;otype=unknown&#038;oid=0&#038;source=block-content\">Return to File Formats &amp; Field Values<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<p class=\"wp-block-hb-message is-style-info wp-block-paragraph\"><strong class=\"message-label\">Information:<\/strong> All fields in the trailer record are required.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>Excel Column<\/strong><\/th><th><strong>Field Name<\/strong><\/th><th><strong>Characters<\/strong><\/th><th><strong>Bytes<\/strong><\/th><th><strong>Format<\/strong><\/th><th><strong>Description<\/strong><\/th><\/tr><\/thead><tbody><tr><td>A<\/td><td>Record Type<\/td><td>2<\/td><td>01-02<\/td><td>Alphanumeric<\/td><td><em>T1<\/em><\/td><\/tr><tr><td>B<\/td><td>Number of &#8220;F&#8221;<\/td><td>6<\/td><td>03-08<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>F<\/em><\/td><\/tr><tr><td>C<\/td><td>Number of &#8220;Q&#8221;<\/td><td>6<\/td><td>09-14<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>Q<\/em><\/td><\/tr><tr><td>D<\/td><td>Number of &#8220;H&#8221;<\/td><td>6<\/td><td>15-20<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>H<\/em><\/td><\/tr><tr><td>E<\/td><td>Number of &#8220;L&#8221;<\/td><td>6<\/td><td>21-26<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>L<\/em><\/td><\/tr><tr><td>F<\/td><td>Number of &#8220;W&#8221;<\/td><td>6<\/td><td>27-32<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>W<\/em><\/td><\/tr><tr><td>G<\/td><td>Number of &#8220;G&#8221;<\/td><td>6<\/td><td>33-38<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>G<\/em><\/td><\/tr><tr><td>H<\/td><td>Number of &#8220;A&#8221;<\/td><td>6<\/td><td>39-44<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>A<\/em><\/td><\/tr><tr><td>I<\/td><td>Number of &#8220;X&#8221;<\/td><td>6<\/td><td>45-50<\/td><td>Number<\/td><td>Filled with zeros (not currently used at campus level)<\/td><\/tr><tr><td>J<\/td><td>Number of &#8220;D&#8221;<\/td><td>6<\/td><td>51-56<\/td><td>Number<\/td><td>Number of records where campus level enrollment status = <em>D<\/em><\/td><\/tr><tr><td>K<\/td><td>Total Record&nbsp; Count<\/td><td>8<\/td><td>57-64<\/td><td>Number<\/td><td>Number of student detail records plus two (including the header and trailer records)<\/td><\/tr><tr><td>L<\/td><td>Filler<\/td><td>1186<\/td><td>65-1250<\/td><td>Alphanumeric<\/td><td>Filler<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><a class=\"heroickb_exit_link\" href=\"?hkb-redirect&#038;nonce=cf94397aa5&#038;check=7ckbr&#038;redirect=https%3A%2F%2Fhelp.studentclearinghouse.org%2Fcompliancecentral%2Fknowledge-base%2Ffile-formats-and-field-values%2F&#038;otype=unknown&#038;oid=0&#038;source=block-content\">Return to File Formats &amp; Field Values<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Return to File Formats &amp; 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. Information: All fields in the trailer record are required. Excel Column Field Name Characters Bytes Format Description A&#8230;<\/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-9300","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\/9300","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=9300"}],"version-history":[{"count":10,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9300\/revisions"}],"predecessor-version":[{"id":12028,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9300\/revisions\/12028"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/media?parent=9300"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-category?post=9300"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-tag?post=9300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}