Att_DayPart_PrevYear (ver7.2.2)
This table summarizes student attendance in terms of minutes and periods (potential and absent) for each student, school, date, and day part for each day that they have an active enrollment on valid in-session school days. It is similar to PT_MEMBERSHIP_DEFAULTS, except that it segments attendance summaries by day part.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ATT_CalcCntPresentAbsent | 7.2.2 | Varchar( 7) | [From PS_Enrollment_All] Attendance mode code from the Prefs table (ATT_CalcCntPresentsAbsences). |
Attendance_Conversion_ID | 7.2.2 | Number(10,0) | [From Bell_Schedule] Foreign key to the Attendance Conversion table. Indexed. |
Bell_Schedule_ID | 7.2.2 | Number(10,0) | [From Bell_Schedule] Foreign key to the Bell Schedule table. Indexed. |
CalendarDate | 7.2.2 | Date | [From Calendar_Day] The date value from Calendar_Day. Indexed. |
Cycle_Day_ID | 7.2.2 | Number(10,0) | [From Calendar_Day] Foreign key to the Cycle_Day table. Indexed. |
DayPartID | 7.2.2 | Number(10,0) | [From Bell_Schedule_Items] Day part with which this bell schedule item is associated. |
Dflt_Conversion_Mode_Code | 7.2.2 | Number(10,0) | [From PS_Enrollment_All] Default Conversion Mode Code. Indexed. |
FTEID | 7.2.2 | Number(10,0) | [From PS_Enrollment_All] The FTE ID from the FTE table. Indexed. |
Grade_Level | 7.2.2 | Number(10,0) | [From PS_Enrollment_All] The Student's current grade level. |
Minutes_Absent | 7.2.2 | Number(10,0) | [Derived] Actual minutes absent from attendance taken. |
OffTrack | 7.2.2 | Number(10,0) | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
OnTrack | 7.2.2 | Number(10,0) | [Derived] The value is determined from the track information returned by the PS_Enrollment_All view and the Calendar_Day track values. |
Periods_Absent | 7.2.2 | Number(10,0) | [Derived] Actual periods absent from attendance taken. |
Potential_Minutes_Present | 7.2.2 | Number(10,0) | [Derived] Potential minutes based on the student's enrollment. |
Potential_Periods_Present | 7.2.2 | Number(10,0) | [Derived] Potential periods based on the student's enrollment. |
SchoolID | 7.2.2 | Number(10,0) | [From PS_Enrollment_All] ID Linked to the School_Number from the Schools table. Indexed. |
Student_Track | 7.2.2 | Varchar( 20) | [From PS_Enrollment_All] Represents the times during the year when the Student goes to school. |
StudentID | 7.2.2 | Number(10,0) | [From PS_Enrollment_All] The internal number for the student this record is associated. Indexed. |
Track_A | 7.2.2 | Number(10,0) | [From Calendar_Day] Track A from Calendar_Day. |
Track_B | 7.2.2 | Number(10,0) | [From Calendar_Day] Track B from Calendar_Day. |
Track_C | 7.2.2 | Number(10,0) | [From Calendar_Day] Track C from Calendar_Day. |
Track_D | 7.2.2 | Number(10,0) | [From Calendar_Day] Track D from Calendar_Day. |
Track_E | 7.2.2 | Number(10,0) | [From Calendar_Day] Track E from Calendar_Day. |
Track_F | 7.2.2 | Number(10,0) | [From Calendar_Day] Track F from Calendar_Day. |
YearID | 7.2.2 | Number(10,0) | [From PS_Enrollment_All] Previous school year for the student. |
WhenModified | 7.2.2 | Date | Date when record was created or modified (records, once created, are normally never modified). |