EnterpriseDW_SSAS
 dbo_FactStudentSuccess_FirstYearSnapshot (Data Source View Table)
  Properties
Property Value
Table Name dbo_FactStudentSuccess_FirstYearSnapshot
Database Table Name FactStudentSuccess_FirstYearSnapshot
Schema dbo
Friendly Name FactStudentSuccess_FirstYearSnapshot
Table Type Table
Query Definition
Description
  Columns
 
Column Name
Friendly Name
Data Type
Computed Column Expression
Description
In Primary Key
StudentSuccess_FirstYearSnapshotSK
StudentSuccess_FirstYearSnapshotSK
System.Int32
StudentSuccessCohortSK
StudentSuccessCohortSK
System.Int32
StudentSuccessCohortTermSK
StudentSuccessCohortTermSK
System.Int32
StudentSK
StudentSK
System.Int32
StudentObjectiveSK
StudentObjectiveSK
System.Int32
FirstYearTermSK
FirstYearTermSK
System.Int32
Meets24CreditsRequirement
Meets24CreditsRequirement
System.Int32
Meets67PctCompletedRequirement
Meets67PctCompletedRequirement
System.Int32
CompletedCollegeExpCourse
CompletedCollegeExpCourse
System.Int32
CompletedGatewayCourse
CompletedGatewayCourse
System.Int32
AttendedSummerTerm
AttendedSummerTerm
System.Int32
DidNotMeetAny1stYearSuccessFactors
DidNotMeetAny1stYearSuccessFactors
System.Int32
MeetsGPARequirement
System.Int32
  Parent Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
StudentSuccessCohortSK
DimStudentSuccessCohort
Table
False
StudentSK
DimStudent
Table
False
FirstYearTermSK
DimTerm
Table
False
StudentSuccessCohortTermSK
DimTerm
Table
False
StudentObjectiveSK
DimStudentObjective
Table
False
  Child Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
Powered by BI Documenter