Is joined with:
- SAH-Demographics-View
- SAH-StudentStudentsStatsPerTerm-View
...
| Table of Contents |
|---|
Overview
- Current, Historical, and First ever records of students activities and
...
Key Fields:
- Primary Major
- Primary Minor
- Secondary Major
- Secondary Minor
Key Fields to use as filters:
- Registration Status = 'Enrolled', 'Registered'
Additional Notes:
...
- 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.
...
Folder
...
Fields
...
Note
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
...
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.
...
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
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