{"id":62,"date":"2021-02-10T23:25:47","date_gmt":"2021-02-10T23:25:47","guid":{"rendered":"https:\/\/pubproof.studentclearinghouse.org\/kbsandbox\/?p=62"},"modified":"2025-06-09T11:51:09","modified_gmt":"2025-06-09T15:51:09","slug":"formatting-the-detail-records","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-detail-records\/","title":{"rendered":"Formatting the Detail Records"},"content":{"rendered":"<p>The detail records contain the field values in the data files. The fields are different for each data file type. Every data file must include at least one detail record.<\/p>\n<p>List the detail records after the column header record. Enter one comma-delimited detail record per line. See the following tables for details for each data file type.<\/p>\n<p>You <strong><u>must<\/u><\/strong> include the <em>CH1<\/em> (record type) variable as the first field in each detail record. You can include the rest of the variables in any order, but <strong><u>they must match the order of the column headers in the column header record<\/u><\/strong>. We recommend following the orders listed in the tables below.<\/p>\n<ul>\n<li><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-cohort-file-detail-records\/\">Formatting the Cohort File Detail Records<\/a><\/li>\n<li><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-course-file-detail-records\/\">Formatting the Course File Detail Records<\/a><\/li>\n<li><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-financial-aid-file-detail-records\/\">Formatting the Financial Aid File Detail Records<\/a><\/li>\n<\/ul>\n<h2>Required Values<\/h2>\n<p>Values are either required, not required, or required based on certain conditions. For any values that are not required, you may either populate the fields or leave them blank.<\/p>\n<div class=\"info\">\n<p>Do not enter NULL in any detail record field. If there are any required values that you do not have available and for which there are no \u201cnot applicable,\u201d \u201cunknown,\u201d or \u201cmissing\u201d accepted values listed in the table, email <a href=\"mailto:PDPService@studentclearinghouse.org\">PDPService@studentclearinghouse.org<\/a> for assistance.<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn about the detail records which contain the field values in the data files.<\/p>\n","protected":false},"author":6,"menu_order":91,"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-62","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\/62","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=62"}],"version-history":[{"count":8,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/62\/revisions"}],"predecessor-version":[{"id":16593,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/62\/revisions\/16593"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=62"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}