|
select
MD_Sect_SurrogateKey,
MD_CarlTerm_SurrogateKey,
MD_Course_SurrogateKey,
MF_SectSeatBT_Capacity,
MF_SectSeatBT_GlobalCapacity,
MF_SectSeatBT_Capacity * (MF_SectSeatBT_Credits / 6) AS MF_SectSeatBT_WeightedCapacity,
MF_SectSeatBT_GlobalCapacity * (MF_SectSeatBT_Credits / 6) AS MF_SectSeatBT_WeightedGlobalCapacity,
MF_SectSeatBT_Enrolled * (MF_SectSeatBT_Credits / 6) AS MF_SectSeatBT_WeightedEnrollment,
MF_SectSeatBT_Credits,
MF_SectSeatBT_Enrolled,
MF_SectSeatBT_Dropped
from
MF_SECTIONSEATSBYTERM
|
|
MD_Sect_SurrogateKey
|
numeric
|
|
|
|
MD_CarlTerm_SurrogateKey
|
numeric
|
|
|
|
MD_Course_SurrogateKey
|
numeric
|
|
|
|
MF_SectSeatBT_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_SectSeatBT_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_SECTSEATBT_WEIGHTEDCAPACITY
|
|
|
|
|
MF_SECTSEATBT_WEIGHTEDGLOBALCAPACITY
|
|
|
|
|
MF_SECTSEATBT_WEIGHTEDENROLLMENT
|
|
|
|
|
MF_SectSeatBT_Credits
|
float
|
Credits per term = max credit / duration in terms.
Use this in place of MaxCredits.
Note that the duration in terms is measured using regular SU, FA, WI, SP terms. This field represents an attempt at allocating credits in such a way that the numbers can be used to analyze what's going on in regular (SU, FA, WI, SP) terms. Since some courses span multiple regular terms, we need this field.
Note that this value may be used in calculations that weight available seat counts (capacities). E.g., if a course is only three credits (as opposed to the usual six), then we can multiply the capacity by (number of credits per term / 6) to obtain a new, weighted seat count. E.g., in a three-credit course with a capacity of 10 would yield a weighted seat count of 5 ((3/6) * 10).
|
|
|
MF_SectSeatBT_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_SectionEnrollmentByTerm.
|
|
|
MF_SectSeatBT_Dropped
|
int
|
Count of students who have dropped a given section.
|
|