SAH-InstructorAssignment-View Quick Start Guide
Required Reading
This page assumes you have read (1) SAH Quick Start Guides and (2) SAH Restricted Views Quick Start Guide.
Overview
- Information about the instructors and the class sections associated with them
- In general this view shows you all the class section associated with any instructor. If an instructor has multiple class sections per term, all class sections associated with that instructor would be visible in a given term.
- This view is NOT joined with SAH-Demographics-View or SAH-StudentStudentsStatsPerTerm-View
- Instructor most prominent job appointment - This does NOT include all the appointments associated with instructors who have more than one job appointment
- Currently does NOT include Waitlist or Transfer records and Previous terms / historical records
Other Resources
- Have a field name but not sure what view to look in? Search the Activity Hub Field List
- Data is loaded nightly. To see when the data completed being loaded by UCSD into SAH see this report:  Tableau > Public > AH Data Load Status Report
- Additional support can be found in the Analytics Community of Practice
Critical Concepts
Course and Class Sections
- Course folder: includes all fields related to a Course
- Class Section folder: includes all fields related to the Class Section
- In this view there may be more than one instructor per class section, then there might be more than one row per class section.Â
Departments
- Course related departments will be labeled as 'Course Department...'
- Instructor related departments are located in the Department folder.
- The Department hierarchy only relates to the Instructors and this information comes from the Employee Activity Hub
Instructor Employee Information
- Instructor employee information (position, job, department) comes from the Employee Activity Hub based on their teaching positions. This means an instructor can have multiple positions, creating multiple rows.
Key Fields to View
- Instructor InformationÂ
- Class Section Information
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.