Overview

• Current, Historical, and First ever records of students activities and information joined with SAH-Demographics-View and SAH-StudentStudentsStatsPerTerm-View
• Do not expect to see all students in this view. This view only includes students who have changed their majors. 
• No census data is available for this view.

Data Loads

Critical Concepts

Dropping Out/Graduating

• The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.
• Primary Major/ Primary Minor / Secondary Major/ Secondary Minor: Includes both grad and undergrad values are in one field

Steps to Take

Key Fields to View:

• Primary Major
• Primary Minor
• Secondary Major
• Secondary Minor

Key Fields to Filter on:

• Registration Status = 'Enrolled', 'Registered'

Granularity is the scale or level of detail present in a set of data.  It identifies where levels of uniqueness exists in the data.  The data lives in the view at the lowest level, but each BI tool totals the levels differently.

Please note:  The Level of Detail (LOD) calculations listed here for Tableau developers are a baseline and do not necessary include all of the LOD equations needed for your report.

TBD

Fields

Note

Yes indicates that the major is self-supported.  Self-supported major programs receive no state-funding.  State-supported programs receive state-funding and have different fees for California and non-California students.  

Only applies to grad primary majors. All undergraduate major programs are state-supported. 

Key Fields to View

• Primary Major
• Primary Minor
• Secondary Major
• Secondary Minor

Key Fields to Filter On 

• Registration Status = 'Enrolled', 'Registered'

Additional Notes

Reference

Data is loaded nightly from oracle.  To see when the data completed being loaded by UCSD into SAH see this report: Tableau > Public > AH Data Load Status Report