...
...
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
...
- - This is specific to the COVID response. This is the logic used for this flag and count: BUILDING_CODE = 'RCLAS'
...
- Online Course Flag
...
- / Count - This 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.
|
| Class Section Avg Enrolled Units | Enrollment Measures | Class Section Enrolled Units per Student / Number of Students enrolled.
|
| Instruction Type | Class Section |