Dict-Physical

View VMF_SectionEnrollment

Card of view VMF_SectionEnrollment

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

SQL query of the view VMF_SectionEnrollment

select
MD_Sect_SurrogateKey,
MD_CarlTerm_SurrogateKey,
MF_SectEnr_CollID,
MF_SectEnr_TransactionID,
MD_CollPers_SurrogateKey,
MD_CollPers_SurrogateKeyNonDegr,
MD_CollPers_SurrogateKeyFAidPers,
MD_Course_SurrogateKey,
MF_SectEnr_SeatCount,
MF_SectEnr_NewRegCount,
MF_SectEnr_AddCount,
MF_SectEnr_DropCount,
MF_SectEnr_WithdrawnCount,
MF_SectEnr_CancelledCount,
MF_SectEnr_Action
from
MF_SECTIONENROLLMENT

List of outgoing view references of the view VMF_SectionEnrollment

ViewReference_155

VMD_Section

ViewReference_157

VMD_FinancialAidPerson (Shortcut)

ViewReference_158

VMD_DegreeStudent (Shortcut)

ViewReference_159

VMD_Course

ViewReference_161

VMD_CarlTerm (Shortcut)

List of referenced objects of the view VMF_SectionEnrollment

MF_SectionEnrollment

List of diagrams containing the view VMF_SectionEnrollment

ViewsAcademicRecordDiagram

List of permissions of the view VMF_SectionEnrollment

SELECT,VIEW DEFINITION

AcadRecordReader

List of view columns of the view VMF_SectionEnrollment

MD_Sect_SurrogateKey

numeric

MD_CarlTerm_SurrogateKey

numeric

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

MF_SectEnr_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_SectEnr_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 NOT inflated for multi-term courses, the way they are in MF_SectionEnrollmentByTerm.

MF_SectEnr_NewRegCount

int

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

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

MF_SectEnr_AddCount

int

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

MF_SectEnr_DropCount

int

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

MF_SectEnr_WithdrawnCount

int

MF_SectEnr_CancelledCount

int

MF_SectEnr_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