What
is the STUDENT_CLASS table?
The STUDENT_CLASS table
contains registration records
for students. There is one
record per student registration
per class per semester.
For instance if a student
this semester has registered
for HIS 102, ENG 101 and
BIO 181 (involves three
Schedule Line Numbers (SLN's))
there will be three records
for him. All registrations
are included even if the
student later drops, is
dropped for non fee payment,
or completely withdraws.
What
is the key (unique identifier
for a row) for STUDENT_CLASS?
Semester, Affiliate ID,
and SLN.
What
is the timing of the table?
Records appear in this table
as students register for
classes. The first entries
will appear from the pre-registration
process. As drop/add and
early registration progress,
the table is loaded weekly
and reflects those changes
in registration. When fee
payment deadline hits, students
who have not paid fees are
dropped from the SIS. They
are not dropped from the
Data Warehouse, but their
RECORD_NO_LONGER_ON_SIS
flag changes.
Some
of the data is frozen on
the 21st day. The CENSUS_ENROLLMENT_FLAG
indicates that the data
is included in the WAREHOUSE
Census files. 21ST_DAY_HOURS,
GRADE_CODE and GRADE_POINT_GRADE
are frozen after grades
are posted. Changes after
that time will be reflected
in the adjusted grade code
and grade point grade.
Why
would you use it?
A common use for the STUDENT_CLASS
table is to get a list of
students currently enrolled
in a class, i.e. class rosters.
You can identify students
who have dropped or withdrawn
from classes or study withdrawal
behavior. You can study
course demand as enrollment
changes from week to week
during registration. Since
grades are frozen at the
end of the semester, you
can use it to study grade
distributions historically
from semester to semester
/ instructor to instructor.
Can also see how students
are obtaining classes -
i.e. on-line touch tone,
prereg etc.
What
should you watch out for?
Some of the records are
removed from the SIS through
various processes (such
as death, drop/withdrawal,
fee payment purge etc.)
but will still appear in
this table. To remove them
you must use the RECORD_NO_LONGER_ON_SIS_FLAG
and the DROP_WITHDRAW_DATE.
Set the RECORD_NO_LONGER_ON_SIS_FLAG
to N to remove records that
are no longer on the SIS.
If you don't use this flag
and are looking at grades
you will see a bunch of
odd ones - D6, D4 etc. Make
sure you set the DROP_WITHDRAW_DATE
to NULL if you are looking
for current enrollment.
(blank dates are always
NULL not blanks!)
The
GRADE_CODE is frozen after
grades are posted. If a
student's grade changes
after that (i.e. an incomplete
is completed or changed
to a failing grade, or they
petition for a change) the
change will be shown in
the ADJUSTED_GRADE_CODE.
If no change occurs both
are the same.
If
you want to look at the
number of hours a student
is enrolled in, decide if
you care about 21ST_DAY_HOURS
or plain ol' HOURS. The
21ST_DAY_HOURS day hours
field is frozen on the 21st
day. Plain ol' HOURS keeps
changing each week as the
student drops/adds/withdraws.
Don't
use STUDENT_CLASS to determine
how many hours a student
is carrying. You would have
to sum hours to do this
and the STUDENT_PROFILE
already has them summed
for you.
