What
is the Degree table?
This table captures degrees
granted to each student
for each semester.
What
is the key (unique identifier
for a row) for GPA?
Affiliate ID, semester degree
granted, academic campus
code and degree/major .
What
is the timing of the table?
A record is placed in this
table when the Student Graduation
Progress Code in the SIS
changes to G. This indicates
a degree has been posted
for the student. Records
are updated in this table
weekly.
Why
would you use it?
The primary use of this
table is to find students
who have graduated from
ASU.
Why
would you NOT want to use
it?
What
should you watch out for?
When joining this table
to Student Profile to get
demographic information
on students, keep in mind
that students are not always
enrolled in the semester
in which they graduate.
You may need to join to
the Registered Student table
to see what the last semester
was they were enrolled and
then join to Student Profile
by both the semester and
the Affiliate ID.
