Table MF_SectionEnrollmentByTerm

Card of table MF_SectionEnrollmentByTerm

Name

MF_SectionEnrollmentByTerm

Dimensional Type

Fact

Comment

This fact table records instances of participation in sections, by term. Often used with MF_SectionSeatsByTerm, which records spaces available (i.e., it acts as a coverage table).

The grain of this table is one row per regular/traditional term (SU, FA, WB, WI, SP, SB) per section per student.

For example, if a student registers for a section of a single-term course, for SU, FA, WB, WI, SP, or SB term, then a row is added to this table. If the particular section registered for is multi-term (i.e., it spans multiple traditional SU, FA, WB, WI, SP, SB terms), then multiple rows are added (as many rows as terms during which the session is being taught).

This table answers questions like: How many students were registered for sociology classes during Fall term? How has that number varied from term to term, longitudinally?

Timing issues sometimes delay appearance of students in this table for current/future terms, e.g., when a student withdraws they may not show up in this table until after a DRP grade is registered for them.

This table does NOT answer questions like: How many students registered for course X? Reason: For multi-term courses, the numbers will be inflated. The grain of this table is ONE ROW PER REGULAR TERM (FA, WI, SP, SU) PER COURSE PER STUDENT. 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_SectionSeatsByTerm.


Check constraint name of the table MF_SectionEnrollmentByTerm

CKT_MF_SECTIONENROLLMENTBYTERM


List of outgoing references of the table MF_SectionEnrollmentByTerm

Name

Parent Table

Foreign Key Columns

DStuEnrolledForRegularTerm

MD_DegreeStudent (Shortcut)

MD_CollPers_SurrogateKey

Relationship_47

MD_CarlTerm (Shortcut)

MD_CarlTerm_SurrogateKey

Relationship_48

MD_FinancialAidPerson (Shortcut)

MD_CollPers_SurrogateKeyFAidPers

Relationship_49

MD_Course (Shortcut)

MD_Course_SurrogateKey

Relationship_50

MD_Section (Shortcut)

MD_Sect_SurrogateKey

Relationship_179

MD_NonDegreeStudent (Shortcut)

MD_CollPers_SurrogateKeyNonDegr


List of referencing views of the table MF_SectionEnrollmentByTerm

Name

Code

VMF_SectionEnrollmentByTerm

VMF_SECTIONENROLLMENTBYTERM

VMF_SectionEnrollmentByTerm

VMF_SECTIONENROLLMENTBYTERM


List of diagrams containing the table MF_SectionEnrollmentByTerm

Name

StarsAcademicRecordDiagram


List of columns of the table MF_SectionEnrollmentByTerm

Name

Comment

Domain

Data Type

Length

MD_Sect_SurrogateKey

 

<None>

numeric

 

MD_CarlTerm_SurrogateKey

 

<None>

numeric

 

MF_SectEnrBT_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. This is the student's Colleague ID.

DW_ColleagueID

char(7)

7

MF_SectEnrBT_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_SectEnrBT_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

MD_Course_SurrogateKey

 

<None>

numeric

 

MF_SectEnrBT_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 inflated for multi-term courses, since the grain here is "by term" (as the name of the table would suggest). Hence if a student takes a two-term off-campus studies course, then the seat count for that one student will be 2, not 1. We do this because the point of this table is to analyze class-taking patterns on a per-term basis. Multi-term courses should count for more.

<None>

int

 

MF_SectEnrBT_NewRegCount

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

Values are inflated for multi-term courses, since the grain here is "by term" (as the name of the table would suggest). Hence if a student takes a two-term off-campus studies course, then the seat count for that one student will be 2, not 1. We do this because the point of this table is to analyze class-taking patterns on a per-term basis. Multi-term courses should count for more.

<None>

int

 

MF_SectEnrBT_AddCount

 

<None>

int

 

MF_SectEnrBT_DropCount

 

<None>

int

 

MF_SectEnrBT_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_SectEnrBT_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_SectEnrBT_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_SectEnrBT_WithdrawnCount

 

<None>

int

 

MF_SectEnrBT_CancelledCount

 

<None>

int

 

MF_SectEnrBT_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

 

MF_SectEnrBT_AuditKey

 

DW_AuditKey

bigint

 

MF_SectEnrBT_Timestamp

 

<None>

timestamp

 

MD_Sect_SurrogateKey

 

<None>

numeric

 

MD_CarlTerm_SurrogateKey

 

<None>

numeric

 

MF_SectEnrBT_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. This is the student's Colleague ID.

DW_ColleagueID

char(7)

7

MF_SectEnrBT_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_SectEnrBT_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

MD_Course_SurrogateKey

 

<None>

numeric

 

MF_SectEnrBT_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 inflated for multi-term courses, since the grain here is "by term" (as the name of the table would suggest). Hence if a student takes a two-term off-campus studies course, then the seat count for that one student will be 2, not 1. We do this because the point of this table is to analyze class-taking patterns on a per-term basis. Multi-term courses should count for more.

<None>

int

 

MF_SectEnrBT_NewRegCount

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

Values are inflated for multi-term courses, since the grain here is "by term" (as the name of the table would suggest). Hence if a student takes a two-term off-campus studies course, then the seat count for that one student will be 2, not 1. We do this because the point of this table is to analyze class-taking patterns on a per-term basis. Multi-term courses should count for more.

<None>

int

 

MF_SectEnrBT_AddCount

 

<None>

int

 

MF_SectEnrBT_DropCount

 

<None>

int

 

MF_SectEnrBT_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_SectEnrBT_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_SectEnrBT_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_SectEnrBT_WithdrawnCount

 

<None>

int

 

MF_SectEnrBT_CancelledCount

 

<None>

int

 

MF_SectEnrBT_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

 

MF_SectEnrBT_AuditKey

 

DW_AuditKey

bigint

 

MF_SectEnrBT_Timestamp

 

<None>

timestamp

 


List of indexes of the table MF_SectionEnrollmentByTerm

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MF_SECTIONENROLLMENTBYTERM_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MF_SectionEnrollmentByTerm

RELATIONSHIP_49_FK

FALSE

FALSE

FALSE

TRUE

FALSE

MF_SectionEnrollmentByTerm

MF_SECTIONENROLLMENTBYTERM_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MF_SectionEnrollmentByTerm

RELATIONSHIP_49_FK

FALSE

FALSE

FALSE

TRUE

FALSE

MF_SectionEnrollmentByTerm


List of keys of the table MF_SectionEnrollmentByTerm

Name

Identifier_1

Identifier_1


Previous
Home
Next