IL Attendance Audit

Contents

Introduction

The IL Attendance Audit report is used to split student attendance data by enrollment type for those students who are promoted to the next grade level or who transfer to different schools within the specified date range. Attendance views and Attendance Conversions are used in the calculation of attendance days.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

For the Illinois Attendance Audit report, student enrollment records are selected.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.
The school must not be excluded from state reporting.

Student Selection

The report selects which student records to use based on the following criteria:

The student must not be excluded from state reporting.
The student must be actively enrolled at some time between report start and report end dates.
The student’s current enrollment must not be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to runningreport.
Select District	(Optional) If this option appears, select the District for which to run the report.
Grades	Select which grades to include in the report. Leave all checkboxes cleared to include all grades.
Start Date	Enter the start date for the reporting period. Students are included if they are/were enrolled at any time between Start and End Date. Format: MM/DD/YYYY
End Date	Enter the end date for the reporting period. Students are included if they are/were enrolled at any time between Start and End Date. Format: MM/DD/YYYY
Students to Include	Choose one of the following from the pop-up menu: Claimable and Non-Claimable Students Claimable Students Only Non-Claimable Students Only
Run in Validation Mode	Choose one of the following from the pop-up menu: Yes (default) – The report searches for any data errors that could impact attendance calculations. If there are no errors found, the report extracts the IL Attendance Audit report. If errors are found, the error report displays. No – The report processes without looking for data errors. No error report displays.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Grade Level	Student’s grade level at the time of the enrollment.	[Students]Grade_Level [S_IL_STU_ELL_X]Grade_Level OR [ReEnrollments]Grade_Level	Alpha-Numeric	2
2	School	Name of the school in which the student is enrolled.	[Student]SchoolID	Alpha-Numeric
3	Total # of Legal Days	Number of in session school days in the reporting date range.	N/A	Numeric	3
4	Total # of Students	Number of students actively enrolled during the reporting date range.	N/A	Numeric	N/A
5	Total Days Enrolled	Number of days of enrollment for the Total # of Students in the reporting date range.	N/A	Numeric	N/A
6	Total Days Present	Number of days the Total # of Students were present within the reporting date range.	N/A	Numeric	N/A
7	Total Days Absent	Number of days the Total # of Students were absent within the reporting date range.	N/A	Numeric	N/A
8	Percent of Attendance	Calculated. (Total Days Present / Total Days Enrolled) * 100.	N/A	Numeric	N/A
9	Average Daily Attendance	Calculated. (Total Days Present / Total # of Legal Days).	N/A	Numeric	N/A
10	Students Added	List of students added during the reporting date range, sorted by student last name, first name. Fields shown are: name, DOB, Address, School number, grade level, and Entry Date.	N/A	N/A	N/A
11	Students Dropped	List of students withdrawn during the reporting date range, sorted by student last name, first name. Fields shown are: name, DOB, Address, School number, grade level, and Entry Date.	N/A	N/A	N/A