Summary
- 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
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
Granularity
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.
Folder | Fields | Note |
|---|---|---|
| Primary Major | Includes both grad and undergrad values are in one field | |
| Primary Minor | Includes both grad and undergrad values are in one field | |
| Secondary Major | Includes both grad and undergrad values are in one field | |
| Secondary Major | Includes both grad and undergrad values are in one field | |
| Majors Minors Flags | Primary Major Is Self-Supporting Flag | 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'