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".
| Column | Source Table | Source Column or Value | Data Type |
|---|
| ​StudentKey | Grade​ | StudentUniqueId | int​ |
| SchoolKey | Grade | SchoolId | int |
| GradingPeriodKey | Grade | <GradingPeriodDescriptorId>-<SchoolId>-<GradingPeriodBeginDate as YYYY-MM-DD> | nvarchar |
| StudentSectionKey | Grade | Composed from the natural key from StudentSectionAssociation | nvarchar |
| SectionKey | Grade | Composed from the natural key from Section | nvarchar |
| NumericGradeEarned | Grade or LetterGradeTranslation | If (Grade.NumericGradeEarned is not null) then Grade.NumericGradeEarned
Else lookup in LetterGradeTranslation table, using Grade.LetterGradeEarned | nvarchar |