What is the UV COURSE Table?
This table contains course data for undergraduate and graduate students enrolled at a university by term and institution attended. Terms include Fall, Spring, and Summer semesters. Institutions include Arizona universities your students have attended before or after they attended your institution, based on the files submitted by your institution.
What is the key (unique identifier for a row) for this table?
Unique records are determined by Semester, Arizona Unitid, ASSIST Student ID, and UV Course Unique Identifier. In other words, there is one record per semester per university per student per unique course.
Why would you use this table?
If you are a community college, you would want to use this table to determine what courses your students were enrolling in at a university and how well they performed in those courses.
If you are a community college or a university, you would want to join this table with the CC COURSE table to track your students’ performance in sequenced community college/university courses.
Notes on using this table:
(1) In this table, Arizona Unitid refers ONLY to universities.
(2) If you are a community college, you will need to join this table with the UV UNDERGRADUATE TRANSFER INST table by Semester, Arizona Unitid, and Assist Student ID. You can then limit UV Transfer Institution Code to your institution to select only those students who attended your institution PRIOR to attending a university.
(3) Course grades in this table are assigned as of the end of a given semester. If a grade is changed in a subsequent semester, the change will NOT be reflected anywhere in the course data. However, the Cumulative Earned Hours and Cumulative GPA fields in the UV ENROLLMENT table will reflect grade changes in subsequent semesters.
