PS_Daily_Att (ver6.2.0)
This view projects daily attendance information. Specifically, the view returns one row for each student for each day for each daily attendance value.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Attendance_Type | 6.2.0 | String1 | D indicates daily attendance. |
Att_Date | 6.2.0 | Date | [From Attendance] Att_Date. Date attendance was taken. Indexed. |
Daily_Att | 6.2.0 | String0 | [From Attendance_Code] Presence_Status_CD. |
DistrictNumber | 6.2.0 | String | [From Prefs] DistrictNumber. |
EntryDate | 6.2.0 | Date | [From PS_Enrollment] Entry (enrollment) date into the school. Indexed. |
ExitDate | 6.2.0 | Date | [From PS_Enrollment] Exit date from the school. Indexed. |
Grade_Level | 6.2.0 | Integer | [From PS_Enrollment] Grade_Level. |
InSession | 6.2.0 | String1 | Y indicates in session. |
Periods_Present | 6.2.0 | String0 | Null. Not applicable to daily attendance. |
Potential_Periods | 6.2.0 | String0 | Null. Not applicable to daily attendance. |
SchoolID | 6.2.0 | Longint | [From PS_Enrollment] SchoolID. Linked to the School_Number from the Schools table. Indexed. |
StudentID | 6.2.0 | Longint | [From PS_Enrollment] The internal number for the student this record is associated with. Indexed. |
YearID | 6.2.0 | Integer | [From Attendance] Year_ID. Internal representation of the calendar year. |