SAH-WaitlistAudit-View Quick Start Guide
Add yourself as a Watcher to this page to be automatically emails with any changes to this page.
Overview
The following article is a start guide for those using Waitlist 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
Only students who are currently on or were previously listed on the waitlist are included in this view.
Current and First ever records of students activities and information is coming from SAH-Demographics-View
Historical records of student activities and information is coming from SAH-StudentStudentsStatsPerTerm-View
Enrollment records are coming from SAH-Enrollment-View
Waitlist Audit Specific Data
Term Set - Waitlist: fields that can be used to display each term
Student Position on Class Section Waitlist Current
Dates
Student Added to Class Section Waitlist Date Current
Student Removed from Class Section Waitlist Date Current
Flags
Student On Class Section Waitlist Flag Current
Student Previously On Class Section Waitlist Flag Current
Steps to Take
Key Fields to Display
Course information
Class Section Information
Term Set - Waitlist
%% Waitlist Date Current
Key Fields to Filter on
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.
| Level | Key ( uniqueness / group by) | Measures |
|---|---|---|---|
1 | Student | Student PID
Tableau report developers: {FIXED[Student PID]:MIN([Measure Name...])} | All fields in the folder Current Student Flag Measures All fields in the folder Current Student Measures All fields in the folder First Student Flag Measures All fields in the folder Student Scores |
2 | Term | Term ID
Tableau report developers: {FIXED[Term ID]:MIN([Measure Name...])} | All fields in the folder Term Based Measures All fields in the folder Term Based Student Flag Measures All fields in the folder Term Flag Measures Fields in the folder Enrollment Flag Measures that start with the word Term |
3 | Course | Course ID
Tableau report developers: {FIXED[Course ID]:MIN([Measure Name...])} | All fields in the folder Enrollment Course Flag Measures Fields in the folder Enrollment Flag Measures that start with the word Course Fields in the folder Enrollment Measures that start with the word Course Fields in the folder Job Flag Measures |
4 | Class Section | Course ID + Term ID + Class Section Number / Class Section ID
Tableau report developers: {FIXED[Course ID], [Term ID], [Class Section Number]:MIN([Measure Name...])} | All fields in the folder Fields in the folder Enrollment Flag Measures that start with the word Class Section Fields in the folder Enrollment Measures that start with the word Class Section |
5 | Enrollment Record | Lowest level | All fields in the folder Enrollment Measures without a name starting with Course or Class Section |
If you still have questions or need additional assistance, please submit a ticket or email busintel@ucsd.edu