|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactStudentSuccess_TermSnapshot |
| Database Table Name | FactStudentSuccess_TermSnapshot |
| Schema | dbo |
| Friendly Name | FactStudentSuccess_TermSnapshot |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
StudentSuccess_TermSnapshotSK |
StudentSuccess_TermSnapshotSK |
System.Int32 | ||
 |
StudentSuccessCohortSK |
StudentSuccessCohortSK |
System.Int32 | ||
|
StudentSuccessCohortTermSK |
StudentSuccessCohortTermSK |
System.Int32 | ||
|
StudentSK |
StudentSK |
System.Int32 | ||
|
StudentObjectiveSK |
StudentObjectiveSK |
System.Int32 | ||
|
TrackingTermSK |
TrackingTermSK |
System.Int32 | ||
|
CumGPA |
CumGPA |
System.Decimal | ||
|
CumGradePoints |
CumGradePoints |
System.Decimal | ||
|
CumHoursEarned |
CumHoursEarned |
System.Decimal | ||
|
CumHoursAttempted |
CumHoursAttempted |
System.Decimal | ||
|
CumGPAHours |
CumGPAHours |
System.Decimal | ||
|
TermGPA |
TermGPA |
System.Decimal | ||
|
TermGradePoints |
TermGradePoints |
System.Decimal | ||
|
TermHoursEarned |
TermHoursEarned |
System.Decimal | ||
|
TermHoursAttempted |
TermHoursAttempted |
System.Decimal | ||
|
TermGPAHours |
TermGPAHours |
System.Decimal | ||
|
EnrolledInTerm |
EnrolledInTerm |
System.Int32 | ||
|
GPA_000_199 |
GPA_000_199 |
System.Int32 | ||
|
GPA_200_249 |
GPA_200_249 |
System.Int32 | ||
|
GPA_250_299 |
GPA_250_299 |
System.Int32 | ||
|
GPA_300_349 |
GPA_300_349 |
System.Int32 | ||
|
GPA_350_Plus |
GPA_350_Plus |
System.Int32 | ||
|
DegreeBenchmark_LessThan25_Pct |
DegreeBenchmark_LessThan25_Pct |
System.Int32 | ||
|
DegreeBenchmark_25_Pct |
DegreeBenchmark_25_Pct |
System.Int32 | ||
|
DegreeBenchmark_50_Pct |
DegreeBenchmark_50_Pct |
System.Int32 | ||
|
DegreeBenchmark_75_Pct |
DegreeBenchmark_75_Pct |
System.Int32 | ||
|
DegreeBenchmark_100_Pct |
DegreeBenchmark_100_Pct |
System.Int32 | ||
|
SOAP_Clear |
SOAP_Clear |
System.Int32 | ||
|
SOAP_Warning |
SOAP_Warning |
System.Int32 | ||
|
SOAP_Appeal |
SOAP_Appeal |
System.Int32 | ||
|
SOAP_Suspension |
SOAP_Suspension |
System.Int32 | ||
|
SOAP_Probation |
SOAP_Probation |
System.Int32 | ||
|
SOAP_Dismissal |
SOAP_Dismissal |
System.Int32 | ||
|
SOAP_Other |
SOAP_Other |
System.Int32 | ||
|
GraduationProgress_NotEnrolledFor2Terms |
GraduationProgress_NotEnrolledFor2Terms |
System.Int32 | ||
|
GraduationProgress_Continueing |
GraduationProgress_Continueing |
System.Int32 | ||
|
GraduationProgress_AppliedToGraduate |
GraduationProgress_AppliedToGraduate |
System.Int32 | ||
|
GraduationProgress_Graduated |
GraduationProgress_Graduated |
System.Int32 | ||
|
IsLastTermCaptured |
System.Int32 | |||
|
GPA_None |
System.Int32 |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
StudentSuccessCohortTermSK |
DimTerm |
Table |
False |
||
StudentSuccessCohortSK |
DimStudentSuccessCohort |
Table |
False |
||
StudentSK |
DimStudent |
Table |
False |
||
StudentObjectiveSK |
DimStudentObjective |
Table |
False |
||
TrackingTermSK |
DimTerm |
Table |
False |
||
IsLastTermCaptured |
YesNoBucket |
View |
True |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
