StudentProgramDim View

Purpose

Attributes related to the programs a student is a member of. Part of the Core View Collection.

SQL Object

analytics.StudentProgramDim

Usage Notes

The Student Program Dimension provides a list of Programs each student is a member of.  This information is joined by a beginning date and the education organization Id it is related to.

Structure

ColumnData TypeSource Description
BeginDatedate​StudentProgram.BeginDate
EducationOrganizationIdintProgram.EducationOrganizationId
ProgramNamestringProgram.ProgramName
StudentUSIintStudent.StudentUSI
StudentSchoolKeystringStudent.StudentUniqueId, StudentSchoolAssociation.SchoolId

Contents