PS_Period_Att (ver6.2.0)
This view projects meeting attendance information. Specifically, the view returns one row for each student for each in session calendar day.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Attendance_Type | 6.2.0 | String1 | P indicates period attendance. |
Att_Date | 6.2.0 | Date | [From Calendar_Day] Date_Value. In session day of the school year for which this record is applicable. Indexed. |
Daily_Att | 6.2.0 | String0 | Null. Not applicable to period attendance. |
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_Absent | 6.2.0 | Integer | [Derived] Number of periods in which the student was marked absent for the day. |
Potential_Periods | 6.2.0 | Integer | [Derived] From the student's schedule. Number of periods in the student's bell schedule, excluding sections with the Exclude_ADA flag set. |
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 Cycle_Day] Year_ID. Internal representation of the calendar year. |