SAH-StudentSchedule-View Quick Start Guide
This page assumes you have read SAH Quick Start Guides and SAH Core Views Quick Start Guides
Overview
Current and near-future class schedule records for students enrolled at UCSD, shown per class component within a term.
Critical Concepts
Pre-Joined Data
Pre-Joined with SAH-Demographics-View
Pre-Joined with SAH-StudentStatsPerTerm-View so term dates and status flags (Current / Active / Future) are already available.
This view is not joined with SAH-Enrollment-View, however it does share some of the same fields as SAH-Enrollment-View
This view does NOT include Waitlist or transfer records and Previous terms / historical records
Term Visibility Rules
Only Current/Active/Future terms are included.
Past terms no longer appear once the term end date passes.
Terms without enrollment do not display.
Dropped enrollments are excluded.
Future terms may lack class section details until enrollment occurs.
Per-Class Section Data
Lets you see all class sections a student is enrolled in during a term
Lets you see future scheduled class sections for a student at the class-section level
Shows term status (Current / Active / Future) based on instructional dates
Expected Null Values
No past terms, waitlist/withdrawn not included and future terms will have missing class section details
Steps to Take
Key Fields to Display
Building Information
Course Information
Class Section Information
Class Component Information
Enrollment Count
Class Section Enrollment Flag / Count
Class Component Enrollment Flag / Count
Key Fields to Filter on
Registration Status = 'Enrolled', 'Registered'
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.
Course = Information about a "class" that covers multiple terms.
Class Section = Information about a "class" that is specific to a term and where enrollment occurs.
Class Component = Information about a "class" that is at the lowest schedule grain, multiple values per Class Section.
Class Component Meeting = Lab A01 Monday at location 123, Lab A01 Wednesday at location 234
| Level | Key (uniqueness / group by) | Measures |
|---|---|---|---|
1 | Class Section | Student PID + Term ID + Class Section ID | Measures in the following folders:
|