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

Name

Parent Table

Foreign Key Columns

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

Name

Code

VMF_SectionEnrollment

VMF_SECTIONENROLLMENT

VMF_SectionEnrollment

VMF_SECTIONENROLLMENT


List of diagrams containing the table MF_SectionEnrollment

Name

StarsAcademicRecordDiagram


List of columns of the table MF_SectionEnrollment

Name

Comment

Domain

Data Type

Length

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)

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)

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)

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

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_TransferEquivCount

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_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

 

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)

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)

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)

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

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_TransferEquivCount

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_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

 


List of indexes of the table MF_SectionEnrollment

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MF_SECTIONENROLLMENT_PK

TRUE

FALSE

TRUE

FALSE

FALSE

MF_SectionEnrollment

RELATIONSHIP_46_FK

FALSE

FALSE

FALSE

TRUE

FALSE

MF_SectionEnrollment

MF_SECTIONENROLLMENT_PK

TRUE

FALSE

TRUE

FALSE

FALSE

MF_SectionEnrollment

RELATIONSHIP_46_FK

FALSE

FALSE

FALSE

TRUE

FALSE

MF_SectionEnrollment


List of keys of the table MF_SectionEnrollment

Name

Identifier_1

Identifier_1


Previous
Home
Next