Dict-Physical

View VMF_SectionSeats

Card of view VMF_SectionSeats

Name	VMF_SectionSeats
Comment	See MF_SectionSeats. This view is used to report and analyze seats available vs. seats used, for course sections. This is primarily a Registrar/Dean of College thing. They need to know how many sections of a given class to teach, and the earlier they can know this the better. The grain of this fact view is per section (not per student per section). Some extra fields not included in MF_SectionSeats have been added here, to facilitate reporting based on weighted enrollments and seat counts (e.g., for a three-credit course, we would multiply by half, because most full courses are six credits).
Dimensional Type	Fact

SQL query of the view VMF_SectionSeats

select
MD_Sect_SurrogateKey,
MD_CarlTerm_SurrogateKey,
MD_Course_SurrogateKey,
MF_SectSeat_Capacity,
MF_SectSeat_GlobalCapacity,
MF_SectSeat_Capacity * (MF_SectSeat_Credits / 6) as MF_SectSeat_WeightedCapacity,
MF_SectSeat_GlobalCapacity * (MF_SectSeat_Credits / 6) as MF_SectSeat_WeightedGlobalCapacity,
MF_SectSeat_Enrolled * (MF_SectSeat_Credits / 6) as MF_SectSeat_WeightedEnrollment,
MF_SectSeat_Credits,
MF_SectSeat_Enrolled,
MF_SectSeat_Dropped
from
DBO.MF_SECTIONSEATS

List of outgoing view references of the view VMF_SectionSeats

ViewReference_156

VMD_Section

ViewReference_160

VMD_Course

ViewReference_162

VMD_CarlTerm (Shortcut)

List of referenced objects of the view VMF_SectionSeats

MF_SectionSeats

List of diagrams containing the view VMF_SectionSeats

ViewsAcademicRecordDiagram

List of permissions of the view VMF_SectionSeats

SELECT,VIEW DEFINITION

AcadRecordReader

SELECT,VIEW DEFINITION

FacultyReader

List of view columns of the view VMF_SectionSeats

MD_Sect_SurrogateKey

numeric

MD_CarlTerm_SurrogateKey

numeric

MD_Course_SurrogateKey

numeric

MF_SectSeat_Capacity

int

How many seats are available for a given section in a given term. This is that actual section capacity, not the 'global' capacity across all cross-listings of a section. Don't use this (usually). Use the global capacity instead.

Yes, the global capacity of a section should equal the capacity (since cross-listings are really just aliases), but because of peculiar business practices at Carleton, in which we use cross listings as a way to waitlist juniors and seniors for classes primarily for freshmen and sophomores, the two values are NOT identical.

If you use this field (capacity - as opposed to global capacity) your seat counts will be low. Generally (though not universally) you should use the global capacity instead. If you do this, though, remember to use a filter on the MD_Section dimension: MD_Sect_IsPrimaryListing = 'Yes'.

Consult the Registrar if in doubt about what to do.

MF_SectSeat_GlobalCapacity

int

Global" capacity of a section (i.e., the capacity across all cross-listings of the same section).

Yes, the global capacity of a section should equal the capacity (since cross-listings are really just aliases), but because of peculiar business practices at Carleton, in which we use cross listings as a way to waitlist juniors and seniors for classes primarily for freshmen and sophomores, the two values are NOT identical.

If you use this field, you MUST also use a a filter on the MD_Section dimension: MD_Sect_IsPrimaryListing = 'Yes' (or, equivalently, MD_Sect_IsCrossListing = 'No'). Otherwise, your numbers will be inflated.

MF_SectSeat_WeightedCapacity

MF_SectSeat_WeightedGlobalCapacity

MF_SectSeat_WeightedEnrollment

MF_SectSeatBT_Credits

float

This value is the same as MF_SectSeat_Credits.

It is included here because people may not understand to use MF_SectSeat_MaxCredit. Also, in MF_SectionSeatsByTerm, the two equivalent fields are actually different. There the max credit field cannot be exposed to users, because for multi-term courses it will inflate numbers. Instead, the credit field *must* be used.

Here either may be used, and both contain the same value.

MF_SectSeat_Enrolled

int

Count of currently enrolled, i.e., active students for a given section.

Note that if 23 students enroll, and 23 drop, then the result is 0 active students.

This is different from the counts of adds, drops, etc. in MF_SectionEnrollment and MF_SectionEnrollmentByTerm.

MF_SectSeat_Dropped

int

Count of students who have dropped a given section.

Home