View VMF_StudentCumulativeStats

Card of view VMF_StudentCumulativeStats

Name

VMF_StudentCumulativeStats

Comment

See documentation on MF_StudentCumulativeStats in the StarsAcademicRecords package. The grain here is one row per student. Used for analyzing the performance (= cumulative GPA) of degree-seeking students by various attributes of degree seekers, such as home state, region, gender, major, etc.

Dimensional Type

Fact


SQL query of the view VMF_StudentCumulativeStats

select
MD_CollPers_SurrogateKey,
MD_Prosp_SurrogateKey,
MD_CollPers_SurrogateKeyFAidPers,
MF_StudCumStat_CumGPA,
MF_StudCumStat_ColleagueID,
MF_StudCumStat_RecruitmentPlusPKID,
MF_StudCumStat_TotalCredits,
MF_StudCumStat_TotalDistroCredits,
MF_StudCumStat_PrematricCredits,
MF_StudCumStat_TermsCompleted,
MF_StudCumStat_TermsInResidence,
MF_StudCumStat_TermsInOCS,
MF_StudCumStat_TermsAtOverload,
MF_StudCumStat_TermsFullTime,
MF_StudCumStat_TermsPartTime,
MF_STUDCUMSTAT_TERMSASVARSITYATHLETE,
MF_STUDCUMSTAT_TERMSASSTUDENTWORKER,
MF_StudCumStat_TermsWithNorthfieldOpt
from
MF_STUDENTCUMULATIVESTATS


List of outgoing view references of the view VMF_StudentCumulativeStats

Name

Parent Table/View

ViewReference_36

VMD_DegreeStudent

ViewReference_36

VMD_DegreeStudent

ViewReference_38

VMD_Prospect (Shortcut)

ViewReference_38

VMD_Prospect (Shortcut)

ViewReference_179

VMD_FinancialAidPerson (Shortcut)


List of referenced objects of the view VMF_StudentCumulativeStats

Name

MF_StudentCumulativeStats

MF_StudentCumulativeStats


List of shortcuts of the view VMF_StudentCumulativeStats

Name

Code

Type

Target Package

VMF_StudentCumulativeStats

VMF_STUDENTCUMULATIVESTATS

View

ViewsStudent


List of diagrams containing the view VMF_StudentCumulativeStats

Name

ViewsAcademicRecordDiagram

ViewsStudentDiagram


List of permissions of the view VMF_StudentCumulativeStats

Grant

User

SELECT,VIEW DEFINITION

AcadRecordReader

SELECT,VIEW DEFINITION

AcadRecordReader

SELECT,VIEW DEFINITION

StudentReader

SELECT,VIEW DEFINITION

StudentReader


List of view columns of the view VMF_StudentCumulativeStats

Name

Data Type

Comment

Length

MD_CollPers_SurrogateKey

numeric

Links to the current row in MD_DEGREESTUDENT. Does not keep history, since the grain of this fact table (MF_StudentCumulativeStats) is one row per student.

 

MD_Prosp_SurrogateKey

numeric

Do not expose to users; do not expose to AcademicRecordReaders. This field facilitates joins to the prospect dimension, for purposes of correlating reader ratings and such with later academic performance.

 

MD_CollPers_SurrogateKeyFAidPers

numeric

This foreign key links to the most recent row for a given person in the "financial aid person" table (MD_FINANCIALAIDPERSON). This makes it problematic to use in conjunction with a many-to-many relationship in a cube, because it will potentially eliminate aid years for each student, other than the last one.

 

MF_StudCumStat_CumGPA

float

Floating point number reflecting a student's last known cumulative GPA.

This number should not be summed (unless the summing is part of an average calculation or the like). It is already a 'summarized' value.

 

MF_StudCumStat_ColleagueID

char(7)

Used internally by the data warehouse. If you are using this field in a report, you probably are making a mistake of some kind.

 

MF_StudCumStat_RecruitmentPlusPKID

int

Used internally by the data warehouse. If you are using this field in a report of some kind, you are probably making a mistake.

 

MF_StudCumStat_TotalCredits

float

Not currently populated. Will always be zero. Do not expose to users.

 

MF_StudCumStat_TotalDistroCredits

float

 

 

MF_StudCumStat_PreMatricCredits

float

Number of credits granted before a student matriculated (can influence terms to graduate, etc.; a key performance indicator).

 

MF_StudCumStat_TermsCompleted

int

