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