EnterpriseDW_SSAS
 Student Success Term Snapshot (StudentSuccess Measure Group)
  Properties
Property Value
Name Student Success Term Snapshot
ID Fact Student Success Term Snapshot
Measure Group Type Regular
Description
Created Timestamp Tuesday, January 28, 2014 9:54 AM
Aggregation Prefix
Data Aggregation DataAndCacheAggregatable
Estimated Rows 165902
Estimated Size 9287322
Ignore Unrelated Dimensions True
Is Linked False
Is Loaded True
Last Processed Thursday, March 09, 2017 2:39 PM
Last Schema Update Thursday, March 09, 2017 11:01 AM
Processing Mode Regular
Processing Priority 0
State Processed
Storage Location
Storage Mode Molap
  Measures
Measure Name
ID
Data Type
Description
Graduation Progress Applied To Graduate
Integer
Indication the student applied to graduated (but did not graduate) within the cohort.
Graduation Progress Continueing
Integer
Indication the student is currently enrolled for the tracking term or was enrolled in the prior term.
Cum GPA
Double
A measure of a student's academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The cumulative GPA includes all the coursework across all institutions.
Cum GPA Hours
Double
Sum of all the credit hours for all the classes and grade combinations that the institution has determined should be included in the calculation of the GPA.
Cum Grade Points
Double
Sum of the Credit Hours times the value of the grade for all the classes attempted by the student.
Cum Hours Attempted
Double
Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals).
Cum Hours Earned
Double
Sum of all the credit hours for all the classes in which the student was successful.
Degree Benchmark 100 Pct
Integer
Indication the student has completed 100 percent of the credits required to complete their program as of the end of the tracking term.
Degree Benchmark 25 Pct
Integer
Indication the student has completed between 25 and 49 percent of the credits required to complete their program as of the end of the tracking term.
Degree Benchmark 50 Pct
Integer
Indication the student has completed between 50 and 74 percent of the credits required to complete their program as of the end of the tracking term.
Degree Benchmark 75 Pct
Integer
Indication the student has completed between 75 and 99 percent of the credits required to complete their program as of the end of the tracking term.
Degree Benchmark Less Than25 Pct
Integer
Indication the student has completed less than 25 percent of the credits required to complete their program as of the end of the tracking term.
Enrolled In Term
Integer
Indication of the enrollment status of the student for the tracking term.
GPA 000 199
Integer
Indicates the Cumulative GPA for the student as of the tracking term is less than a 2.0.
GPA 200 249
Integer
Indication the Cumulative GPA for the student as of the tracking term is between 2.00 and 2.49.
GPA 250 299
Integer
Indication the Cumulative GPA for the student as of the tracking term is between 2.50 and 2.99.
GPA 300 349
Integer
Indication the Cumulative GPA for the student as of the tracking term is between 3.00 and 3.49.
GPA 350 Plus
Integer
Indication the Cumulative GPA for the student as of the tracking term is 3.50 or higher.
GPA None
Integer
Indication that no data exists for the student Cumulative GPA.
Graduation Progress Graduated
Integer
Indication the student graduated has graduated from a degree within the cohort.
Is Last Term Captured
Integer
Flag to indicate if this is the last term captured for a student.
Graduation Progress Not Enrolled For2 Terms
Integer
Indication the student is not enrolled for the tracking term and was not enrolled for the prior term.
SOAP Appeal
Integer
Indication the student's standards of academic progress for the tracking term has been Appealed.
SOAP Clear
Integer
Indication the student has a Clear standards of academic progress for the tracking term.
SOAP Dismissal
Integer
Indication the student's standards of academic progress for the tracking term is Dismissal.
SOAP Other
Integer
Indication the student's standards of academic progress for the tracking term has a value other than Clear, Warning, Appeal, Suspension, Probation or Dismissal.
SOAP Probation
Integer
Indication the student's standards of academic progress for the tracking term is Probation.
SOAP Suspension
Integer
Indication the student's standards of academic progress for the tracking term is Suspension.
SOAP Warning
Integer
Indication the student's standards of academic progress for the tracking term is Warning.
Fact Student Success Term Snapshot Count
Integer
Count of snapshot records.
Term GPA
Double
A measure of a student's academic achievement at a college; calculated by dividing the total number of grade points received by the total number attempted. The term GPA includes the coursework for the tracking term.
Term GPA Hours
Double
Sum of all the credit hours for all the classes and grade combinations that the institution had determined should be included in the calculation of the GPA for the tracking term.
Term Grade Points
Double
Sum of the Credit Hours times the value of the grade for all the classes attempted by the student for the tracking term.
Term Hours Attempted
Double
Sum of all the credit hours for all the classes in which the student enrolled (including withdrawals) for the tracking term.
Term Hours Earned
Double
Sum of all the credit hours for all the classes in which the student was successful for the tracking term.
Powered by BI Documenter