chrab_ChronicAbsenteeismAttendanceFact

Purpose

Used for looking at student's attendance per day using the common methods for defining attendance.

SQL Object Name

analytics.chrab_ChronicAbsenteeismAttendanceFact

Data Definition and Sources

Column	Data Type	Source	Description
​StudentSchoolKey	nvarchar​	StudentSchoolAssociation	For linking to the StudentSchoolDim View.
StudentKey	nvarchar	StudentUniqueId	For linking to the StudentSchoolDim View.
SchoolKey	varchar	SchoolId	For linking to SchoolDim View.
DateKey	varchar	CalendarDateCalenderEvent	The attendance date (YYYYMMDD format)
ReportedAsPresentAtSchool	int	StudentSectionAttendanceEvent	True/False representation of the student's presence at school for the record's specific date
ReportedAsAbsentFromSchool	int	StudentSectionAttendanceEvent	True/False representation of the student's absence at school for the record's specific date
ReportedAsPresentAtHomeRoom	int	StudentSectionAttendanceEvent	True/False representation of the student's presence at their homeroom for the record's specific date
ReportedAsAbsentFromHomeRoom	int	StudentSectionAttendanceEvent	True/False representation of the student's absence at their homeroom for the record's specific date
ReportedAsIsPresentInAllSections	int	StudentSectionAttendanceEvent	True/False representation of the student's presence at all their classes for the record's specific date
ReportedAsAbsentFromAnySection	int	StudentSectionAttendanceEvent	True/False representation of the student's absence at all their classes for the record's specific date