Attendance_CurYear_School (ver12.1.0)
The table supports population of table Att_DayPart_CurYear for columns Periods_Present, Minutes_Present, Potential_Minutes_Present, and Potential_Periods_Present. This table temporarily stores values for a session. After which, the values are then cleared. The table is populated and truncated by the Att_DayPart_CurYear_School procedure.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Date_Value | 12.1.0 | Date | Populated by the Calendar_Day table. Indexed. |
DayPartID | 12.1.0 | Number(10,0) | Populated by the DayPart table. Indexed. |
Minutes_Absent1 | 12.1.0 | Number | [Derived] from minutes absent for remote enrollments. |
Minutes_Absent2 | 12.1.0 | Number | [Derived] from minutes absent. |
Periods_Absent1 | 12.1.0 | Number | [Derived] from periods absent for remote enrollments. |
Periods_Absent2 | 12.1.0 | Number | [Derived] from periods absent. |
Potential_Periods_Present1 | 12.1.0 | Number | [Derived] from potential periods present for remote enrollments. |
Potential_Minutes_Present1 | 12.1.0 | Number | [Derived] from potential minutes present for remote enrollments. |
Potential_Minutes_Present2 | 12.1.0 | Number | [Derived] from potential minutes present. |
Potential_Periods_Present2 | 12.1.0 | Number | [Derived] from potential periods present. |
StudentID | 12.1.0 | Number(10,0) | Unique identifier for a student, being populated from table PT_Enrollment_All. Indexed. |
YearID | 12.1.0 | Number(10,0) | Populated by the PT_Enrollment_All table. Indexed. |