Number of terms during which a student completed a course. (Used to measure terms to graduate, a key performance indicator for our student body.)

 

MF_StudCumStat_TermsInResidence

int

Terms completed while in residence at Carleton.

Note that enrollment in Carleton-run off-campus programs counts as being in residence. But being in a Carleton-run independent study over the summer for just a few credits does not.

Only terms registered with more than 12 institutional credits attempted count.

And note again that this attribute counts completed terms.

 

MF_StudCumStat_TermsInOCS

int

Count of terms during which a student was in an off-campus program.

This attribute only counts completed terms.

 

MF_StudCumStat_TermsAtOverload

int

Number of terms during which a student took more than the standard eighteen credit course load.

 

MF_StudCumStat_TermsFullTime

int

Count of full-time terms (12 credits or more). Note that this attribute counts terms that aren't yet completed.

 

MF_StudCumStat_TermsPartTime

int

Count of terms during which a student had a part-time course load (< 12 credits), which is typically not allowed. Note that this attribute counts terms that aren't yet completed.

 

MF_StudCumStat_TermsAsVarsityAthlete

int

Count of terms during which a student was registered for a varsity sport.

 

MF_StudCumStat_TermsAsStudentWorker

int

Count of terms during which a student was in a work-study program.

 

MF_StudCumStat_TermsWithNorthfieldOpt

int

Terms during which a registered student was living off-campus (the "Northfield" housing option).

 

MD_CollPers_SurrogateKey

numeric

Links to the current row in MD_DEGREESTUDENT. Does not keep history, since the grain of this fact table (MF_StudentCumulativeStats) is one row per student.

 

MD_Prosp_SurrogateKey

numeric

Do not expose to users; do not expose to AcademicRecordReaders. This field facilitates joins to the prospect dimension, for purposes of correlating reader ratings and such with later academic performance.

 

MD_CollPers_SurrogateKeyFAidPers

numeric

This foreign key links to the most recent row for a given person in the "financial aid person" table (MD_FINANCIALAIDPERSON). This makes it problematic to use in conjunction with a many-to-many relationship in a cube, because it will potentially eliminate aid years for each student, other than the last one.

 

MF_StudCumStat_CumGPA

float

Floating point number reflecting a student's last known cumulative GPA.

This number should not be summed (unless the summing is part of an average calculation or the like). It is already a 'summarized' value.

 

MF_StudCumStat_ColleagueID

char(7)

Used internally by the data warehouse. If you are using this field in a report, you probably are making a mistake of some kind.

 

MF_StudCumStat_RecruitmentPlusPKID

int

Used internally by the data warehouse. If you are using this field in a report of some kind, you are probably making a mistake.

 

MF_StudCumStat_TotalCredits

float

Not currently populated. Will always be zero. Do not expose to users.

 

MF_StudCumStat_TotalDistroCredits

float

 

 

MF_StudCumStat_PreMatricCredits

float

Number of credits granted before a student matriculated (can influence terms to graduate, etc.; a key performance indicator).

 

MF_StudCumStat_TermsCompleted

int

Number of terms during which a student completed a course. (Used to measure terms to graduate, a key performance indicator for our student body.)

 

MF_StudCumStat_TermsInResidence

int

Terms completed while in residence at Carleton.

Note that enrollment in Carleton-run off-campus programs counts as being in residence. But being in a Carleton-run independent study over the summer for just a few credits does not.

Only terms registered with more than 12 institutional credits attempted count.

And note again that this attribute counts completed terms.

 

MF_StudCumStat_TermsInOCS

int

Count of terms during which a student was in an off-campus program.

This attribute only counts completed terms.

 

MF_StudCumStat_TermsAtOverload

int

Number of terms during which a student took more than the standard eighteen credit course load.

 

MF_StudCumStat_TermsFullTime

int

Count of full-time terms (12 credits or more). Note that this attribute counts terms that aren't yet completed.

 

MF_StudCumStat_TermsPartTime

int

Count of terms during which a student had a part-time course load (< 12 credits), which is typically not allowed. Note that this attribute counts terms that aren't yet completed.

 

MF_StudCumStat_TermsAsVarsityAthlete

int

Count of terms during which a student was registered for a varsity sport.

 

MF_StudCumStat_TermsAsStudentWorker

int

Count of terms during which a student was in a work-study program.

 

MF_StudCumStat_TermsWithNorthfieldOpt

int

Terms during which a registered student was living off-campus (the "Northfield" housing option).

 


Previous
Home
Next