SectionDim View

Purpose

Contains attributes of a section including with its local education agency.  Part of the Core View Collection.

SQL Object

analytics.SectionDim

Usage Notes

The section dimension contains a flattened key for section that contains aspect of the school, course information, and dates.  No one element typically fully describes the section so each attribute may be necessary to describe the sections.

Structure

Column Name

Data Type

Source Table

Description

SchoolKeystringSchool.SchoolId
SectionKeystringSection.SchoolId, Section.LocalCourseCode, Section.SchoolYear, Section.SectionIdentifier, Section.SessionName
DescriptionstringSection.LocalCourseCode, Course.CourseTitle, SectionClassPeriod.ClassPeriodName, AcademicSubjectDescriptor.AcademicSubjectDescriptorId
SectionNamestringSection.LocalCourseCode, Session.SessionName
SessionNamestringSession.SessionName
LocalCourseCodestringCourseOffering.LocalCourseCode, SectionClassPeriod.LocalCourseCode
SchoolYearintCourseOffering.SchoolYear
EducationEnvironmentDescriptorstringSection.EducationalEnvironmentDescriptorId
LocalEducationAgencyIdintSchool.LocalEducationAgencyId

Contents