TRANSFER INFORMATION SYSTEM
ADMINISTRATIVE AREA: REPORTS/RETRIEVALS



 
This section provides information about various TIS reports. To generate a report or retrieve a static report, go to TIS Maintenance and click on the Reports option.

A. Data and Report File Designations:
B. Course Update Report Files:

C. Equivalency Update Report Files:
D. No Equivalency Provided Reports:
E. Department/Curricular Area Code and General Education (Breadth) Table Reports:
F. Footnote Reports:
G. Course Distribution Files/Reports:
H. Reports Used to Check TIS Courses:

I. Reports Used to Check TIS Equivalencies:
J. 50% Report:


A. Data and Report File Designations:

    1. Many TIS files contain a Year/Term designation in the YYYT format described below. The designation will change each term.

      YYY = Academic year of data/report (e.g. 090 for fall and spring 2009-10; 090 for summer 2010)
      T = Term of update report ('1' = Fall, '2' = Spring, '3' = Summer)

    2. Institution-specific TIS files contain a Unit Code (*) or an Institution Abbreviation (***) designating the institution. (See TIS Institution Table for details.)

B. Course Update Report Files:

    These are static reports generated as a part of course batch submission processing.  Course update reports file formats are:

    • tisYYYT*_crs_error_report.pdf
    • tisYYYT*_crs_update_report.pdf
    • tisYYYT*_crs_unmatched_report.pdf

    Examples:
    • tis0901k.crs.error.report.pdf for the Fall 2009-10 Course Error Report for UW-Stevens Point
    • tis0902k.crs.update.report.pdf for the Spring 2009-10 Course Update Report for UW-Stevens Point
    • tis0903k.crs.unmatched.report.pdf for the Summer 2010 Unmatched Course Report for UW-Stevens Point

C. Equivalency Update Report Files:

    These are static reports generated as a part of equivalency batch submission processing. Equivalency update reports file formats are:
    • tisYYYT*_footnote_change_report.pdf
    • tisYYYT*_footnote_error_report.pdf
    • tisYYYT*_footnote_unmatched_report.pdf
    • tisYYYT*_equiv_update_report.pdf
    • tisYYYT*_equiv_error_report.pdf
    • tisYYYT*_equiv_unmatched_report.pdf

    Examples:
    • tis0901k.equiv.error.report.pdf for the Fall 2009-10 Equivalency Error Report for UW-Stevens Point
    • tis0902k.equiv.update.report.pdf for the Spring 2009-10 Equivalency Update Report for UW-Stevens Point
    • tis0903k.equiv.unmatched.report.pdf for the Summer 2010 Unmatched Equivalency Report for UW-Stevens Point

D. No Equivalency Provided Reports:

    Campuses can generate a No Equivalency Provided (“NEP”) Report. For a given institution, this report lists each course for which the given institution has not provided an equivalency to TIS. (Note: The NEP Reports are only available to users who are logged into the TIS Maintenance System.) The reports can be exported in one of the following formats:
    • CSV (for loading into Excel)
    • Excel
    • XML
    • PDF (for direct printing)

E. Department/Curricular Area Code and General Education (Breadth) Table Reports:

    Campuses can generate Department/Curricular Area Code and General Education (Breadth) Table Reports. The reports can be exported in one of the following formats:
    • CSV (for loading into Excel)
    • Excel
    • XML
    • PDF (for direct printing)

F. Footnote Reports:

    Campuses can generate a list of the systemwide and institutional footnote text records for an institution.  The reports can be exported in one of the following formats:
    • CSV (for loading into Excel)
    • Excel
    • XML
    • PDF (for direct printing)

G. Course Distribution Files/Reports:

    Campuses can generate a dynamic Course Distribution Report for a specific institution.  This report lists each course on the TIS data base offered at the selected institution. 
    Options include selecting:
    • all courses or only freshman/sophomore level courses, current courses (without ending dates) or both current and historical versions of courses,
    • flat file or report output.
    (Note:  The Course Distribution Reports are only available to users who are logged into the TIS Maintenance System.)  The reports can be exported in one of the following formats:
    • CSV (for loading into Excel)
    • Excel
    • XML
    • PDF (for direct printing)

    Within the Static Reports area, Course Distribution Reports are available in PDF format that include (1) all courses (both current and historical versions) from all institutions and (2) all freshman/sophomore level courses (both current and historical versions) from all institutions.

H. Reports Used to Check TIS Courses:

    These reports are run by TIS staff, typically following batch course submission processing to identify problems that may have been caused by course or other table updates.

1. Course Statistics Report

This report provides a summary of the data associated with a course submission file for a given campus. It lists the dates the file was received and used to update, along with the total number of records submitted, updates done, and records rejected as errors.

2. Match CAC to Course Report

    This report lists courses on the TIS data base where the curricular area code (CAC) on the course record is not valid for the associated department/curricular area in the TIS Department/Curricular Area Table.

    3. Duplicate Active Course Report

    This report lists courses on the TIS data base where the data may be inconsistent or erroneous. This includes courses for which there are multiple records for the same or overlapping effective dates, courses for which there are multiple records with an active or inactive status, and courses where the previous course information is erroneous.

I. Reports Used to Check TIS Equivalencies:

These reports are run by TIS staff, typically following batch equivalency submission processing to identify problems that may have been caused by equivalency or other table updates.

1. Equivalency Statistics Report

This report provides a summary of the data associated with the equivalencies in an equivalency submission file for a given campus. It lists the dates the file was received and used to update, along with the total number of records submitted, updates done, and records rejected as errors.

2. Footnote Statistics Report

This report provides a summary of the data associated with the footnote text records in an equivalency submission file for a given campus. It lists the dates the file was received and used to update, along with the total number of records submitted, updates done, and records rejected as errors.

3. Match Course to Equivalency Report

This report lists equivalencies on the TIS data base where there is no match in the TIS course file for either the associated From Course or To Course.

4. Duplicate Equivalency Report

This report lists equivalencies where multiple records are on the TIS data base for the same From Course and the same or overlapping effective dates. In some cases, these records represent “group” equivalencies where one course transfers as a combination of courses. In such situations, it is recommended that a footnote be assigned to each equivalency to explain the group situation. In other cases, the one of the records may have submitted with a missing end date.

J. 50% Report:

This report lists the number of equivalencies that a given To Institution has provided to TIS. For each From Institution, the number of active courses is compared to the number of equivalencies provided for these courses. For UW institutions, a total of freshman/sophomore level courses is also reported with the percent of these equivalencies provided.

Administration Area Main | TIS Maintenance | Reports/Retrievals | Catalogs/Contacts |
| Usage Stats | Project Staff | Promotion | TIS Training | TIS Home |

© Copyright 2009 by the Board of Regents of the University of Wisconsin System.