StudentSectionDim View

Owned by Stephen Fuqua
Last updated: May 26, 2021 by David Clements

Purpose

Attributes related to a student's enrollment in a section. Part of the Core View Collection.

SQL Object

analytics.StudentSectionDim

Usage Notes

Instead of providing a view with one row per section (SectionDim ), the StudentSectionDim provides one row per student and section. This design makes it possible to link a grade fact with the StudentSectionDim in the Early Warning System Collection.

Data Sources

Data Standard 2.2

Data Standard 3+

Structure

ColumnData TypeSource Description
​StudentSectionKeystring​"{StudentKey}-{SectionKey}"​Primary Key
StudentKeyintStudentSectionAssociation​.StudentUniqueId
SectionKeystringStudentSectionAssociation​ -Concatenation of all elements of the Section natural key
LocalCourseCodestringStudentSectionAssociation​..LocalCourseCode
Subjectstring

AcademicSubjectType.CodeValue (DS 2.2)

Descriptor.CodeValue (DS 3+)


CourseTitlestringCourse.CourseTitle
TeacherNamestring

"{Staff.FIrstName} {Staff.LastName}" via StaffSectionAssociation

Comma-delimited list of all staff associated with the section
StudentSectionStartDateKeystringStudentSectionAssociation.BeginDate YYYY-MM-DD
StudentSectionEndDateKeystringStudentSectionAssociation.EndDate  YYYY-MM-DD
SchoolKeyintStudentSectionAssociation.SchoolId
SchoolYearstringStudentSectionAssociation.SchoolYear
LastModifiedDatedatetimeMost recent LastModifiedDate value from StudentSectionAssociation, Course, CourseOffering, AcademicSubjectType

Contents