Overview

The following article is a start guide for those using withdrawal information from the Student Activity Hub (SAH). It includes various terms for those using the tool and tips for new users. 

Other Resources

• Have a field name but not sure what view to look in?  Search the Activity Hub Field List. 
• Data is loaded into the Student Activity Hub (SAH) each night.  To see when the data load completed, use see this report: Tableau > Public > AH Data Load Status Report.
• Additional support can be found in the Analytics Community of Practice. 

Critical Concepts

Pre-Joined Data

• The SAH-Withdrawal Narrow-View is focused on one row per student.
• This view contains students who have been withdrew at some point.
• Withdrawal Narrow view looks at the most current withdrawal status without looking forward.
• Withdrawal Narrow view is joined with major Minor Narrow, Demographics and Student Stats Per Term Views.
• Current fields show a student's most recent activities and information at UCSD.
• First fields show a student's first term of recorded activities and information at UCSD.

Age

Calculated based on student date of birth, when available.  When the date of birth is not available this field will be null.

Majors and Minors

• Graduate Primary Major: Based on the primary major indicated by the graduate student.
• UG Primary Major: Based on the primary major indicated by the undergrad student.
• UG Primary Minor: Based on the alphabetical name order of the minors indicated by the undergrad student.
• UG Secondary Major: Based on the alphabetical name of the majors indicated by the undergrad student.
• UG Secondary Minor: Based on the alphabetical name order of the minors indicated by the undergrad student.

Term Sets

• Grad First Enrolled: Displays the academic term the grad student was first enrolled at UCSD.
• Grad First Enrolled For All Terms: Displays the term the grad student was first enrolled at UCSD, including summer sessions.
• Graduate Admit: Displays the term the grad student was first admitted to UCSD, including summer sessions.
• Graduate Cohort:
• IPEDs Cohort:
• Rolling Terms: Can be used to filter your report with rolling calendar terms so the report automatically updates itself and rolls into the next term.
• Student Last Enrolled: Displays the last term an undergrad student or grad student was enrolled at UCSD.
• UCSD First Term Grad: Displays the term the grad student was first enrolled at UCSD as a first time graduate, including summer sessions.
• UCSD UG Non-Transfer: Displays the term the undergrad student was first enrolled at UCSD as a first time first year, including summer sessions.
• UCSD UG Transfer: Displays the term the undergrad student was first enrolled at UCSD as a first time transfer, Fall only.
• UG Admit: Displays the term the undergrad student was first admitted to UCSD, including summer sessions.
• UG First Enrolled: Displays the academic term the undergrad student was first enrolled at UCSD.
• UG First Enrolled For All Terms: Displays the term the undergrad student was first enrolled at UCSD, including summer sessions.

Steps to Take

Key Fields to Display

1. Withdrawal Data Code
2. Withdrawal Data Value
3. Withdrawal Effective Date
4. Withdrawal Deleted Flag
5. Withdrawal Expected End Term Code
6. Withdrawal Term Code

Key Fields to Filter on

1. Withdrawal Flag

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.