chrab_ChronicAbsenteeismAttendanceFact
- David Clements
Owned by David Clements
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 |