This view is NOT joined with:

• SAH-Demographics-View 
• SAH-StudentStudentsStatsPerTerm-View

Overview

• Information about the instructors and the class sections associate dwith themSince here might be are more than one instructor per class section, then there might be more than one row per class section. 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.

Excluding:

• Waitlist or transfer records
• Previous terms / historical records

Granularity:

• Instructor and Class Section

Fields

Folder

Note

Key Fields:

• Instructor Information 
Instructor
• 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.