Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Is joined with:

  • SAH-Demographics-View 
  • SAH-StudentStudentsStatsPerTerm-View

Including:

Table of Contents

Summary

  • 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.

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.

Note

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 FlagsPrimary 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'

Additional Notes

Ui expand
titleDropping Out/Graduating
  • The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.