ews_StudentSectionGradeFact View

Owned by Stephen Fuqua
Last updated: Jul 30, 2021
1 min read

Purpose

Records describe a student's cumulative grade in a section for each grading period.

SQL Object

analytics.ews_StudentSectionGradeFact

Data Definition and Source

Selects all Grade  records where the GradeType  is "Grading Period".

ColumnSource TableSource Column or ValueData Type
​StudentKeyGrade​StudentUniqueIdint​
SchoolKeyGradeSchoolIdint
GradingPeriodKeyGrade<GradingPeriodDescriptorId>-<SchoolId>-<GradingPeriodBeginDate as YYYY-MM-DD>nvarchar
StudentSectionKeyGradeComposed from the natural key from StudentSectionAssociationnvarchar
SectionKeyGradeComposed from the natural key from Sectionnvarchar
NumericGradeEarnedGrade or LetterGradeTranslationIf (Grade.NumericGradeEarned is not null) then Grade.NumericGradeEarned
Else lookup in LetterGradeTranslation table, using Grade.LetterGradeEarned		nvarchar

Contents