Dict-Physical

Table MF_SectionSeatsByTerm

Card of table MF_SectionSeatsByTerm

Name	MF_SectionSeatsByTerm
Dimensional Type	Fact
Comment	This is a coverage table that goes with MF_SectionEnrollmentByTerm. MF_SectionEnrollmentByTerm facilitates analysis of who took what classes. MF_SectionSeatsByTerm allows us to compare these figures with offerings or seats available. The grain of this table is one row per section per regular term (SU, FA, WB, WI, SP. SB). Only includes rows that reference sections that have not been canceled.

Check constraint name of the table MF_SectionSeatsByTerm

CKT_MF_SECTIONSEATSBYTERM

List of outgoing references of the table MF_SectionSeatsByTerm

Relationship_52

MD_Section (Shortcut)

MD_Sect_SurrogateKey

Relationship_53

MD_Course (Shortcut)

MD_Course_SurrogateKey

Relationship_54

MD_CarlTerm (Shortcut)

MD_CarlTerm_SurrogateKey

List of referencing views of the table MF_SectionSeatsByTerm

VMF_SectionSeatsByTerm

VMF_SECTIONSEATSBYTERM

List of diagrams containing the table MF_SectionSeatsByTerm

StarsAcademicRecordDiagram

List of columns of the table MF_SectionSeatsByTerm

MD_Sect_SurrogateKey

<None>

numeric

MD_CarlTerm_SurrogateKey

<None>

numeric

MD_Course_SurrogateKey

<None>

numeric

MF_SectSeatBT_Capacity

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.

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.

<None>

int

MF_SectSeatBT_MaxCredit

Maximum credits obtainable in course section.

If this value is not available in Colleague (and it frequently is not), then the minimum credits obtainable is supplied instead. If neither figure is available, this field defaults to zero.

DO NOT EXPOSE THIS FIELD TO USERS because it will not aggregate properly, because of how we construct the dimension. The dimension breaks multi-term sections into multiple sections (remember that the grain is per term per section). Hence credits will be multiply counted for multi-term sections.

<None>

float

MF_SectSeatBT_Credits

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).

<None>

float

MF_SectSeatBT_GlobalCapacity

"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.

<None>

int

MF_SectSeatBT_Enrolled

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.

<None>

int

MF_SectSeatBT_Dropped

Count of students who have dropped a given section.

<None>

int

MF_SectSeatBT_InstructorCount

Number of instructors teaching a given course. This number does not take worloads or percentages taught. It is expressed as a simple integer: 1, 2, etc.

This number is used to count raw numbers of people teaching (ignoring subtleties like workload), and to provide very rough measures things like per-instructor enrollment counts (to get a rough measure of how many students each instructor is dealing with on a per-section basis - who is getting the most 'face time' with students and therefore probably shouldering a heavier load).

<None>

int

MF_SectSeatBT_AuditKey

DW_AuditKey

bigint

MF_SectSeatBT_Timestamp

<None>

timestamp