PS_AdaAdm_Meeting_PtoP (ver7.2.2)
This view may be used for gathering Meeting Attendance records (using Period to Day Part conversion). These conversions, only available if day part processing is enabled using the att_daypartenabled pref, are similar to the Period to Day conversion, except separated by day part.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AttendanceValue | 7.2.2 | Real | [From Attendance_Conversion_Items] The attendance value to use for a student for a day (a real number typically a fraction of 1). |
Attendance_Conversion_ID | 7.2.2 | Longint | [From Att_DayPart_CurYear/PrevYear] Key to the Attendance_Conversion table. Indexed. |
CalendarDate | 7.2.2 | Date | [From Att_DayPart_CurYear/PrevYear] The calendar date. |
DayPartName | 7.2.2 | String 40 | [From DayPart] The text name for the day part, to be displayed in reports. |
FTEID | 7.2.2 | Longint | [From Att_DayPart_CurYear/PrevYear] Key to the FTE table. Indexed. |
Grade_Level | 7.2.2 | Longint | [From Att_DayPart_CurYear/PrevYear] The student's current grade level. |
OffTrack | 7.2.2 | Longint | [Derived] The value is determined from the track information from Att_DayPart_CurYear/PrevYear and the Calendar_Day track values. |
OnTrack | 7.2.2 | Longint | [Derived] The value is determined from the track information from Att_DayPart_CurYear/PrevYear and the Calendar_Day track values. |
PeriodCount | 7.2.2 | Longint | [Derived] Count from the PS_Attendance_Meeting view (where the count_for_ada value = 1). |
Potential_AttendanceValue | 7.2.2 | Real | [Derived] Total attendance possible for a student for a day. |
SchoolID | 7.2.2 | Longint | [From Att_DayPart_CurYear/PrevYear] The unique school identifier. Indexed. |
StudentID | 7.2.2 | Integer | [From Att_DayPart_CurYear/PrevYear] The student's ID. |
Student_Track | 7.2.2 | String 20 | [From Att_DayPart_CurYear/PrevYear] Represents the calendar days during the year when the Student goes to school. |