What
is the Registered Student
table?
The Registered student table
is a weekly snapshot of
students who have been registered
at ASU during the last two
years. After two years,
a student's record is no
longer updated but a record
for every student registered
since 1980 is present. This
table has no semester associated
with it - i.e. you don't
limit to a particular semester
to get the students registered
that semester. Instead,
there is a CURRENTLY_ENROLLED_FLAG
that when limited to Y will
give you all students currently
enrolled at ASU. This is
similar to the FOCUS Student
Database. In comparison
to other tables on the Warehouse
like Student Profile which
are intended to show history,
the Registered Student table
is intended to be an "on-the-fly"
look at students during
the current semester. This
is a base table, not a view.
What
is the key (unique identifier
for a row) for Registered
Student?
Affiliate ID is the key
for the table. There is
one record per Affiliate
ID.
What
is the timing of the table?
When a new student pre registers
or registers a record is
added to this table. That
record is updated weekly
until their last registration
at ASU is over two years
old. At that time, the record
is frozen. The timing of
the CURRENTLY_ENROLLED_FLAG
is very important to this
table. The CURRENTLY_ENROLLED_FLAG
will be Y for a student
who is enrolled in the "current"
Fall or Spring semester
(summer enrollment is ignored).
If the student completely
withdraws during the semester,
the flag will be changed
to N. The switch over point
from Fall to Spring for
the CURRENTLY_ENROLLED_FLAG
is the first day of the
Spring semester. Before
that time, the flag indicates
enrollment in the Fall semester.
The switch over point from
Spring to Fall is the first
day of summer session. Before
that, the flag indicates
enrollment in the Spring
semester.
Why
would you use it?
Use the Registered Student
table to get information
about students who are in
classes NOW. You don't care
if they were here on the
21st day or if they were
"official". Registered
Student is a good base table
to generate mailing labels
for currently enrolled students.
Just join it to one of the
Student Mailing Labels tables.
Use
Registered Student to see
changes in students over
the course of the current
semester. See if/when they
apply for graduation, see
how many are completely
withdrawing on a weekly
basis, see degree major
changes weekly.
The
Registered Student table
is the only table that contains
course restricted withdrawal
counts and a student health
insurance flag.
Why
would you NOT want to use
it?
You need "official"
census information on students
rather than current information
or you need historical information.
What
should you watch out for?
Student records older than
two years are not updated
so they may not be an accurate
historical picture. For
instance, if grades are
changed after a student's
record has been frozen,
they will not be reflected
in the GPA.
The
CURRENTLY_ENROLLED_FLAG
is set at specific times.
Make sure you get your list
of Fall students enrolled
at the end of Fall before
the flag is changed on the
first day of Spring. And
remember, the CURRENTLY_ENROLLED_FLAG
is not set for summer sessions.
Students
who attended ASU prior to
1980 (pre Student Information
System) are not included
in the Registered Student
table.
