equity_StudentHistoryDim

Purpose

Used to look up a historical summary of the student which includes grade summaries, discipline summaries, attendance rates, and enrollment histories.

SQL Object Name

analytics.equity_StudentHistoryDim

Data Definition and Sources

Column	Data Type	Source	Description
StudentKey	nvarchar​	Chronic Absenteeism Collection	The unique key that describes the Student
StudentSchoolKey	nvarchar	Chronic Absenteeism Collection	The student school key associated with the student's history
GradeSummary	varchar	Chronic Absenteeism Collection	The summary of a students grade for the last semester
CurrentSchoolKey	varchar	Chronic Absenteeism Collection	The current school the student is attending
AttendanceRate	decimal	Chronic Absenteeism Collection	The attendance rate for the student in the current school year
ReferralsAndSuspensions	int	Student Discipline Action View	The number of referrals and suspensions in the current school year
EnrollmentHistory	varchar	Chronic Absenteeism Collection	All the previous schools that the student attended
LastModifiedDate	datetime	Chronic Absenteeism Collection	The last date the event was modified