{"id":50,"date":"2021-02-10T22:20:17","date_gmt":"2021-02-10T22:20:17","guid":{"rendered":"https:\/\/pubproof.studentclearinghouse.org\/kbsandbox\/?p=50"},"modified":"2025-06-09T09:57:47","modified_gmt":"2025-06-09T13:57:47","slug":"formatting-the-column-header-record","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-column-header-record\/","title":{"rendered":"Formatting the Column Header Record"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">CONTENTS<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-column-header-record\/#Sample_Column_Header_Record\" >Sample Column Header Record<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-column-header-record\/#Sample_Version_20_Column_Header_Records\" >Sample Version 2.0 Column Header Records<\/a><\/li><\/ul><\/nav><\/div>\n<p>Every data file must include a column header record containing the column headings for the fields in the data file. The column headings are different for each data file type. The field values are included in the detail records. See <strong>Detail Records<\/strong> below for details.<\/p>\n<p>List the column headings separated by commas as follows:<\/p>\n<div class=\"code\" style=\"margin-bottom: 30px;\"><code>Column 1,Column 2,Column 3,Column 4,Column 5,Column 6<\/code><\/div>\n<p>You <strong><u>must<\/u><\/strong> include the<em> CH1<\/em> header as the first field in the column header record. You can include the rest of the headers in any order, but <strong><u>they must match the order of the detail records<\/u><\/strong>. The detail records include the values that appear in the columns under the headers. The values must match the column headers.<\/p>\n<p><strong>If you are submitting any of the version 2.0<\/strong><strong>\u00a0data elements, you must include all of the version 2.0 variables in the column header record.<\/strong> See <strong>Optional Version 2.0<\/strong>\u00a0Data Elements for details.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sample_Column_Header_Record\"><\/span>Sample Column Header Record<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"code\" style=\"margin-bottom: 30px;\"><code>CH1,Cohort,Cohort Term,Cohort Term Begin Date,Cohort Term End Date,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Street Line 1,Street Line 2,City,State,Zip\/Postal Code,Country,Date of Birth,Ethnicity,Race,Institution ID Type,Institution ID,HS Completion Status,HS Completion Year,HS Unweighted GPA,HS Weighted GPA,First Gen,Dual and Summer Enrollment,Enrollment Type,Number of College Credits Attempted to Transfer,Number of College Transfer Credits Accepted,Math Placement,English Placement,Gateway Math Status,Gateway English Status<\/code><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Sample_Version_20_Column_Header_Records\"><\/span>Sample Version 2.0 Column Header Records<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Below is a sample column header record for a cohort data file that includes Version 2.0 data elements.<\/p>\n<div class=\"code\" style=\"margin-bottom: 30px;\"><code>CH1,Cohort,Cohort Term,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Street Line 1,Street Line 2,City,State,Zip\/Postal Code,Country,Date of Birth,Ethnicity,Race,Institution ID Type,Institution ID,HS Completion Status,HS Completion Year,HS Unweighted GPA,HS Weighted GPA,First Gen,Dual and Summer Enrollment,Enrollment Type,Number of College Credits Attempted to Transfer,Number of College Transfer Credits Accepted,Math Placement,English Placement,Gateway Math Status,Gateway English Status,Cohort Term Begin Date,Cohort Term End Date,Reading Placement,Special Program,NASPA First-Generation,Gender,Incarcerated Status,Military Status,Employment Status,Disability Status<\/code><\/div>\n<p>Below is a sample column header record for a course data file that includes Version 2.0 data elements.<\/p>\n<div class=\"code\" style=\"margin-bottom: 30px;\"><code>CH1,Cohort,Cohort Term,Academic Year,Term,Institution ID Type,Institution ID,SSN,ITIN,Student ID,First Name,Middle Name,Last Name,Suffix,Current Street 1,Current Street 2,Current City,Current State,Current Zip\/Postal Code,Current Country,Date of Birth,Student Phone Number,Pell Recipient,Student Email,CompleteDevMath,CompleteDevEnglish,TransferIntent,Degree Type Sought,Semester\/Session GPA,Overall GPA,Course Name,Course Number,Section ID,Course Prefix,Course Description,Course CIP,Course Type,MathOrEnglishGateway,Co-requisite Course,Course Begin Date,Course End Date,Grade,Number of Credits Attempted,Number of Credits Earned,Delivery Method,Core Course,Core Course Type,Core Competency Completed,Total Combined Earned and Transferred Credits,Purpose of Course Exchange,Certification Endorsed Curriculum\/Program,Certificate Endorsing Industry,Grade Effective Date,DGI Institution ID Type,DGI Institution ID,DGI Student ID,Credential Engine Identifier,Course Instructor Employment Status,Course Instructor Rank,Foreign Language Completion<\/code><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn about the column header record and column headings for the fields in the data file and see samples.<\/p>\n","protected":false},"author":6,"menu_order":76,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[50,78],"ht-kb-tag":[],"class_list":["post-50","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-creating-data-files","ht_kb_category-institutional-researchers"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/comments?post=50"}],"version-history":[{"count":12,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/50\/revisions"}],"predecessor-version":[{"id":16546,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/50\/revisions\/16546"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=50"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=50"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}