Overview

• This view only includes students who have

  • changed their major / minor OR

  • requested program changes OR

  • added a secondary major OR

  • added a minor

• This view does not represent a full listing of students in a given major, it exclude students with one primary major that has never changed.

Critical Concepts

Pre-Joined Data

• Current, Historical, and First ever records of students activities and information joined with SAH-Demographics-View and SAH-StudentStudentsStatsPerTerm-View

Majors and Minors

• Detailed information about students major/minor. 

• Information about which college and program they were enrolled in or have switched to

• No census data is available for this view

Step to Take

Key Fields to View

• From Program 

• To Program

• Major Minor Change Date

Key Fields to Filter On 

• Registration Status = 'Enrolled', 'Registered'

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.