Summary
- Current, Historical, and First ever records of students activities and information joined with SAH-Demographics-View and SAH-StudentStudentsStatsPerTerm-View
- Detailed information about students major/minor.
- This view only includes students who have either changed their major / minor or have requested program changes and does not represent a full listing of students in a given major.
- Which college and program they were enrolled or have switched to
- 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 |
|---|---|---|
| From - To | From Program Code | The Major Code or Minor Code that a student is leaving, as part of a transaction to change majors or minors. |
| From - To | To Program Code | The Major Code or Minor Code that a student is going to, as part of a transaction to change majors or minors. |
| From - To | From Program Department | Department Name associated with From Program. Major only. |
| From - To | To Program Department Code | Department Code a student has moved into for Major only, depending on reporting filters |
| From - To | From Program Priority | Indicates the priority of the program as indicated by the student. Primary or non-primary. |
| From - To | To Program Priority | Indicates the priority of the program as indicated by the student. Primary or non-primary. |
| Majors Minors Details | Major Minor Change Date | Date on which the activity occurred |
| Majors Minors Details Flags | From Program 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. All undergraduate major programs are state-supported. Only applies to grad primary majors. All undergraduate major programs are state-supported. |
| Majors Minors Details Flags | To Program 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. All undergraduate major programs are state-supported. |
| Term Set - MajorMinorDetail | Term, Term Code, Term ID, ... | A portion of time within a year where studies are performed. A term code could represent a starting or ending point when associated or applied to a particular Course, Wait-List, Academic Status, etc. |
Key Fields to View
- From Program
- To Program
- Major Minor Change Date
Key Fields to Filter On
- Registration Status = 'Enrolled', 'Registered'