{"id":42,"date":"2021-02-10T22:06:43","date_gmt":"2021-02-10T22:06:43","guid":{"rendered":"https:\/\/pubproof.studentclearinghouse.org\/kbsandbox\/?p=42"},"modified":"2025-06-06T09:54:50","modified_gmt":"2025-06-06T13:54:50","slug":"formatting-the-trailer-record","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/formatting-the-trailer-record\/","title":{"rendered":"Formatting the Trailer Record"},"content":{"rendered":"<p>You must include all of the following fields in the trailer record for each data file. All fields are required.<\/p>\n<table style=\"border-style: solid; border-color: #BDD6EE;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tr>\n<th width=\"48\"><strong>#<\/strong><\/th>\n<th width=\"120\"><strong>Variable<\/strong><\/th>\n<th width=\"552\"><strong>Value<\/strong><\/th>\n<\/tr>\n<tr>\n<td width=\"48\"><strong>1<\/strong><\/td>\n<td width=\"120\">Record Type<\/td>\n<td width=\"552\">Indicates the type of record. Must be the first field in the record. Enter <em>T1<\/em> for the trailer record.<\/td>\n<\/tr>\n<tr>\n<td width=\"48\"><strong>2<\/strong><\/td>\n<td width=\"120\">Total Record Count<\/td>\n<td width=\"552\">The total number of records in the file, including the header, column header, and trailer records (number of detail records + 3). For example, if you submit 60 detail records in a data file, the <em>Total Record Count<\/em> for that file would be 63.<\/td>\n<\/tr>\n<tr>\n<td width=\"48\"><strong>3<\/strong><\/td>\n<td style=\"background-color: #f2f2f2; width: 120px;\">Filler Field<\/td>\n<td style=\"background-color: #f2f2f2; width: 552px;\">Leave blank.<\/td>\n<\/tr>\n<\/table>\n<p>&nbsp;<\/p>\n<h2>Sample Trailer Record<\/h2>\n<div class=\"code\"><code>T1,63,<\/code><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn about the fields that must be included in the trailer record for each data file and see a sample.<\/p>\n","protected":false},"author":6,"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-42","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\/42","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=42"}],"version-history":[{"count":5,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/42\/revisions"}],"predecessor-version":[{"id":16420,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/42\/revisions\/16420"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=42"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}