PS_AdaAdm_TimeInter_Ttod (ver5.0.0)
This view may be used for gathering Time and Interval Attendance records (using Time to Day conversion).
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AttendanceValue | 5.0.0 | 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 | 5.0.0 | Longint | [From PS_Membership_Reg] Key to the Attendance_Conversion table. Indexed. |
CalendarDate | 5.0.0 | Date | [From PS_Membership_Reg] The calendar date. |
FTEID | 5.0.0 | Longint | [From PS_Membership_Reg] Key to the FTE table. Indexed. |
Grade_Level | 5.0.0 | Longint | [From PS_Membership_Reg] Student grade level. |
MembershipValue | 5.0.0 | Real | [Derived] Student membership derived from the PS_Membership_Reg view. |
SchoolID | 5.0.0 | Longint | [From PS_Membership_Reg] The unique school identifier. Indexed. |
StudentID | 5.0.0 | Longint | [From PS_Membership_Reg] The internal number for the student this record is associated with. Indexed. |
Total_Minutes | 5.0.0 | Longint | [Derived] Sum of the total minutes from the PS_Attendance_TimeInter view (where the att_mode_code is Time or Interval and status is present). |