Import Transfer Equivalencies into TES and Transferology: Import Data File Examples
This article is a supplement to Import Transfer Equivalencies into TES and Transferology: Create an Import Data File. It provides examples of how information is structured within an import data file.
Articles in this series:
- Import Transfer Equivalencies into TES and Transferology: An Overview
- Import Transfer Equivalencies into TES and Transferology: Create an Import Data File
- Import Transfer Equivalencies into TES and Transferology: Import Data File Examples
Structuring an Equivalency
The below example illustrates how data for an equivalency between CollegeSource Community College's MATH 1100 and CollegeSource University's MATH 140 would be structured in a data import file. CollegeSource Community College is the transfer institution from which coursework is being evaluated; CollegeSource University is the home institution creating the import file.
| Field Name | Example |
| InstitutionCodeType | IPEDSID |
| SendInstitutionCode | 111111 |
| SendInstitutionName | CollegeSource Community College |
| SendInstitutionCity | Duluth |
| SendInstitutionState | MN |
| SendInstitutionCountry | United States |
| EQValidDateStart NULL | 9/1/1999 |
| EQValidDateEnd NULL | |
| SendCourseCode1 | MATH 1100 |
| SendCourseCode2 NULL | |
| SendCourseCode3 NULL | |
| SendCourseCode4 NULL | |
| SendCourseCode5 NULL | |
| SendCourseCode6 NULL | |
| SendCourseCode7 NULL | |
| SendCourseCode8 NULL | |
| SendCourseCode9 NULL | |
| SendCourseCode10 NULL | |
| ReceiveInstitutionCode | 222222 |
| ReceiveInstitutionName | CollegeSource University (SH) |
| ReceiveCourseCode1 | MATH 140 |
| ReceiveCourseCode2 NULL | |
| ReceiveCourseCode3 NULL | |
| ReceiveCourseCode4 NULL | |
| ReceiveCourseCode5 NULL | |
| ReceiveCourseCode6 NULL | |
| ReceiveCourseCode7 NULL | |
| ReceiveCourseCode8 NULL | |
| ReceiveCourseCode9 NULL | |
| ReceiveCourseCode10 NULL | |
| CommentsPrivate NULL | Evaluated by Professor Smith, 11/7/2023. |
| CommentsPublic NULL | Course meets the Logic & Quantitative Reasoning Liberal Education requirement. |
| HideFlag | 0 |
Additional Examples
Below are additional examples to help illustrate how equivalency data should be structured within an import file
One-to-One Equivalency
CollegeSource Community College's BIO 101 transfer to CollegeSource University as equivalent to its BIOL 1. In this example, the other SendCourses and Receive courses will be blank.
| SendCourseCode1 | SendCourseCode2 | RecieveCourseCode1 | RecieveCourseCode2 |
| BIO 101 | BIOL 1 | ||
Two-to-One Equivalency
CollegeSource Community College's BIO 101 & BIOL 101L transfer to CollegeSource University as equivalent to its BIOL 1.
In this example, data will be populated in SendCourseCode1 and SendCourseCode2. The other Send Course fields will be blank. Only ReceiveCourseCode 1 will be populated.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | RecieveCourseCode2 |
| BIO 101 | BIO 101L | BIOL 1 | |
Two-to-Two Equivalency
CollegeSource Community College's BIO 101 & BIO 101L transfer to CollegeSource University as equivalent to its BIOL 1 & BIOL 1L.
In this example, data will be populated in SendCourseCode1 and SendCourseCode2. The other SendCourse fields will be blank. ReceiveCourseCode1 and ReceiveCourseCode2 will be populated, but the other ReceiveCourse fields will be blank.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | RecieveCourseCode2 |
| BIO 101 | BIO 101L | BIOL 1 | BIOL 1L |
"OR" Equivalency
CollegeSource Community College's BIO 101 transfers to CollegeSource University as equivalent to its BIOL 1 or BIOL 2.
In this example, two rows of data are required - one for the equivalency between BIO 101 and BIOL 1, and another for the equivalency between BIO 101 and BIOL 2.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | ReceiveCourseCode2 |
| BIO 101 | BIOL 1 | ||
| BIO 101 | BIOL 2 | ||
Electives
CollegeSource Community College's MATH 255 transfers to CollegeSource University as a MATH 1xx-level elective.
In this example, MATH 1xx is the code used to convey this transfer decision. If MATH 1xx has not already been added as a User Added Home Course to TES, it can be added during the import process.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | ReceiveCourseCode2 |
| MATH 255 | MATH 1xx | ||
Electives Meeting Liberal Education Requirements
CollegeSource Community College's MATH 255 transfers to CollegeSource University as a MATH 1xx-level elective meeting the university's Logic & Quantitative Reasoning Liberal Education requirement.
In this example, MATH 1xx is the code used to convey that the course transfers as a 1xx-level elective in Math. LE LOGIC QR conveys that the course meets the Logic & Quantitative Reasoning requirement. If MATH 1xx and LE LOGIC & QR have not already been added as User Added Home Courses to TES, they can be added during the import process.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | ReceiveCourseCode2 |
| MATH 255 | MATH 1xx | LE LOGIC QR | |
Advanced Placement Exams
Institutions should put "AP" followed by the exam title within the SendCourse field.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | ReceiveCourseCode2 |
| AP Art History | ART 101 | ||
CLEP Exams
Institutions should put "CLEP" followed by the exam title within the SendCourse field.
| SendCourseCode1 | SendCourseCode2 | ReceiveCourseCode1 | ReceiveCourseCode2 |
| CLEP Biology | BIOL 1 | ||
Sample File
See the sample file for further examples.