Present and Absent Totals (SQL)

For the current selection of students and date range, these reports give the number of school days each student was present or absent. The Present and Absent Totals (Pre-Sept 2016) (Here) should be used for date ranges prior to September 2016 and the Present and Absent Totals (Post-Sept 2016) (Here) should be used for date ranges after September 1, 2016. Found at: Start Page --> System Reports --> sqlReports 4 --> Attendance --> Present and Absent Totals

Code: Pre-Sept 2016 Here Post-Sept 2016 Here

Monthly Absent Totals (Current Selection) (SQL)

For the current selection of students, these reports give monthly and yearly totals for the number of school days each student was present or absent. There are two reports Monthly Absent Totals-LY (Current Selection) (here) when it is a leap year with 29 days in February and Monthly Absent Totals-NYL (Current Selection) (here) when there is not a leap year. Both reports are found at: Start Page --> System Reports --> sqlReports 4 --> Attendance

Code:
Non-Leap Year
Here
Leap Year
Here

Full Attendance Report (With Comments) (SQL)

For the current student selection, this report lists the student number, first name, last name, homeroom, home phone, attendance date, course number, period, attendance code and attendance comment. Found at: Start Page --> System Reports --> sqlReports 4 --> Attendance --> Full Attendance Report (With Comments) (here)

Code:
Here

Attendance Comments Report (SQL)

For the current student selection, this report lists the student number, first name, last name, attendance date, course number, period, attendance code and attendance comment for only those students who have an attendance comment. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Attendance Comments Report (here)

Code:
Here

Absence Percentage by Date (Cur School) (SQL)

The Absence Percentage by Date (Cur School) reports absence percent for a school on a given date. The following calculation is used to determine the absence percentage: (Absences) / Enrollment x 100. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Absence Percentage by Date (Cur School) (here)

Code:
Here

Absence Percent by Date Range & Grade (Cur School) (SQL)

The Absence Percent by Date Range & Grade (Cur School), reports absence percent by school and grade. For each grade level, the following calculation is used to determine the absence percentage: (Absences) / Enrollment x 100. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Absence Percent by Date Range & Grade (Cur School) (here)

Code:
Here

Attendance Count Report (Core)

The Attendance Count Report gives period by period attendance for the selected days, student(s), period(s) and code(s). It is found at Start Page --> System Reports --> Attendance Count (here)

Absentee Report (Core)

The Absentee Report gives period by period attendance for the selected day, student(s), period(s) and code(s). It is found at Start Page --> System Reports --> Absentee (here)