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. 

Critical Concepts

Pre-Joined Data

• The SAH-Withdrawal Narrow-View joins the most current withdrawal status per student+term with MajorMinorNarrow, Demographics and Student Stats Per Term data.

• This view contains students who have been withdrawn at some point.

• Withdrawal Narrow view looks at the most current withdrawal status without looking forward. It does not include future dated withdrawals.

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