Data Source View Table - dbo_FactStudentGrades

Properties

Property	Value
Table Name	dbo_FactStudentGrades
Database Table Name	FactStudentGrades
Schema	dbo
Friendly Name	FactStudentGrades
Table Type	Table
Query Definition
Description

Columns

	Column Name	Friendly Name	Data Type	Computed Column Expression	Description
	StudentGradesSK	StudentGradesSK	System.Int32
	TermSK	TermSK	System.Int32
	CurriculumSK	CurriculumSK	System.Int32
	StudentSK	StudentSK	System.Int32
	StudentTermSK	StudentTermSK	System.Int32
	FTEClassificationSK	FTEClassificationSK	System.Int32
	GradeSuccess	GradeSuccess	System.Int32
	GradeMarginal	GradeMarginal	System.Int32
	GradeFail	GradeFail	System.Int32
	GradeWithdrawal	GradeWithdrawal	System.Int32
	GradeOther	GradeOther	System.Int32
	GradeA	GradeA	System.Int32
	GradeB	GradeB	System.Int32
	GradeC	GradeC	System.Int32
	GradeD	GradeD	System.Int32
	GradeF	GradeF	System.Int32
	GradeW	GradeW	System.Int32
	GradeS	GradeS	System.Int32
	GradeP	GradeP	System.Int32
	GradeU	GradeU	System.Int32
	GradeN	GradeN	System.Int32
	GradeX	GradeX	System.Int32
	GradeI	GradeI	System.Int32
	GradeByLetterOther	GradeByLetterOther	System.Int32
	Attempt1	Attempt1	System.Int32
	Attempt2	Attempt2	System.Int32
	Attempt2OrMore	Attempt2OrMore	System.Int32
	Attempt3OrMore	Attempt3OrMore	System.Int32

Parent Relations

Table Name	Using Column	Friendly Name	Table Type	Is Logical	Description
DimCurriculum	CurriculumSK	DimCurriculum	Table	False
DimTerm	TermSK	DimTerm	Table	False
DimStudentTerm	StudentTermSK	DimStudentTerm	Table	False
DimFTEClassification	FTEClassificationSK	DimFTEClassification	Table	False
DimStudent	StudentSK	DimStudent	Table	False

Child Relations

Table Name

Using Column

Friendly Name

Table Type

Is Logical

Description

Powered by BI Documenter