{"id":1282,"date":"2026-01-24T07:53:10","date_gmt":"2026-01-24T07:53:10","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/reversetransfer\/knowledge-base\/host-reverse-transfer-course-detail-file-file-naming-convention\/"},"modified":"2026-03-18T18:04:08","modified_gmt":"2026-03-18T18:04:08","slug":"host-body-record-layout","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/host-body-record-layout\/","title":{"rendered":"Host Reverse Transfer Course Detail File: Body Record Layout"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>The file must contain at least one detail record row.<\/li>\n\n\n\n<li>There are a total of 29 possible fields that can be provided by the host institution.<\/li>\n\n\n\n<li>There are 4 filler fields that can be used for future expansion.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\"><strong>Field<\/strong> <strong>Name<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>Required Field<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>Length<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>Data Type<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>Comments\/Validation<\/strong> <strong>Rules<\/strong><\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\">Row Identifier<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">4<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alphanumeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">RTD1<br>(RT=Reverse Transfer application, D=Detail, 1=Row of detail record)<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Host Student ID<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alphanumeric<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Student ID of host institution cannot be the same number as SSN or ITIN<\/li><li>Accepted special characters = period, hyphen, underscore only<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">SSN (Social Security Number)<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">9<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot start with 9 <\/li><li>9 digits of SSN cannot be the exact same digits<\/li><li>SSN cannot be consecutive &#8220;0&#8221;<\/li><li>Any segment of SSN cannot be all &#8220;0&#8221;<\/li><li>000 12 1234 Invalid<\/li><li>120 00 1234 Invalid<\/li><li>120 34 0000 Invalid<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">ITIN (Individual Taxpayer Identification Number)<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">9<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot be the same number as student ID<\/li><li>Must start with number 9 <\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">First Name<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">60<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alpha<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot be all spaces<\/li><li>Accepted special characters = period, hyphen, underscore only<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Middle Name<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">60<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alpha<\/td><td class=\"has-text-align-left\" data-align=\"left\">Accepted special characters = period, hyphen, underscore only<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Last Name<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">60<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alpha<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot contain numbers<\/li><li>Accepted special characters = period, hyphen, underscore only<\/li><li>Cannot be all spaces<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Suffix<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">10<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alphanumeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Suffix such as &#8220;Jr&#8221;<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Date of Birth (DOB)<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">08<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Birth date formatted as YYYYMMDD<\/li><li>Must be in the past and after 1900<\/li><li>Cannot be in the future<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Street line 1<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">30<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Street address #1 of the mailing address<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Street line 2<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">30<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Street address #2 of the mailing address<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">City<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">City of the mailing address<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">State<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">02<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alpha<\/td><td class=\"has-text-align-left\" data-align=\"left\">State abbreviations or FO, if other than U.S.<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">ZIP<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">10<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Zip code of the mailing address<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Country<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">15<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Country name or country code (Country Code is preferred, a look up table will be used for country code if no country code matches a value of \u201cUS\u201d will be used.<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Student Phone Number<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">U.S. or international numbers are accepted.<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Student Email-<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">255<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li><strong>Clearinghouse will not check the validity of the email or its format<\/strong><\/li><li><strong>For response file in EDI format: Length preferred is &lt;= 80 <\/strong><\/li><li><strong>Greater than 80 char will be truncated to meet EDI requirements<\/strong><\/li> <\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Host Core Competency Completed<br>(<em>see <a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/acronyms-and-definitions\/\">Acronyms and Definitions<\/a> for further explanation<\/em>)<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">1<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alpha<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Host Core Competency Completed Flag (which means the core\/general education course has been completed as per host institutions standards\/requirements) <\/li><li>&#8216;Y&#8217; = core requirements evaluated and satisfied<\/li><li>&#8216;N&#8217; = core requirements evaluated (at least once), but not (yet) satisfied<\/li><li>&#8216; &#8216; = core requirements not (yet) evaluated<\/li><li>Expected value is Y, N or null. Anything other than Y or N will be treated as null.<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Total Combined Earned and Transferred Credits<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em><strong>Required<\/strong><\/em><strong> for<\/strong> <strong>Reverse Transfer<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">10<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Total number of credits the student has earned at your institution plus transferred earned credits. <p>For Degree Granting Institution (DGI) this is crucial piece of information in filtering students who have the highest eligibility to be reviewed for Reverse Transfer degree. The Clearinghouse will hold the data of the student to the specified number of earned credits by the DGI. The DGI will then receive cumulative data for the student.<\/p><p><strong>We <em>highly recommend<\/em> all institutions provide valid values to this field to lessen the work on the two-year institutions and decrease the time to degree for the student.<\/strong><\/p><p><strong>Must be >=1<\/strong><\/p><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Purpose of Course Exchange<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">3<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">The purpose of course exchanged valid values: <ul><li><strong>Null = Reverse Transfer<\/strong><\/li><li>1 = Reverse Transfer<\/li><li>2 = General Reporting\/Non Credit Data<\/li><\/ul><p>Course data is sent to the Clearinghouse for different purposes. This field is used to indicate if this course is being sent to the Clearinghouse for the purpose of reverse transfer, which means the course will be sent to the corresponding DGI as indicated in the DGI OPEID field.<\/p><ul><li>If an institution is sending other course data, including non-credit, to the Clearinghouse for reporting purposes, the purpose should be coded as general reporting\/non-credit.<\/li><li>If an institution is sending courses for both purposes, please indicate at the detail record level for which purpose the course is being sent to the Clearinghouse.<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Industry Endorsement<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">200<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">If a course is endorsed by an industry, list the name(s)s of the industry it is endorsed by. <p>Many institutions offer non-credit, vocational, containing courses, or industry-specific courses. This field will indicate which industry or industries the course is endorsed by.<\/p><p>For example, the course &#8220;Introduction to Welding&#8221; is endorsed by National Association of Welders.<\/p><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Host OPEID<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><br><strong><em>(if the file is being sent from an SOI)<\/em><\/strong>Individual<br>institutions sending data will not<br>provide a value for this field.<\/td><td class=\"has-text-align-left\" data-align=\"left\">6<\/td><td class=\"has-text-align-left\" data-align=\"left\">N<\/td><td class=\"has-text-align-left\" data-align=\"left\">If file is being sent by a System of Institution (SOI) then the Host OPEID must be provided. <ul><li>The Host OPEID identifies the host institution sending the data on that student (this cannot be the SOI ID).<\/li><li>Must be 6 digits<\/li><li>Must be a valid OPEID<\/li><li><strong>Must be set up as a participating organization with the System of Institutions (SOI) that is sending the file.<\/strong><\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Course Name<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">10<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Cannot be all spaces<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Course Number<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">10<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alphanumeric<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot be all spaces<\/li><li>Accepted special characters = period, hyphen, underscore only<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Course Description<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">300<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot be all spaces<\/li><li><strong>Response file in EDI format: Length preferred is &lt;= 60<\/strong><\/li><li><strong>Greater than 60 char will be truncated to meet EDI requirements<\/strong><\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Course- Semester Session<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Cannot be all spaces <\/li><li><strong>Response file in EDI format: EDI prefers a date range for this field, if no date range is provided the Course Begin Date and Course End Date will be used as a date range<\/strong><\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Course Begin Date<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">08<\/td><td class=\"has-text-align-left\" data-align=\"left\">Date<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Must be in YYYYMMDD format<\/li><li>Must be less than Course End Date<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Course End Date<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">08<\/td><td class=\"has-text-align-left\" data-align=\"left\">Date<\/td><td class=\"has-text-align-left\" data-align=\"left\"><ul><li>Must be in YYYYMMDD format<\/li><li>Must be greater than Course Begin Date<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Grade<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Grade the student earned (e.g., A, A+, A-, etc.) <ul><li>Cannot be all spaces <\/li><li><strong>Response File in EDI format: Length preferred is &lt;= <\/strong><strong>3<\/strong><\/li><li><strong>Greater than 3 char will be truncated to meet EDI requirements<\/strong><\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Grade Effective Date<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">08<\/td><td class=\"has-text-align-left\" data-align=\"left\">Date<\/td><td class=\"has-text-align-left\" data-align=\"left\">The date the grade was effective or the date the grade was entered in the system. <p>In cases where the grade is changed for a course, this will help us identify this as the same course, but with a new grade, and avoid duplicate entries of the same course.<\/p><ul><li>This is an optional field <\/li><li>Only send this in the file if your organization captures this date<\/li><li>Must be in YYYYMMDD format<\/li><li>Must be after the Course Begin Date<\/li><li>Cannot be in the future <\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Number of Credits<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">10<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Number of credits the student earned for the course <ul><li>Cannot be all spaces<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Credit Description<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional for non-EDI but a <strong>critical need<\/strong> for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Type of credit earned, such as Adult Credits, Continuing Education Units, Carnegie Units, No Credit, Quarter Hour Credit, Semester hour Credit, Units, Vocational Credits, Other Type of Credit. <ul><li><strong>For Response File in EDI format: Preferred length is &lt;= 1<\/strong><\/li><li><strong>Credit description code from the EDI list is preferred instead sending a full description. If a full description is sent, we will<\/strong> <strong>use the EDI look-<\/strong><strong>up table to find the appropriate one-letter code. <\/strong><strong>If a code is not found, we will replace this with the value of \u201cZ\u201d (which equals &#8220;Other&#8221; in the look-up table<\/strong>).<\/li><li>See the <a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/example-credit-descriptions\/\">Example Credit Descriptions <\/a>for EDI Codes and Other Type of Credits<\/li><li>SPEEDE Server institutions: The preferred value for EDI conversions is \u201cR\u201d for regular enrollment<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Core Course<br>(<em>see <a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/acronyms-and-definitions\/\">Acronyms and Definitions<\/a> for further explanation<\/em>)<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">1<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">Core Course flag indicates if a course is part of the core competency\/general education courses, as per the host institution. <p>Expected values:<span style=\"font-size: inherit; font-weight: inherit;\"> <\/span><\/p><ul><li>Y = Yes, the course is a Core Course<\/li><li>N = No, the course is not a Core Course<\/li><li>Null = core equivalency not evaluated or applicable<\/li><li>Any value other than Y, N, or null is treated as null<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Core Course Type<br>(<em>see <a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/acronyms-and-definitions\/\">Acronyms and Definitions<\/a> for further explanation<\/em>)<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">This is related to the field \u201cCore Course.\u201d If a course was flagged \u201cy,\u201d this field will be used to specify the type of core competency it maps to.\n<p>For example, the core competency for &#8220;Introduction to Art 101&#8221; maps to a Humanities requirement.<\/p>\n<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Grade Scale<\/td><td class=\"has-text-align-left\" data-align=\"left\"><em>Required<\/em><\/td><td class=\"has-text-align-left\" data-align=\"left\">3<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">The grade scale is used by DGI institutions to understand what the value of the grade is at sending Institution. <ul><li>Grade Scale ranges from 001 through 999 <\/li><li>See <a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/example-grade-scale\/\">Example Grade Scale Tables<\/a>. A value from the table must be provided. &#8220;0&#8221; is not a valid value.<\/li><li>If your grade scale is not represented in the <a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/example-grade-scale\/\">Example Grade Scale Tables<\/a>, contact <a href=\"mailto:rtsupport@studentclearinghouse.org\">rtsupport@studentclearinghouse.org <\/a>to get your grade scale added.<\/li><li>Non-Credit Courses &#8211; use the value provided for Non-Credit Courses<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Semester or Session GPA<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">5<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Student\u2019s grade point average for the Semester or Session. <ul><li>Length must be &lt;=5 <\/li><li>Allows decimal value up to 2 digits (For example -12.20)<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Overall GPA<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional but a <strong>critical need <\/strong>for 2-year<br>institutions (DGI)<\/td><td class=\"has-text-align-left\" data-align=\"left\">5<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Student&#8217;s overall grade point average <ul><li>Length must be &lt;=5<\/li><li>Allows decimal value up to 2 digits (For example -12.20)<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">DGI OPEID<\/td><td class=\"has-text-align-left\" data-align=\"left\"><strong><em>Required<\/em> if sending data for Reverse Transfer<\/strong>\n<p>Leave Null if sending<br>non-credit data<br>(Industry Credential)<\/p>\n<\/td><td class=\"has-text-align-left\" data-align=\"left\">6<\/td><td class=\"has-text-align-left\" data-align=\"left\">Numeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">OPEID of the DGI(s) with which the data can be shared. <ul><li>OPEID code (must be 6 digits)<\/li><li>Entire line record must be sent separately for each DGI with which the data will be shared<\/li><li>For example, if a student\u2019s data is being sent to more than one DGI, there will be two-line records with different OPEIDs so the course data will be repeated.<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">DGI Student ID<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">20<\/td><td class=\"has-text-align-left\" data-align=\"left\">Alphanumeric<\/td><td class=\"has-text-align-left\" data-align=\"left\">Student ID of DGI <ul><li>Cannot be the same number as SSN or ITIN <\/li><li>Accepted special characters: period, hyphen, and underscore only<\/li><\/ul><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Industry Provided Curriculum<\/td><td class=\"has-text-align-left\" data-align=\"left\">Optional<\/td><td class=\"has-text-align-left\" data-align=\"left\">200<\/td><td class=\"has-text-align-left\" data-align=\"left\">Char<\/td><td class=\"has-text-align-left\" data-align=\"left\">This field only applies if the course is part of an industry-provided curriculum. List the industry and\/or the credentialing agency the course is provided by.\n<p>For example, &#8220;Introduction to Photography&#8221; is part of the PPA (Professional Photographers Association) curriculum or OSHA is the credentialing agency for the course &#8220;Forklift One&#8221;<\/p>\n<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Filler Field 1<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">Filler field for future expansion<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Filler Field 2<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">Filler field for future expansion<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Filler Field 3<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">Filler field for future expansion<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Filler Field 4<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">N\/A<\/td><td class=\"has-text-align-left\" data-align=\"left\">Filler field for future expansion<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Noteworthy Information<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>If there are extra pipes within a field, it must be surrounded by double quotes<\/strong>.\n<ul class=\"wp-block-list\">\n<li>For example &#8211; \u201cMath 101|study of numbers\u201d<\/li>\n\n\n\n<li>For the response file in EDI format, the EDI conversions will not pass an extra pipe and an error will be produced for the record with the extra. Although the file will still process, the record with the error will not be passed in the response file.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Filler fields are for future enhancements and are expected to be left empty.<\/strong> Content included in filler fields will not be saved or included in the response files.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-open-sans-font-family\" style=\"font-style:normal;font-weight:600\">Examples<\/h2>\n\n\n\n<h3 class=\"wp-block-heading has-open-sans-font-family\" style=\"font-style:normal;font-weight:600\">Body Record from Host:<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>RTD1|7100003|123456789||John|S|Smith|Sr|19850814|12345 Somewhere Dr.||Someplace|VA|77396|US|703 999 9999|Someone@hometown.edu|Y|60||||CHEM|1405|Intro Chemistry|Fall 2014|20140825|20141214|B|20141214|3|Regular Enrollment|y|Math|025|3.5|3.7|888888|12131415|||||<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading has-open-sans-font-family\" style=\"font-style:normal;font-weight:600\">Example of a Body Record from System of Institution Host:<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>RTD1|7100003|123456789||John|S|Smith|Sr|19850814|12345 Somewhere Dr.||Someplace|VA|77396|US|703 999 9999|Someone@hometown.edu|Y|60|||<span style=\"color: #ff0000;\"><strong>999999<\/strong><\/span>|CHEM|1405|Intro Chemistry|Fall 2014|20140825|20141214|B|20141214|3|Regular Enrollment|y|Math|025|3.5|3.7|888888|12131415|||||<\/code><\/pre>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">Systems are required to submit their Host OPEID (see highlighted text above).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Guidance on the host file body 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":[90,79,23,88,91,81],"class_list":["post-1282","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-host-reverse-transfer-course-detail-file","ht_kb_tag-body-record","ht_kb_tag-data-files","ht_kb_tag-formatting","ht_kb_tag-host-file","ht_kb_tag-layout","ht_kb_tag-transmitting"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1282","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=1282"}],"version-history":[{"count":6,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1282\/revisions"}],"predecessor-version":[{"id":3042,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1282\/revisions\/3042"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/media?parent=1282"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb-category?post=1282"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb-tag?post=1282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}