AcademicTimePeriodDim View - Experimental
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
- Session
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 |
---|---|---|---|
AcademicTimePeriodKey | String | "{Session.SchoolId}-{Session.SchoolYear}-{Session.TermDescriptorId}-{GradingPeriod.GradingPeriodDescriptorId}-{GradingPeriod.BeginDate}" | Surrogate key so that modeling tools will have a unique primary key |
SchoolYearKey | String | SchoolYearType.SchoolYear | |
SchoolYearName | String | SchoolYearType.SchoolYearDescription | |
IsCurrentSchoolYear | Bool | SchoolYearType.CurrentSchoolYear | |
SchoolKey | String | Session.SchoolId | |
SessionKey | String | "{Session.SchoolId}-{Session.SchoolYear}-{Session.TermDescriptorId}" | |
SessionName | String | Session.SessionName | |
TermName | String | Descriptor.Description | |
GradingPeriodKey | String | "{GradingPeriod.GradingPeriodDescriptorId}-{GradingPeriod.SchoolId}-{GradingPeriod.BeginDate}" | |
GradingPeriodName | String | Descriptor.Description | |
LastModifiedDate | Date | Most recent of (SchoolYearType.LastModifiedDate, Session.LastModifiedDate, GradingPeriod.LastModifiedDate,) |