/
SAH-Degree-View Quick Start Guide

SAH-Degree-View Quick Start Guide

Add yourself as a Watcher to this page to be automatically emailed with any changes to this page.

This page assumes you have read SAH Quick Start Guides and SAH Core Views Quick Start Guides

Overview


This view contains students who have been awarded a degree and student who have applied for a degree.

Critical Concepts


Pre-Joined Data

Degree Applications vs Degree Awarded

  • Degree Applications must be submitted before a Degree is awarded, but not all applications are approved

  • Degree Applications and Degree Awards come from two different systems. These systems are not designed to align.

  • Degree Application Status is from the Degree Applications tool and only applies to the applications

  • Degree Status is from the SIS tool and only applies to degrees that are awarded

Term Set - Awarded Term vs Term Set - Reported Term

  • Awarded Term = The Term in which the student was physically handed the degree.

  • Reported Term = The Term in which it was reported to UCOP that the student was given a degree.

  • These may not match, especially in the case of retroactive degrees. Retroactive degrees are not flagged in ISIS but are sometimes noted in VAC.


Doctoral Committee Chair/Co-Chair Data

  • Doctoral Committee Chair and Co-Chair data is often manually entered into the source system to allow for non-UCSD faculty for joint-degrees, and so the data available via SAH may be limited (ie. Employee ID may be missing).

 

Steps to Take


Key Fields to Display

  • Degree Record Type

  • Primary Major Awarded fields

  • Term Set - Awarded Term or Term Set - Reported Term

Key Fields to Filter On

  • Degree Record Type

 

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.

The LOD on degree view is degree per student and "Award Sequence Identifier" comes into play when multiple degrees are awarded.

 

 

Related content

Interim Solution - Adding Data to Cognos or Tableau
Interim Solution - Adding Data to Cognos or Tableau
Read with this
SAH-MajorMinorDetail-View Quick Start Guide
SAH-MajorMinorDetail-View Quick Start Guide
More like this
SAH-Enrollment-View and SAH-EnrollmentCensus-View Quick Start Guide
SAH-Enrollment-View and SAH-EnrollmentCensus-View Quick Start Guide
More like this
SAH-Demographics-View Quick Start Guide
SAH-Demographics-View Quick Start Guide
More like this
SAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View Quick Start Guide
SAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View Quick Start Guide
More like this