Overview

The Student Activity Hub (SAH), a next generation analytical platform that helps drive data driven decision making in support of student success.

SAH empowers analysts across the university to generate operational reports to support things like enrollment counts, retention rates, and census measures in addition to some rich analysis supporting term progression, major switching, and learning analytics with the introduction of Canvas data into the system. There are other enclaves outside of SAH core data that include Admissions data and other more sensitive data sets. Access to those data sets is restricted. 

Other Resources

• Have a field name but not sure what view to look in?  Search the Activity Hub Field List. (You must be registered with DUO to connect)
• Data is loaded each night.  To see when the data completed being loaded by UCSD into SAH see this report: Tableau > Public > AH Data Load Status Report. (You must be registered with DUO to connect)

SAH Basics

Contents

By design, SAH does not include students who have not accepted their offer to UC San Diego.

Student information in 'Student Activity Hub' has been tracked since 2004 to the current year.  Anything prior to 2004 can be found in ISIS or the data warehouse.

SAH includes undergraduate, graduate, School or Medicine and School of Pharmacy students.

First Term Fields

Ends with the word 'First'

Displays the values that were true for the Student during their First Term at UCSD.

Found in SAH-Demographics-View

Current Term Fields

Ends with the work 'Current'

Displays the values that are true as of the Term today's date is physically located in. 

For students who have left UCSD, fields with 'Current' will display values from the most recent Term.

Found in SAH-Demographics-View

Students first appear here when Registration Status Current = Enrolled

Future or Past Term Fields

Do not end with 'First' or 'Current'

Displays the values that are true as of the Term displayed in the report

Use SAH-StudentStatsPerTerm-View for all of these terms.

Students first appear here when Registration Status = Enrolled for the Term displayed in the report

Admit vs First Enrolled vs First Enrolled All

Census

Census Date is a set date each term where reporting counts are locked to be sent for state and federal reporting. During academic terms, this is usually during the 3rd week of instruction. 

Census Views will include the word 'Census' in the name and include data that is frozen at the Census Date of each term.

Active Students

"Active" Students differ by department, division, business unit and purpose. 

• A student may be 'active' for gym membership purposes but 'inactive' for Biology building security purposes.

• A student may be 'active' for enrollment purposes but 'inactive' for social event purposes.

• A student may be 'active' between terms but 'inactive' without notifying UCSD they will not be returning.

• A student may be 'active' for Summer School purposes but 'inactive' for IPEDs purposes.

Also, in SIS there are no dates that indicate a student will no longer be returning to UCSD, and accordingly there is no data in SAH to indicate a student will no longer be returning to UCSD.

Report developers must create their own definition of 'Active' for their reporting purposes based on the field available to them from SAH.

• In SAH there is a field called Registration Status, if you see the value “enrolled” then the student has signed up for at least one class section, “registered” means they have signed up and paid for their enrollment, but sometimes the Registration Status gets stuck in “enrolled” so we recommend that report developers include both values from the Registration Status field.

• Some folks include Visitors and Employees taking class sections as “Active” and some do not.  You can find Visitors, Summer Session Only and Employees via the Applicant Type fields.

• Some folks include Non-Degree seeking students, and some don’t.  You can find Non-Degree seeking students via the Student Classification.

• SAH includes Undergrad, Graduate, School of Pharmacy and School of Medicine.  You can use the field “Student Level” to identify which students to include.

Students Names

Student names in SAH display the lived name (when available) and default to the legal name only if the lived name is not populated.

Students New to UCSD

As students join UCSD, they move through the process of Applied → Admitted by UCSD → Student Accepts their offer → Student Enrolls in a Class Section.

Students who accept their offer will appear in the Student Activity Hub (SAH), but they will have many null fields because they have not enrolled in a Class Section.  Use UG Admit Term or Graduate Admit Term to determine when the student accepted their UCSD offer.

• Registration Status Current = Null
• Student Level Current = Null
• Graduate Primary Major Current or UG Primary Major Current = Null

Ethnicity

Student ethnicity information is available at an aggregated EDI and Student Data Steward approved level.  Questions and additional details regarding ethnicity can be emailed to ir@ucsd.edu. 

Term, Term Cumulative or Current Cumulative

Units, GPA and some counts have been pre-aggregated for you.  If you search on the beginning of their name (ie. 'Attempted Units') you will see the different options available to you.

_____________ = no pre-aggregation on this measure

_____________ Term = Total for Term

_____________ Term Cumulative = Running total for Terms thus far

_____________ Current Cumulative = Overall total for all Terms

Units

There are different types of Units available to select from, depending on what you need in your report.  Each type of Unit is directly pulled from SIS.

• Ever Enrolled Units = The number of units enrolled in by a student.  Includes withdrawal notated on the transcript (W), incomplete (I), drops, class sections without grades and non-passing grades.

• Attempted Units = Ever Enrolled Units minus drops (without a W) and no grades. Units with a W are included.

• Enrolled Units = Ever Enrolled filtered for Student Currently Enrolled in the Class Section. If the term is over and grades have lapsed for that term, this field should equal Attempted Units in the SAH End of Term views.

• Completed Units = Attempted Units minus the withdrawal notated on the transcript (W) and incomplete (I).

• Passed Units = Completed Units minus Grades of D, F and Not Passing (NP).

Transfer Units are included in the above fields.  Check out the SAH-Enrollment-View about details about transfer credits.

Find the SAH View You Need

Check out the list of SAH Use Case to SAH View to search for know uses cases and what view we recommend you use.

What is in a SAH View?

• SAH Core: These views available to all SAH Report Developers.
• SAH Restricted: These views required additional approval for access.