{"id":1288,"date":"2026-01-23T08:08:18","date_gmt":"2026-01-23T08:08:18","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/reversetransfer\/knowledge-base\/host-reverse-transfer-course-detail-file-body-record-layout\/"},"modified":"2026-03-18T18:03:35","modified_gmt":"2026-03-18T18:03:35","slug":"host-trailer-record-layout","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/host-trailer-record-layout\/","title":{"rendered":"Host Reverse Transfer Course Detail File: Trailer Record Layout"},"content":{"rendered":"\n
Field<\/strong> Name<\/strong><\/th>Required Field<\/strong><\/th>Length<\/strong><\/th>Start<\/strong><\/th>Stop<\/strong><\/th>Type<\/strong><\/th>Comments<\/strong><\/th><\/tr><\/thead>
Record Type<\/td>Yes<\/td>4<\/td>01<\/td>04<\/td>Alphanumeric<\/td>Must be RTT1
(RT=Application Type, T=Trailer Record, 1=Row of detail record)<\/td><\/tr>
Total Record Count<\/td>Yes<\/td>No limit<\/td>04<\/td>11<\/td>Numeric<\/td>Total count equals the number of detail records plus two (the header and trailer records are included in the total).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Noteworthy Information<\/h2>\n\n\n\n
    \n
  • The trailer record should be the last row in the file with no blank spaces, etc.<\/li>\n\n\n\n
  • Alpha = alphabetic characters only<\/li>\n\n\n\n
  • Numeric = numbers only<\/li>\n\n\n\n
  • Alphanumeric = alphabetic characters and numbers<\/li>\n\n\n\n
  • Char = alphabetic characters, numbers, and special characters, such as the hyphen, underscore, ampersand, exclamation point, etc.<\/li>\n<\/ul>\n\n\n\n

    Examples<\/h2>\n\n\n\n

    Trailer Record from Host:<\/h3>\n\n\n\n
    RTCD1|003658|00|20150316|AllgoodclientFileID
    \nRTD1|5116542|123123321|987654335|studentone|A|Babuone|Jr.|19850919|STAR1 Ln|Apt# 1|Washington|DC|20001|US|1234567890|student1@nsc.org|Y|60||||BIO|102a|BIOLOGY102|Fall|20130901
    \n|20170901|A|20130901|3|test|y|abcefgh|100|3.5|3.7|011145|7100003|||||
    \nRTD1|5116543|123123322|987654336|studenttwo|A|Babutwo|Jr.|19850919|STAR2 Ln|Apt# 2|Washington|DC|20001|US|1234567890|student2@nsc.org|y|50||||BIO|101b|BIOLOGY 102|Fall|20130901|20170901|A|20130901|3|test|Y|xyz|200|3.1|3.7|011145|7100004|||||
    \nRTD1|5116544|123123323|987654337|studentthree|A|Babuthree|Jr.|19850919|STAR3 Ln|Apt# 3|Washington|DC|20001|US|1234567890|student3@nsc.org|N|54||||bio|101|BIOLOGY 102|Fall|20130901|20170901|A|20130901|3|test|N|pqr|100|3.0|3.9|011145|7100005|||||
    \nRTD1|5116545|123123324|987654338|studentfour|A|Babufour|Jr.|19850919|STAR4 Ln|Apt# 4|Washington|DC|20001|US|1234567890|student4@nsc.org|y|56||||BIO|101|BIO 102|Fall|20131001|20170901|b|20131002|3|test|Y|abc|123|2.5|3.0|011145|7100006|||||
    \nRTD1|5116546|123123325|987654339|studentfive|A|Babufive|Jr.|19850919|STAR5 Ln|Apt# 5|Washington|DC|20001|US|1234567890|student5@nsc.org|n|40||||BIO|101|BIOLOGY 102|Fall|20130901|20170901|a+|20130901|3|test|N|123|123|1.5|2.0|011145|7100007|||||
    \nRTD1|5116547|123123326|987654340|studentsix|A|Babusix|Jr.|19850919|STAR6 Ln|Apt# 6|Washington|DC|20001|US|1234567890|student6@nsc.org|Y|66||||math adv|101|BIOLOGY 102|Fall|20130901|20170910|a|20130901|3|test|y|course type 1|100|3.9|3.5|011145|7100008|||||
    \nRTD1|5116548|123123327|987654341|studentseven|A|Babuseven|Jr.|19850919|STAR7 Ln|Apt# 7|Washington|DC|20001|US|1234567890|student7@nsc.org|N|60||||BIO|101|BIOLOGY
    \n102|Fall|20130901|20170901|A|20130910|3|test|n|course type 2|300|4.0|4.0|011145|7100009||||| RTT1|9<\/code><\/pre>\n\n\n\n
    Example of a Trailer Record from System of Institution Host:<\/h3>\n\n\n\n
    RTCD1|SI1234<\/strong><\/span>|00|20150316|AllgoodclientFileID
    \nRTD1|5116542|123123321|987654335|studentone|A|Babuone|Jr.|19850919|STAR1 Ln|Apt# 1|Washington|DC|20001|US|1234567890|student1@nsc.org|Y|60|||999999<\/strong><\/span>|BIO|102a|BIOLOGY102|Fall|20
    \n130901|20170901|A|20130901|3|test|y|abcefgh|100|3.5|3.7|011145|7100003|||||
    \nRTD1|5116543|123123322|987654336|studenttwo|A|Babutwo|Jr.|19850919|STAR2 Ln|Apt# 2|Washington|DC|20001|US|1234567890|student2@nsc.org|y|50|||999999<\/strong><\/span>|BIO|101b|BIOLOGY
    \n102|Fall|20130901|20170901|A|20130901|3|test|Y|xyz|200|3.1|3.7|011145|7100004|||||
    \nRTD1|5116544|123123323|987654337|studentthree|A|Babuthree|Jr.|19850919|STAR3 Ln|Apt# 3|Washington|DC|20001|US|1234567890|student3@nsc.org|N|54|||999999<\/strong><\/span>|bio|101|BIOLOGY 102|Fall|20130901|20170901|A|20130901|3|test|N|pqr|100|3.0|3.9|011145|7100005|||||
    \nRTD1|5116545|123123324|987654338|studentfour|A|Babufour|Jr.|19850919|STAR4 Ln|Apt# 4|Washington|DC|20001|US|1234567890|student4@nsc.org|y|56|||999999<\/strong><\/span>|BIO|101|BIO
    \n102|Fall|20131001|20170901|b|20131002|3|test|Y|abc|123|2.5|3.0|011145|7100006|||||
    \nRTD1|5116546|123123325|987654339|studentfive|A|Babufive|Jr.|19850919|STAR5 Ln|Apt# 5|Washington|DC|20001|US|1234567890|student5@nsc.org|n|40|||999999<\/strong><\/span>|BIO|101|BIOLOGY
    \n102|Fall|20130901|20170901|a+|20130901|3|test|N|123|123|1.5|2.0|011145|7100007|||||
    \nRTD1|5116547|123123326|987654340|studentsix|A|Babusix|Jr.|19850919|STAR6 Ln|Apt# 6|Washington|DC|20001|US|1234567890|student6@nsc.org|Y|66|||999999<\/strong><\/span>|math adv|101|BIOLOGY 102|Fall|20130901|20170910|a|20130901|3|test|y|course type 1|100|3.9|3.5|011145|7100008|||||
    \nRTD1|5116548|123123327|987654341|studentseven|A|Babuseven|Jr.|19850919|STAR7 Ln|Apt# 7|Washington|DC|20001|US|1234567890|student7@nsc.org|N|60|||999999<\/strong><\/span>|BIO|101|BIOLOGY
    \n102|Fall|20130901|20170901|A|20130910|3|test|n|course type 2|300|4.0|4.0|011145|7100009||||| RTT1|9
    \n<\/code><\/pre>\n\n\n\n
    Systems are required to submit their Host OPEID (see highlighted text above).<\/p>\n\n\n\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    Guidance on the host file trailer record layout for Reverse Transfer data files.<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[83],"ht-kb-tag":[79,23,88,91,93,81],"class_list":["post-1288","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-host-reverse-transfer-course-detail-file","ht_kb_tag-data-files","ht_kb_tag-formatting","ht_kb_tag-host-file","ht_kb_tag-layout","ht_kb_tag-trailer-record","ht_kb_tag-transmitting"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/comments?post=1288"}],"version-history":[{"count":5,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1288\/revisions"}],"predecessor-version":[{"id":3041,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1288\/revisions\/3041"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/media?parent=1288"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb-category?post=1288"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb-tag?post=1288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}