Data Exchange Knowledge Base

This is intended to help Data Providers readily scan the information needed to send reverse transfer files in pipe-delimited format.

File Section 1 – Header Record

The Header Record is a single row in the file:  RTCD1|123456|00|20140924|FileName

Field 1	Field 2	Field 3	Field 4	Field 5
Required	Required	Required	Required	Required
RTCD1	OPEID	Branch Code	Date	File Name

The header record will always start with RTCD1

File Section 2 – Body Record

The Body Record is generally multiple records/rows in the file.

Example:

RTD1|7100003|123456789||John|S|Smith|Sr|19850814|12345 Somewhere Dr.||Someplace|VA|77396|US|703 999 9999|Someone@hometown.edu|Y|60|||999999|CHEM|1405|IntroChemistry|Fall2014|20140825|20141214|B|2014 1214|3|Regular Enrollment|y|Math|025|3.5|3.7|888888|12131415|||||

Systems are required to submit their Host OPEID (see highlighted text above).

Field 1	Field 2	Field 3	Field 4	Field 5	Field 6	Field 7	Field 8
Required	Required	Optional	Optional	Required	Optional	Required	Optional
Row Identifier (RTD1)	Host Student ID	SSN	ITIN	First Name	Middle Name	Last Name	Suffix

Field 9	Field 10	Field 11	Field 12	Field 13	Field 14	Field 15	Field 16
Required	Optional	Optional	Optional	Optional	Optional	Optional	Optional
Date of Birth	Street Line 1	Street Line 2	City	State	Zip Code	Country	Student Phone

Field 17	Field 18	Field 19	Field 20	Field 21	Field 22	Field 23	Field 24
Optional	Optional	Required	Optional	Optional	Required	Required	Required
Student Email	Host Core Competency Completed	Total Combined Earned Transferred Credits	Purpose Course Exchange	Industry Endorsement	Host OPEID	Course Name	Course Number

Field 25	Field 26	Field 27	Field 28	Field 29	Field 30	Field 31	Field 32
Required	Required	Required	Required	Required	Optional	Required	Optional
Course Description	Course Semester Session	Course Begin Date	Course End Date	Grade	Grade Effective Date	Number Credits	Credit Description

Field 33	Field 34	Field 35	Field 36	Field 37	Field 38	Field 39	Field 40
Optional	Optional	Required	Optional	Optional	Required	Optional	Optional
Core Course	Core Course Type	Grade Scale	Semester Session GPA	Overall GPA	DGI OPEID	DGI Student ID	Industry Provided Curriculum

Field 41	Field 42	Field 43	Field 44
[Filler Field 1]	[Filler Field 2]	[Filler Field 3]	[Filler Field 4]

The body record will always start with RTD1 for every student record in the file

If you have no data for an optional field or the filler fields, you must insert a pipe to replace the null content.

Many of the optional fields in the file are critical to the Degree-Granting Institution (DGI) in processing the students for evaluation and notification of the degree. We encourage you to submit optional fields to support your partner institutions.

File Section 3 – Trailer Record

The Trailer Record is a single row in the file:  RTT1|99

Field 1	Field 2
Required	Required
RTT1	Record Count

The trailer record will always start with RTT1.

Record count must include/count the header and trailer records.

File Naming Convention

To properly identify incoming file formats for Reverse Transfer, each file submitted must have a unique file name.

Data providers must adhere to the following file naming convention when submitting flat files: OPEID_UniqueFileName.txt

Transmitting Reverse Transfer Data

Data Providers transmit reverse transfer pipe-delimited files to the Clearinghouse via secure FTP. The Clearinghouse Implementation team will assist you in setting up an account as needed.

Resources

• Refer to other Reverse Transfer help topics
• Refer to the Secure FTP Knowledge Base
• Need more support? Email the Reverse Transfer Support Team: rtsupport@studentclearinghouse.org