PS_Attendance_Summary (ver5.0.0)
This view projects Attendance Summary information. Specifically, the view returns one row for each student for each day for each Presence_Status_Code value.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Att_Date | 5.0.0 | Date | [From Attendance] The Attendance Date from the Attendance Code table. Indexed. |
Presence_Status_Code | 5.0.0 | String10 | [From Attendance_Code] Presence Status Code value. Indexed. |
Qty | 5.0.0 | Longint | [Derived] Number of Presence Status Code values for each date for each student. |
StudentID | 5.0.0 | Longint | [From Attendance] The internal number for the student this record is associated with. Indexed. |