Student Attendance Audit Report

Introduction

This is an audit report for attendance data submitted to the state via the Ed-Fi data exchange.

For students whose absences are reported to the state, the Student Attendance Detail report shows the amount of absence for each date a student is not fully present. The report also displays either the minutes attended/possible or the periods attended/possible (depending on the school’s attendance method), and the attendance percentage for the day.

Students in grade levels below 0 are included in attendance reports only if they are reported with Early Learning Setting Codes 01-05.

Selection Criteria

Selection criteria determine which database records are used in the report.

Data for each student is listed by Enrollments in the selected year.
Grade levels to include:
- Students in grade levels below 0 are included in attendance reports only if they are reported with Early Learning Setting Codes 01-05 (Courses and Program → Student Program → Participation Info Code = EC0001/EC0002/EC0003/EC0004/EC0005)
- KG – 12
The student attendance was published in Ed-Fi.
The studentUniqueId is populated in PowerSchool.
The student is NOT excluded from state reporting.
The student has an active school enrollment.
The school NOT excluded from state reporting.
For attendance based on sections, the student has an enrollment in at least one course that is NOT excluded from ADA calculations ("NE_StateExcludeFromReporting" and "Exclude_State_Rpt_YN").
On the date of the attendance event, the student must have a daily attendance record with an absent Code or Code to Day or have meeting attendance records where the percent absent is greater than zero.
Active students between Enrollment Start and End dates.

Formula

NDE ADA SHARE is calculated as (DAYS PRESENT/CALENDAR DAYS IN SESSION x (NDE FTE_Membership Value/100)) x100 then rounded to four digits after decimal place.
NDE ADM SHARE is calculated a (DAYS ENROLLED/CALENDAR DAYS IN SESSION x (NDE FTE_Membership Value/100) ) x100 then rounded to four digits after decimal place.
(NDE FTE/Membership) X 100

Report Input

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

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Notes: If your district uses Sub-District functionality, see Report Input for Sub-District Functionality. The All Schools option is only available when running the report from the District Office.
Student Selection	Indicate which students to include in the report by selecting one of the following options: The Selected Number of Students Only All Students (default) Note: If running the report for a single student, or group of students, select the students prior to running report.
Grade Levels	Select the appropriate grade levels from the pop-up menu. Leave blank to select all grades for that school.
Data to be filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Start Date	MM/DD/YYYY (For Selected Year Term)
End Date	MM/DD/YYYY (For Selected Year Term)
Attendance Code Categories	Note: These codes are state downloaded codes shown under code set mapping. Choose the appropriate attendance code categories from the pop-up menu. Leave blank to select all absences for that school. Choosing one or more attendance code categories will ensure the report includes only those absences that have at least one absence code for the day linked to the selected categories. When a category is selected, it will also include corresponding categories from other schools in the district to account for absences from classes taken at different schools.
Profile Name	EdFi Profiles

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

StudentAttendanceAudit_[Date and Timestamp].csv
Data for each student is listed by Enrollments in the selected year.

Column Name	Description	[Table]FieldName
Student ID	The State Assigned Student ID.	[Students]State_StudentNumber Derived from: [Attendance]StudentID
School Number	The Student School Number.	[Student]School_Number
School Name	The Student School Name.	[Student]School_Name
Local ID	The Student Local ID.	[Students]Student_Number
First Name	The Student Name.	[Students]First_Name
Middle Name	The Student Name.	[Students]Middle_Name
Last Name	The Student Name.	[Students]Last_Name
Grade	The Student Grade.	[Student]Grade
Entry Date	The Student Entry Date.	[Students]EntryDate (current) [ReEnrollments]EntryDate (historical)
Exit Date	The Student Exit Date.	[Students]ExitDate (current) [ReEnrollments]ExitDate (historical)
NDE Days Absent	The number of Absent days	EdFi Published Absent Values
NDE Days Present	The number of Present days	Calculated from ADA/ADM views.
NDE Days Enrolled	The number of days the student is enrolled.	Sum of NDE Days Absent + NDE Days Present
Calendar Days in Session	The number of In-session days.	EdFi Published Calendar associated Student Calendar
NDE FTE/Membership Value	The Membership Share	Membership_Share
NDE ADA Share	The average daily attendance.	Calculated from ATT_ADAADM_DEFAULTS_ALL
NDE ADM Share	The average of daily membership days.	Calculated from ATT_ADAADM_DEFAULTS_ALL