Skip to main content
CollegeSource Support

Export Options

 

If you are storing equivalencies in TES, you can get a list of them at any time. The Export Options feature under the MANAGE menu allows any TES Admin to create an extract file of any selected equivalencies stored in TES.

Creating an Export File

  • There are a variety of selection parameters that are available to determine what you extract from TES.

clipboard_e3e42ad0d04296130c1871b571aea40ac.png

  • Export Options: Create a tab-delimited .txt file or extract the file to the screen (XML). In certain browsers (Chrome, IE) the extract file will open in Notepad. In others (Firefox), it will open in Excel.

  • From Date: Select the earliest date for the records you wish to extract.

  • To Date: Select the latest date for the records you wish to extract.

  • Apply To: You have the option to designate whether the date range applies to the CREATE AND LAST EDIT DATE, just the CREATE DATE, or just the LAST EDIT DATE.

  • EQ TYPE: When an equivalency is created in TES, it can be flagged as a “hidden” equivalency. Hidden equivalencies will not display in the Public View or to Users with no User Rights assigned. This parameter allows you to include both PUBLIC AND HIDDEN equivalencies, just PUBLIC equivalencies, or just HIDDEN equivalencies in the extract.
  • Send Institution: You can request equivalency records that contain transfer courses from ALL INSTITUTIONS or one institution at a time using this drop-down menu.

  • Send Institution Identifier: Select which institution identifier code(s) you wish to include in the export file. You can select any or none of the codes to be included.

Depending upon the amount of data you have stored in TES, and the range of data you have selected the extract could take from several seconds to several minutes to complete. The extract file could be passed along to your technical folks. They may be able to create a script to load the extracted equivalencies into your Student Information System/Articulation System. It may be copied and dropped into an Excel spreadsheet so that you can read the output more easily. The columns can then be manipulated and used by a processor to manually enter the information into your Student Information System/Articulation System.

Export File Specifications

The TES Export Options Equivalency Report Fields:

SendInstitution = Transfer Institution/Sending Institution for the equivalency.

SendInstitutionCity = Transfer Institution City for the institution in the equivalency.

SendInstitutionState = Transfer Institution State for the institution in the equivalency.

SendInstitutionCountry = Transfer Institution Country for the institution in the equivalency.

SendInstitutionOPEID* = Transfer Institution OPEID for the institution in the equivalency.

SendInstitutionIPEDSID*=Transfer Institution IPEDSID for the institution in the equivalency.

SendInstitutionCEEBCode*= Transfer Institution CEEB for the institution in the equivalency.

SendEditionLowYear = Transfer Institution Dataset low year for the transfer course(s). For example, if the 2014- 15 dataset is the dataset that was selected when creating the equivalency, 2014 would represent the low year.

SendEditionHighYear = Transfer Institution Dataset high year for the transfer course(s). For example, if the 2014-15 dataset is the dataset that was selected when creating the equivalency, 2015 would represent the high year.

SendCourse1CourseCode – SendCourse10CourseCode = Transfer Courses for selected equivalency (up to 10 courses can be grouped together in an equivalency. For example, you may have the transfer courses PH121, PH121L, and PH121R grouped together to represent what the student would have taken to satisfy the equivalency).

SendCourse1CourseTitle – SendCourse10CourseTitle = Transfer Course Title for each of the send courses in an equivalent (up to 10 courses can be grouped together in an equivalent – see SendCourse1CourseCode).

SendCourse1Units – SendCourse10Units = Transfer Course Credits for each of the send courses in an equivalent (up to 10 courses can be grouped together in an equivalent – see SendCourse1CourseCode).

ReceiveInstitution = Your Institution’s Name.

ReceiveEditionLowYear = Your Institution’s Dataset low year for the equivalent course(s). For example, if the 2014-15 dataset is the dataset that was selected when creating the equivalency, 2014 would represent the low year.

ReceiveEditionHighYear = Your Institution’s Dataset high year for the equivalent course(s). For example, if the 2014-15 dataset is the dataset that was selected when creating the equivalency, 2015 would represent the high year.

ReceiveCourse1CourseCode – ReceiveCourse10CourseCode = Your Institution’s courses for the equivalency (up to 10 courses can be grouped together for the equivalency. For example, you may have the home courses PHIL 111, PHIL111L, and PHIL111R grouped together to represent what the student will receive credit for as part of the equivalency).

ReceiveCourse1CourseTitleReceiveCourse10CourseTitle = Your Institution’s Course Title for each of the receive courses in the equivalency (up to 10 courses can be grouped together for the equivalency – see ReceiveCourse1CourseCode).

ReceiveCourse1Units – ReceiveCourse10Units = Your Institution’s Course Credits for each of the receive courses in the equivalency (up to 10 courses can be grouped together for the equivalency – see ReceiveCourse1CourseCode).

ActiveDateBegin = The Effective Date Range Begin Date for the equivalency (if applicable).

ActiveDateEnd = The Effective Date Range End Date for the equivalency (if applicable).

ContactName = The TES User that created the equivalency in your TES database.

EQCreateDateTime = The Date and Time the equivalency was created in your TES database.

EQLEditDateTime = The Date and Time the equivalency was edited in your TES database.

HideFlag = Do you want to Hide the equivalency from your TES Public View? Yes will hide it. No will allow it to display.

CommentsPublic = The Public Note for the equivalency.

CommentsPrivate = The Internal (Private) Note for the equivalency.

clipboard_eda5b655243e72ac657f5f858b55b5df5.png

*indicates optional codes based on Send Institution Identifiers selected. 

 

  • Was this article helpful?