{"id":494,"date":"2021-03-04T06:54:26","date_gmt":"2021-03-04T06:54:26","guid":{"rendered":"https:\/\/pubproof.studentclearinghouse.org\/kbsandbox\/?p=494"},"modified":"2025-06-03T11:36:25","modified_gmt":"2025-06-03T15:36:25","slug":"formatting-an-update-file","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-an-update-file\/","title":{"rendered":"Formatting an Update File"},"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-an-update-file\/#Header_Record\" >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-an-update-file\/#Trailer_Record\" >Trailer Record<\/a><\/li><\/ul><\/nav><\/div>\n<p>An update data file should be formatted the same as the original file following the same guidelines outlined in <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/creating-a-data-file\/\">Creating a Data File<\/a>. However, <strong>there are key differences in the requirements for each record<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Header_Record\"><\/span>Header Record<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The header record should be the same as the header record in the original data file except for the <em>Record Type<\/em> variable, which must contain a specific value based on the type of update file:<\/p>\n<ul>\n<li>Cohort Data File = DCE11<\/li>\n<li>Term Data File = DCE12<\/li>\n<li>Course Data File = DCE13<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Trailer_Record\"><\/span>Trailer Record<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The trailer record must be the same as the original data file.<\/p>\n<h3>Detail Records<\/h3>\n<p>The detail records must be formatted the same as in the original data file and follow all of the requirements outlined in <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-a-data-file\/\">Formatting a Data File<\/a>. However, the required values are not the same as in the original file.<\/p>\n<ul>\n<li>Values that you change in the update file will be updated; however, <strong>not all values can be updated<\/strong>.<\/li>\n<li>Some values that cannot be updated are still required to match to the original data.<\/li>\n<li>Some values that were optional in the original file are required in the update file.<\/li>\n<li>Some values that were required in the original file are optional in the update file. If you submit any of these values, they will not be updated.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Although an update data file should be formatted the same as the original file, learn about the key differences in the requirements for each record.<\/p>\n","protected":false},"author":6,"menu_order":77,"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":[53,78],"ht-kb-tag":[],"class_list":["post-494","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-data-file-updates","ht_kb_category-institutional-researchers"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/494","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=494"}],"version-history":[{"count":4,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/494\/revisions"}],"predecessor-version":[{"id":16289,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/494\/revisions\/16289"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=494"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=494"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}