SAH-StudentSchedule-View Quick Start Guide

Owned by De Silva Jayasinghe, Kevin (Deactivated)
Last updated: May 10, 2022
3 min read

Summary

  • Designed to capture additional class components as a result of the enrolled courses from SAH-Demographics-View and SAH-StudentStudentsStatsPerTerm-View
  • Only current term and upcoming term would be included in this view (as soon as the first student is enrolled).
  • This view is not joined with enrollment view, however it does share some of the same fields as enrollment
  • This view does NOT include Waitlist or transfer records and Previous terms / historical records

Data Loads

Data is loaded nightly from oracle.  To see when the data completed being loaded by UCSD into SAH 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.

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.

  1. Course = Information about a "class" that covers multiple terms. Example: BIO101
  2. Class Section = Information about a "class" that is specific to a term. Example: Section 1, Section 2
  3. Class Component = Information about a "class" that is at the lowest schedule grain, multiple values per Class Section. Section Code level.  Example: Lecture; Lab A01; Lab A02
  4. Class Component Meeting = Lab A01 Monday at location 123, Lab A01 Wednesday at location 234


Fields

Folder

Note

Course ID, Course Title, ...Enrollment CourseInformation about a "class" that covers multiple terms. Example: BIO101
Class Section ID, Class Section Number, Class Section Title, ...Enrollment Class SectionInformation about a "class" that is specific to a term.
Term, Term Code, ...Term Set - EnrollmentStudents enrolled term or term Code, ...
Class Section Status / CodeClass Section StatusShows the information about the class section per student. Indicates if a student is 'Active', 'Canceled',  'No Credit', 'Reinstated' in that class 
Class Component Meeting Day of WeekEnrollment Class Component

Q: If a component meets on Tuesday & Thursday, how will this display?

A: Each meeting will be it's own row.

Class Component Meeting Day of Week CodeEnrollment Class Component1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday
Class Component Enrollment FlagEnrollment Flag
Class Component Enrollment CountEnrollment Flag Measures
Class Section Enrollment LimitEnrollment MeasuresThe aggregation should be set to max
Class Component Additional Meeting Type / Code

Final Examination, Midterm Examination, Makeup Session, Problem Session, Review Session, Other


FI, MI, MU, PB, RE

Attempted Units TermTerm Based Measures

This is a per Student, Per Term, calculated field = It's a fixed number per student over a term

Student ClassificationTerm Based StudentExample of the values: FR, SO, JU, SR, ...
DFW Count TermTerm Based Measures

The "DFW Count Term" is at the term level and "DFW Count" is at the course level.
These should not be used together with Course subject course. because they are at a different levels of details.

If a student has 2 DFW for 2 different courses in one term, then "DFW Count Term" will alway show 2 for all courses during that term.
But "DFW Count" would only show 1 for the specific course that the student got a DFW letter grade, otherwise it would be 0 or null.

Term Code, Term ID, ...Term Set - Student Last EnrolledThe last enrolled term is the last term a student is enrolled in a class - This would be based off of Classes
Building CodeBuildingTo query the students who are taking remote classes set this field to "RCLAS"
Building Name FullBuildingTo query the students who are taking remote classes set this field to "Remote Class No Room Assigned"

Key Fields to View

  • Building Information
  • Course Information
  • Class Section Information
  • Class Component Information
  • Enrollment Count
  • Class Section Enrollment Flag / Count
  • Class Component Enrollment Flag / Count
  • Class Section Remote Flag / Count *
  • Online Course Flag / Count **


* "Class Section Remote Flag" is specific to the COVID response. This is the logic used for this flag and count: BUILDING_CODE = 'RCLAS'

**  "Online Course Flag" is a general online course, and is unrelated to the COVID response.

Key Fields to Filter On 

  • Registration Status = 'Enrolled', 'Registered'

Additional Notes