Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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
LastModifiedDatedatetimeMost recent LastModifiedDate value from StudentSectionAssociation, Course, CourseOffering, AcademicSubjectType

Contents

  • No labels