|
Name |
|
|
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 |
|
select |
|
Name |
Parent Table/View |
|
ViewReference_36 |
|
|
ViewReference_38 |
|
|
ViewReference_179 |
|
Name |
|
Name |
Code |
Type |
Target Package |
|
View |
|
Name |
|
Grant |
User |
|
SELECT,VIEW DEFINITION |
AcadRecordReader |
|
SELECT,VIEW DEFINITION |
StudentReader |
|
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. |
|
|
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. |
|
|
MF_StudCumStat_TermsInOCS |
int |
Count of terms during which a student was in an off-campus program. |
|
|
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). |
|
|
|
|