UV COURSE Table

Data Elements and Definitions

Name

/

Type

/

Length

/

Definition

/

Common Usage

SEMESTER / Char / 5 / A Year/Semester code that indicates the semester of enrollment for all data elements in the table.
Code Values:
YYYY1 = Spring
YYYY2 = Summer 1
YYYY3 = Summer 2
YYYY4 = Summer 8-wk
YYYY5 = Fall
Beginning in Summer 2003, NAU reports all summer registrations under YYYY4. Prior to that, NAU reported three summer terms.
This field may be joined to CODE UV SEMESTER to get a description. / You would use this field to limit course data to a particular semester of enrollment or to join to other UV or CC tables.
You may only join to CC tables on Fall and Spring semesters because of multiple summer session codes in the UV tables. Community college data include only one summer session.
Setting a maximum function on this field will return the most recent semester of enrollment with course information.
ACADEMIC YEAR / Char / 8 / A concatenation of years to indicate the Academic Year in which a given semester falls.
Academic Year is considered to be the sequential semesters Fall, Spring, and Summer. (For example: 20002001 = Fall 2000, Spring 2001, and Summer 2001) / You would probably use this field only for descriptive purposes or to limit records to semesters in a given year.
You should NOT use this field to join with other tables.
ARIZONA UNITID / Char / 6 / A code that reflects the NCES Unit ID for each university.
This field may be joined to CODE ARIZONA UNITID to get a description. / You will use this field to limit queries to a specific university only. It does NOT apply to community colleges.
You should ALWAYS use this field to join with another UV table. Do NOT use it to join with a CC table.
ASSIST STUDENT ID / Char / 8 / The 8-character anonymous ID that is assigned to each student during the ID matching process. / You will ALWAYS use this field to join with another UV or CC table so you can get data on the same individual.
UV COURSE UNIQUE
IDENTIFIER / Integer / 1 / A sequential number that uniquely identifies each course that a student registered for during a given semester.
(For example: If a specific student registered for four courses, there would be four records for that student, one record per semester with a Unique Identifier of 1, 2, 3, or 4.)
This field identifies unique records if a student registers for more than one course with the same discipline and number, such as Special Topics or Individualized Instruction. / You should use this field to obtain separate records for each UV Course Discipline Number.
UV COURSE CAMPUS CODE / Char / 1 / A code that reflects the campus that funds a specific course in which a student is enrolled in a given semester.
ASU reports campus codes. Beginning in Fall 2005, UA reports campus codes.
Code Values:
E = ASU Polytechnic (formerly East)
M = ASU Tempe (formerly Main)
W = ASU West
D = ASU Downtown Phoenix
R = UA Regular Course
S = UA Sierra Vista Course
This field may be joined to CODE UV COURSE CAMPUS to get a description. / You would use this field if you only wanted to look at the courses funded by a particular ASU or UA campus.
UV COURSE DISCIPLINE NUMBER / Char / 8 / A concatenation of discipline code and course number to reflect the full description of a specific course in which a student is enrolled in a given semester.
This field is university-specific. There is no code table at this time. / You would probably only use this field for descriptive purposes unless you are interested in a particular course at a particular university.
UV COURSE DISCIPLINE / Char / 4 / A code that reflects the discipline of a specific course in which a student is enrolled in a given semester.
This field is university-specific. There is no code table at this time. / You would use this field to limit coursework to a particular discipline, such as Math or English.
Because each university uses a different set of codes, you might want to run frequencies on a substring of this field to make sure you pick up all course prefixes.
(For example, limiting this field to Begins With “MAT” will return disciplines of “MAT” for ASU and NAU and “MATH” for UA.)
UV COURSE NUMBER / Char / 4 / A code that reflects the level of a specific course in which a student is enrolled in a given semester.
Code Values:
100 – 400 series = Undergraduate
500 – 700 series = Graduate
This field is university-specific. There is no code table at this time. / You would use this field to limit coursework to a particular level, such as freshmen-level courses (numbered 100-199).
UV COURSE TITLE / Char / 40 / A full description of the title of a specific course in which a student is enrolled in a given semester. / You would probably use this field for descriptive purposes only.
UV COURSE CREDIT HOURS / Floating Decimal / 8 / A value that reflects the number of credits carried by a specific course in which a student is enrolled in a given semester. / You would use this field if you wanted to sum all credit hours for a group of students to get total SCH (Student Credit Hours) generated in a particular semester.
You might also want to compare completed course hours with registered hours in the UV ENROLLMENT table by limiting Course GradeNot Equal To “W”.
UV COURSE GRADE CODE / Char / 2 / A code that reflects the grade assigned to a specific course in which a student was enrolled in a given semester.
Code Values:
A+ = Excellent
A = Excellent
A- = Excellent
B+ = Good
B = Good
B- = Good
C+ = Average
C = Average
D = Below Average
E = Failing
I = Incomplete
P = Passing
W = Withdrawal
IP = In Progress
AU = Audit
NG = Non-graded
NR = No Report
ASU does not assign grades of “NG”.
In Fall 2004, ASU began using plus minus grades.
This field may be joined to CODE UV COURSE GRADE to get a description. / You would use this field if you wanted to determine the grade distribution for your students in a particular course or for all courses in a particular semester.
You can calculate an average GPA for students completing a particular course by converting grades associated with net hours to grade points:
A+ = 4.333 grade points
A = 4.000 grade points
A- = 3.667 grade points
B+ = 3.333 grade points
B = 3.000 grade points
B- = 2.667grade points
C+ = 2.333grade points
C = 2.000 grade points
D = 1.000 grade point
E = 0.000 grade points
Grade changes that occur in subsequent semesters will NOT be captured anywhere in this table.
UV NUMBER COURSES TAKEN / Integer / 2 / A value that reflects the maximum number of courses taken by a student in a given semester.
(For example, if a student registered for four courses in a particular semester, there would be four records for that student for that semester and this field will reflect a value of “4” in each record.) / You would use this field if you wanted to determine the average number of courses taken by your students in a particular semester.
You would only need one record per student to calculate an average since all records for a student will carry an identical value in this field for a given semester.

UV COURSE Table

LAST UPDATE: March 1, 2007