Purpose

Analytics end-users may want to slice and filter presentation views by grading period information, especially for viewing and aggregating grades. These calendar-related dimensions are distinct from theĀ DateDim ViewĀ because that view provides an industry-standard concept of a Date Table, whereas the school calendar dimension fields are specific to the education domain. The two could be combined; however, keeping them separate helps isolate their roles and provide flexibility on further refinements. Part of theĀ Core View Collection.

SQL Object Name

analytics.GradingPeriodDim

Data Source

Same for both data standards.

GradingPeriodDim

Structure

Column

Data Type

Source

Description

GradingPeriodKeystring"{GradingPeriodDescriptorId}-{SchoolId}-{BeginDate as YYYYMMDD}", all fields from GradingPeriodPrimary key
SchoolKeyint

GradingPeriod.SchoolId


GradingPeriodDescriptionstringDescriptor.CodeValue
PeriodSequenceintGradeingPeriod.PeriodSequence
GradingPeriodBeginDateKeystringGradingPeriod.BeginDateYYYY-MM-DD
GradingPeriodEndDateKeystringGradingPeriod.EndDateĀ YYYY-MM-DD
NumberOfDaysintGradingPeriod.TotalInstructionalDays
LastModifiedDatedatetimeGradingPeriod.LastModifiedDate

Contents

  • No labels