StudentSectionDim View
- Stephen Fuqua
- David Clements
- Ian Christopher (Deactivated)
Owned by Stephen Fuqua
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
Column | Data Type | Source | Description |
---|---|---|---|
StudentSectionKey | string | "{StudentKey}-{SectionKey}" | Primary Key |
StudentKey | int | StudentSectionAssociation.StudentUniqueId | |
SectionKey | string | StudentSectionAssociation -Concatenation of all elements of the Section natural key | |
LocalCourseCode | string | StudentSectionAssociation..LocalCourseCode | |
Subject | string | AcademicSubjectType.CodeValue (DS 2.2) Descriptor.CodeValue (DS 3+) | |
CourseTitle | string | Course.CourseTitle | |
TeacherName | string | "{Staff.FIrstName} {Staff.LastName}" via StaffSectionAssociation | Comma-delimited list of all staff associated with the section |
StudentSectionStartDateKey | string | StudentSectionAssociation.BeginDate | YYYY-MM-DD |
StudentSectionEndDateKey | string | StudentSectionAssociation.EndDate | YYYY-MM-DD |
SchoolKey | int | StudentSectionAssociation.SchoolId | |
SchoolYear | string | StudentSectionAssociation.SchoolYear | |
LastModifiedDate | datetime | Most recent LastModifiedDate value from StudentSectionAssociation, Course, CourseOffering, AcademicSubjectType |
Contents