Field Name | Required Field | Length | Start | Stop | Type | Comments |
Record Type | Yes | 4 | 01 | 04 | Alphanumeric | Must be RTT1 (RT=Application Type, T=Trailer Record, 1=Row of detail record) |
Total Record Count | Yes | No limit | 04 | 11 | Numeric | Total count equals the number of detail records plus two (the header and trailer records are included in the total). |
Noteworthy Information
- The trailer record should be the last row in the file with no blank spaces, etc.
- Alpha = alphabetic characters only
- Numeric = numbers only
- Alphanumeric = alphabetic characters and numbers
- Char = alphabetic characters, numbers, and special characters, such as the hyphen, underscore, ampersand, exclamation point, etc.
Examples
Trailer Record from Host:
RTCD1|003658|00|20150316|AllgoodclientFileID
RTD1|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
|20170901|A|20130901|3|test|y|abcefgh|100|3.5|3.7|011145|7100003|||||
RTD1|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|||||
RTD1|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|||||
RTD1|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|||||
RTD1|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|||||
RTD1|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|||||
RTD1|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
102|Fall|20130901|20170901|A|20130910|3|test|n|course type 2|300|4.0|4.0|011145|7100009||||| RTT1|9
Example of a Trailer Record from System of Institution Host:
RTCD1|SI1234|00|20150316|AllgoodclientFileID
RTD1|5116542|123123321|987654335|studentone|A|Babuone|Jr.|19850919|STAR1 Ln|Apt# 1|Washington|DC|20001|US|1234567890|student1@nsc.org|Y|60|||999999|BIO|102a|BIOLOGY102|Fall|20
130901|20170901|A|20130901|3|test|y|abcefgh|100|3.5|3.7|011145|7100003|||||
RTD1|5116543|123123322|987654336|studenttwo|A|Babutwo|Jr.|19850919|STAR2 Ln|Apt# 2|Washington|DC|20001|US|1234567890|student2@nsc.org|y|50|||999999|BIO|101b|BIOLOGY
102|Fall|20130901|20170901|A|20130901|3|test|Y|xyz|200|3.1|3.7|011145|7100004|||||
RTD1|5116544|123123323|987654337|studentthree|A|Babuthree|Jr.|19850919|STAR3 Ln|Apt# 3|Washington|DC|20001|US|1234567890|student3@nsc.org|N|54|||999999|bio|101|BIOLOGY 102|Fall|20130901|20170901|A|20130901|3|test|N|pqr|100|3.0|3.9|011145|7100005|||||
RTD1|5116545|123123324|987654338|studentfour|A|Babufour|Jr.|19850919|STAR4 Ln|Apt# 4|Washington|DC|20001|US|1234567890|student4@nsc.org|y|56|||999999|BIO|101|BIO
102|Fall|20131001|20170901|b|20131002|3|test|Y|abc|123|2.5|3.0|011145|7100006|||||
RTD1|5116546|123123325|987654339|studentfive|A|Babufive|Jr.|19850919|STAR5 Ln|Apt# 5|Washington|DC|20001|US|1234567890|student5@nsc.org|n|40|||999999|BIO|101|BIOLOGY
102|Fall|20130901|20170901|a+|20130901|3|test|N|123|123|1.5|2.0|011145|7100007|||||
RTD1|5116547|123123326|987654340|studentsix|A|Babusix|Jr.|19850919|STAR6 Ln|Apt# 6|Washington|DC|20001|US|1234567890|student6@nsc.org|Y|66|||999999|math adv|101|BIOLOGY 102|Fall|20130901|20170910|a|20130901|3|test|y|course type 1|100|3.9|3.5|011145|7100008|||||
RTD1|5116548|123123327|987654341|studentseven|A|Babuseven|Jr.|19850919|STAR7 Ln|Apt# 7|Washington|DC|20001|US|1234567890|student7@nsc.org|N|60|||999999|BIO|101|BIOLOGY
102|Fall|20130901|20170901|A|20130910|3|test|n|course type 2|300|4.0|4.0|011145|7100009||||| RTT1|9
Systems are required to submit their Host OPEID (see highlighted text above).