Dict-Physical

Table MF_SectionEnrollment

Card of table MF_SectionEnrollment

Name	MF_SectionEnrollment
Dimensional Type	Fact
Comment	Records sections (and, by implication, courses) that students have enrolled in. Includes primary sections and non-waitlist cross-lists. Excludes canceled sections. At Carleton, students don't take courses per se, but rather register for (and complete - or not) sections. Sections are instances of courses occurring during specific terms. Terms at Carleton may actually be multi-term, in the sense that a student may register for a section that crosses multiple traditional terms, e.g., Fall-Winter 2009-2010 (as opposed to 09/FA or 10/WI). There are single terms defined in Colleague that cover situations like this, when the course actually occurs during more than one traditional term. This table will be problematic for any applications that use a time dimension, because it links to overlapping/variable length terms. Put differently, this fact table can't easily be used for analysis like how many seats are we filling in subject X or distro group Y over time period Z, because the terms here overlap and are not of any fixed length. If you're interested in this sort of analysis, use MF_SectionEnrollmentByTerm, which re-breaks classes that cross multiple regular terms into multiple rows. The grain of this table is one row per section per registered student per term (with the provisio, as noted above, that the terms may overlap, and some may extend longer than a traditional term). This table is useful for mapping out who is taking what classes in what departments and what subjects. It is NOT useful for determining exactly how many students are registered for a particular traditional term as of a particular census date. This table also can't by itself answer questions like, out of the available seat offerings, how many students actually enrolled for courses of X type? To do this sort of calculation requires a coverage table, specifically MF_SectionSeats. Note that this is FERPA-protected information. Handle accordingly.

Check constraint name of the table MF_SectionEnrollment

CKT_MF_SECTIONENROLLMENT

List of outgoing references of the table MF_SectionEnrollment

Relationship_44

MD_Section (Shortcut)

MD_Sect_SurrogateKey

Relationship_45

MD_FinancialAidPerson (Shortcut)

MD_CollPers_SurrogateKeyFAidPers

Relationship_46

MD_Course (Shortcut)

MD_Course_SurrogateKey

Relationship_155

MD_CarlTerm (Shortcut)

MD_CarlTerm_SurrogateKey

Relationship_170

MD_DegreeStudent (Shortcut)

MD_CollPers_SurrogateKey

Relationship_176

MD_NonDegreeStudent (Shortcut)

MD_CollPers_SurrogateKeyNonDegr

List of referencing views of the table MF_SectionEnrollment

VMF_SectionEnrollment

VMF_SECTIONENROLLMENT

List of diagrams containing the table MF_SectionEnrollment

StarsAcademicRecordDiagram

List of columns of the table MF_SectionEnrollment

MD_Sect_SurrogateKey

<None>

numeric

MD_CarlTerm_SurrogateKey

<None>

numeric

MF_SectEnr_CollID

Used for internal bookeeping during ETL process. Do not expose to users, unless they want unique student counts in SSAS. This attribute may be used for that purpose.

DW_ColleagueID

char(7)

MF_SectEnr_TransactionID

Unique key in Colleague for a row in this table. Used in ETL processes internal to the data warehouse. Do not expose to users.

DW_CodeDescShort

varchar(16)

MD_CollPers_SurrogateKey

<None>

numeric

MD_CollPers_SurrogateKeyNonDegr

<None>

numeric

MD_CollPers_SurrogateKeyFAidPers

<None>

numeric

MF_SectEnr_Action

Records the action taken by a particular student, in a particular term, with respect to a particular section: Drop, Add, New, etc.

This field can be used in filters, if, for example, all you want to see are drops and counts of drops.

DW_CodeDesc

varchar(32)

MF_SectEnr_SeatCount

Count of enrolled students who occupy a seat, either through a new registration or an add. Typically the count should be sliced by term and section.

Will reflect total occupied seat count, both degree and non-degree, unless you restrict by some field in the degree or non-degree-student dimension, in which case numbers wil reflect only degree (or non-degree) students, and will reflect also whatever your filter includes.

Values are NOT inflated for multi-term courses, the way they are in MF_SectionEnrollmentByTerm.

<None>

int

MF_SectEnr_NewRegCount

Count of new registrations (doesn't include 'adds').

Values are NOT inflated for multi-term courses, the way they are in MF_SectionEnrollmentByTerm.

<None>

int

MF_SectEnr_AddCount

Values are NOT inflated for multi-term courses, the way they are in MF_SectionEnrollmentByTerm.

<None>

int

MF_SectEnr_DropCount

Values are NOT inflated for multi-term courses, the way they are in MF_SectionEnrollmentByTerm.

<None>

int

MF_SectEnr_PrelimEquivCount

Not currently populated here, because equivalencies are not related to actual sections/courses. Credits due to out-placement, transfer credits, and so on, are calculated as part of the degree-audit process, and not dealt with here. All rows will therefore have a zero, unless for some reason they are associated with a specific section.

<None>

int

MF_SectEnr_NonCourseEquivCount

<None>

int

MF_SectEnr_TransferEquivCount

<None>

int

MF_SectEnr_WithdrawnCount

<None>

int

MF_SectEnr_CancelledCount

<None>

int

MF_SectEnr_ChangeDate

Not to be exposed to users. Used to we don't have to reload all rows every time the ETL runs, but instead can just check the date of the last-loaded row and then reload from there (or from a month before this, to be safe).

<None>

datetime

MD_Course_SurrogateKey

<None>

numeric

MF_SectEnr_AuditKey

DW_AuditKey

bigint

MF_SectEnr_Timestamp

<None>

timestamp