| Table of Contents |
|---|
Is joined with:
Summary
- Current, Historical, and First ever recorded activities and information about students from SAH-Demographics-View View and SAH-StudentStudentsStatsPerTermStudentStatsPerTerm-View
Includes:
- Only students who have been awarded a degree Current, Historical, and First ever recorded activities and information about students
- , this view includes all graduations
- Currently does NOT include students who have applied but not received a degree
Data Loads
Data is loaded nightly from oracle. To see when the data completed being loaded by UCSD into FINAH see this report: Tableau > Public > AH Data Load Status Report
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.
| Note |
|---|
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.
Granularity:
The LOD on degree view is degree per student and "Award Sequence Identifier" comes into play when multiple degrees are awarded.
Folder | Fields | Note | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Degree Awarded | Award Sequence Identifier | A 3 digit number usually assigned the order the degrees were conferred. It starts at 001 and is incremented by 1 for each subsequent degree. In cases where a student has a double major, the award could be represented as one or two award sequences. A double major can be conferred as a single award in cases when the award type and the honors for both majors are the same. If multiple awards are required any minors, area studies, programs of concentration, and latin honors will be entered on the award with the highest sequence number. | Degree Awarded | Award Honors Code | Degree Awarded | College of Graduation | Degree Awarded | Degree Type / Degree Type Code | Degree Awarded | |
| Degree Awarded DateDegree Awarded Flags | Award Sequence Identifier Flag | Indicates that the Award Sequence Identifier is equal to 1. | Degree Awarded Measures | Degree Awarded Flag Measures | ||||||
| Term Based Student | The history of students basic data | |||||||||
| Current Student | The most current student basic data | |||||||||
| Term Set - UG Admit | Primary Major Awarded | Primary Minor Awarded | Secondary Major Awarded | Secondary Minor Awarded | Third Major Awarded | Third Minor Awarded | Fourth Major Awarded | Term Set - Reported Term | based on when award is reported to UCOP | |
| Term Set - First Registered | use when looking for students who first registered for UCSD classes Note: Visitors are not included | |||||||||
| Term Set - UG First Enrolled | Note: Visitors are excluded | |||||||||
| Term Set - Awarded Term | Use this term set to view a term in which a student has been awarded |
Additional Notes:
- The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.