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.

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.