SAH-ClassComponentSchedule-View

This view is NOT joined with:

SAH-Demographics-View
SAH-StudentStudentsStatsPerTerm-View

Includes:

Current, Historical Term Information

Granularity of the View:

Course
Class Section
Class Component Meeting

Key Fields:

Building Information
Course Information
Class Section Information
Class Component Meeting Information
Enrollment Stats
Class Component Enrollment 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.

Additional Notes:

Course = Information about a "class" that covers multiple terms. Example: BIO101
Class Section = Information about a "class" that is specific to a term. Example: Section 1, Section 2

Fields	Folder	Note
Course ID, Course Title, ...	Course	Information about a "class" that covers multiple terms. Example: BIO101
Class Section ID, Class Section Number, Class Section Title, ...	Class Section	Information about a "class" that is specific to a term.
Term, Term Code, ...	Term Set - Class Component Schedule
Room Capacity	Class Component
Room Code	Class Component
Room Type / Type Code	Class Component
Class Component Meeting Day of Week	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 Code	Class Component	1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday
Class Component Enrollment Count	Class Component Measures
Class Section Enrollment Limit	Enrollment Measures	The 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
Current Term Flag	Class Component Flags
Current Term Count	Class Component Flag Measures
DF Count DFW Count Not Passed Count	Class Section Measures	These fields are aggregated at the class section level
Building Code	Building	To query the students who are taking remote classes set this field to "RCLAS"
Building Name Full	Building	To query the students who are taking remote classes set this field to "Remote Class No Room Assigned"
Enrolled Units	Enrollment Measures	Ever Enrolled filtered for Student Currently Enrolled in the Class Section. If the term is over and grades have lapsed for that term, this field should equal Attempted Units in the SAH Census views. This measure is at the class section level.
Class Section Avg Enrolled Units	Enrollment Measures	Class Section Enrolled Units per Student / Number of Students enrolled. This measure is at the class section level.
Instruction Type	Class Section