{"id":9202,"date":"2023-06-29T11:22:59","date_gmt":"2023-06-29T15:22:59","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/?post_type=ht_kb&p=9202"},"modified":"2026-10-22T12:49:44","modified_gmt":"2026-10-22T16:49:44","slug":"excel-text-file-header-record","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/knowledge-base\/excel-text-file-header-record\/","title":{"rendered":"Excel\/Text File Header Record"},"content":{"rendered":"\n

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

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.<\/p>\n\n\n\n

Information:<\/strong> All fields in the header record are required.<\/p>\n\n\n\n

Excel Column<\/strong>\n<\/th>Field Name<\/strong>\n<\/th>Characters<\/strong>\n<\/th>Bytes<\/strong>\n<\/th>Format<\/strong>\n<\/th>Description<\/strong>\n<\/th><\/tr><\/thead>
A<\/td>Record Type<\/td>2<\/td>01-02<\/td>Alphanumeric<\/td>Type of report.

<\/p>\n

    \n
  • A3<\/em> = Enrollment data<\/li>\n
  • P3<\/em> = Advanced registration data<\/li>\n<\/ul>\n<\/td><\/tr>
B<\/td>School Code<\/td>6<\/td>03-08<\/td>Number<\/td>Department of Education FICE code (OPEID)<\/td><\/tr>
C<\/td>Branch Code<\/td>2<\/td>09-10<\/td>Number<\/td>School branch code suffix. 00<\/em> if none.<\/em><\/em><\/td><\/tr>
D<\/td>Academic Term<\/td>15<\/td>11-25<\/td>Alphanumeric<\/td>Your institution’s name for the academic term you’re reporting (e.g. Fall 2023, 1st Quarter 2024,<\/em> or 1st Semester<\/em> 2024<\/em>).<\/td><\/tr>
E<\/td>Standard Report Flag<\/td>1<\/td>26<\/td>Y\/N<\/em><\/td>Whether the report is a standard report.

<\/p>\n

    \n
  • Y<\/em> = Standard report with no special handling<\/li>\n
  • N<\/em> = Non-standard report (e.g. early registration, summer term, graduates only, or advanced registration)<\/li>\n<\/ul>\n<\/td><\/tr>
F<\/td>Certification Date<\/td>8<\/td>27-34<\/td>Date (YYYYMMDD<\/em>)<\/td>Date your institution certified the enrollment data.<\/td><\/tr>
G<\/td>Reporting Level<\/td>1<\/td>35<\/td>Letter<\/td>Level of report.

<\/p>\n

    \n
  • F<\/em> = Full reporting<\/li>\n
  • A<\/em> = Add records (advanced registration only)<\/li>\n<\/ul>\n<\/td><\/tr>
H<\/td>Filler<\/td>1215<\/td>36-1250<\/td>Alphanumeric<\/td>Blank in Excel; filled with spaces in fixed width format.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

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. Information: All fields in the header record are required. Excel Column Field Name Characters Bytes Format Description A…<\/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-9202","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\/9202","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=9202"}],"version-history":[{"count":32,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9202\/revisions"}],"predecessor-version":[{"id":12030,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb\/9202\/revisions\/12030"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/media?parent=9202"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-category?post=9202"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/compliancecentral\/wp-json\/wp\/v2\/ht-kb-tag?post=9202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}