Dict-Physical

View VMF_SectionEnrollmentByTerm

Card of view VMF_SectionEnrollmentByTerm

Name	VMF_SectionEnrollmentByTerm
Comment	See MF_SectionEnrollmentByTerm in the StarsAcademicRecordPackage. This fact-view's grain is per student per section.
Dimensional Type	Fact

SQL query of the view VMF_SectionEnrollmentByTerm

select
MD_Sect_SurrogateKey,
MD_CarlTerm_SurrogateKey,
MF_SectEnrBT_CollID,
MF_SectEnrBT_TransactionID,
MD_CollPers_SurrogateKey,
MD_CollPers_SurrogateKeyNonDegr,
MD_CollPers_SurrogateKeyFAidPers,
MD_Course_SurrogateKey,
MF_SectEnrBT_SeatCount,
MF_SectEnrBT_NewRegCount,
MF_SectEnrBT_AddCount,
MF_SectEnrBT_DropCount,
MF_SectEnrBT_WithdrawnCount,
MF_SectEnrBT_CancelledCount,
MF_SectEnrBT_Action
from
MF_SECTIONENROLLMENTBYTERM

List of outgoing view references of the view VMF_SectionEnrollmentByTerm

ViewReference_32

VMD_Course

ViewReference_33

VMD_Section

ViewReference_57

VMD_CarlTerm (Shortcut)

ViewReference_58

VMD_NonDegreeStudent

ViewReference_59

VMD_FinancialAidPerson (Shortcut)

ViewReference_60

VMD_DegreeStudent (Shortcut)

List of referenced objects of the view VMF_SectionEnrollmentByTerm

MF_SectionEnrollmentByTerm

List of diagrams containing the view VMF_SectionEnrollmentByTerm

ViewsAcademicRecordDiagram

List of permissions of the view VMF_SectionEnrollmentByTerm

SELECT,VIEW DEFINITION

AcadRecordReader

List of view columns of the view VMF_SectionEnrollmentByTerm

MD_Sect_SurrogateKey

numeric

MD_CarlTerm_SurrogateKey

numeric

MF_SectEnrBT_CollID

char(7)

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.

MF_SectEnrBT_TransactionID

varchar(16)

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

MD_CollPers_SurrogateKey

numeric

MD_CollPers_SurrogateKeyNonDegr

numeric

MD_CollPers_SurrogateKeyFAidPers

numeric

MD_Course_SurrogateKey

numeric

MF_SectEnrBT_SeatCount

int

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.

MF_SectEnrBT_NewRegCount

int

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.

MF_SectEnrBT_AddCount

int

MF_SectEnrBT_DropCount

int

MF_SectEnrBT_WithdrawnCount

int

MF_SectEnrBT_CancelledCount

int

MF_SectEnrBT_Action

varchar(32)

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.

Home