AcademicTimePeriodDim View - Experimental

Owned by Stephen Fuqua
Last updated: Jul 22, 2021

July 22, 2021

This view is already in the main branch and will be included in the Analytics Middle Tier version 2.5.0. This is considered experimental functionality with its initial release and may be subject to significant changes during the course of ongoing work with the /wiki/spaces/SKD/pages/26841349. Because of the experimental nature, patch releases of the Analytics Middle Tier might have breaking changes in this view, so it is not recommended that anyone take a hard dependency on this view until further notice.

Purpose

Brings together the School Year, Session, and Grading Period in a manner that facilitates creating a hierarchy, for example in Power BI.

  • School Year
    • Session
      • Grading Period

SQL Object

analytics.AcademicTimePeriodDim

Usage Notes

Can join to the analytics.GradingPeriodDim  to get a grading period's

  • PeriodSequence 
  • BeginDate 
  • EndDate 

Sources

Data Standard 2.2

Data Standard 3+

Structure

Same for both 2.2 and 3+ data standards.

Column

Data Type

Source

Description

AcademicTimePeriodKeyString"{Session.SchoolId}-{Session.SchoolYear}-{Session.TermDescriptorId}-{GradingPeriod.GradingPeriodDescriptorId}-{GradingPeriod.BeginDate}"Surrogate key so that modeling tools will have a unique primary key
SchoolYearKeyStringSchoolYearType.SchoolYear
SchoolYearNameStringSchoolYearType.SchoolYearDescription
IsCurrentSchoolYearBoolSchoolYearType.CurrentSchoolYear
SchoolKeyStringSession.SchoolId
SessionKeyString"{Session.SchoolId}-{Session.SchoolYear}-{Session.TermDescriptorId}"
SessionNameStringSession.SessionName
TermNameStringDescriptor.Description
GradingPeriodKeyString"{GradingPeriod.GradingPeriodDescriptorId}-{GradingPeriod.SchoolId}-{GradingPeriod.BeginDate}"
GradingPeriodNameStringDescriptor.Description
LastModifiedDateDateMost recent of (SchoolYearType.LastModifiedDate, Session.LastModifiedDate, GradingPeriod.LastModifiedDate,)