Tool Search: WISE Attendance Audit

The WISE Attendance Audit Report allows districts to generate a flat file with student actual days of attendance and possible days of attendance using the same calculation that is used in the Student School Association Wisconsin Extension Resource.

Screenshot of Wise Attendance Audit, located in WI State Reporting. WISE Attendance Audi

Read - Access the WISE Attendance Audit.
Write - Generate the WISE Attendance Audit.
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

All enrollments are included in a regular school calendar, except the following:

Enrollments marked as State Exclude, No Show or WISE Exclude
Enrollments in grade levels marked as State Exclude
Enrollments in calendars marked as State Exclude
Summer School enrollments

Students who have primary enrollments and attendance data in the selected calendar report. Courses marked as Attendance are included, but periods marked as non-instructional are not included.

For the Summary report, a record reports for each applicable enrollment; for the detail report, a record for each instructional, school, attendance date captured by the student's enrollment reports.

Report Editor

Field	Description
Report Type	Indicates which report generates - the Summary or the Detail.
File Format	The extract can be generated in either Comma Separated (CSV) or HTML.
Start Date	Indicates the first date used when calculating attendance. Dates can be entered in mmddyy format, or use the calendar icon to select a date.
End Date	Indicates the last date used when calculating attendance. Dates can be entered in mmddyy format, or use the calendar icon to select a date.
Student Selection	Select students to include on the report by choosing either a Grade level of enrollment for the students or an Ad hoc Filter. To include students in all grade levels, choose All Students in the Grade Level options. Selecting an existing ad hoc filter reports only those students or courses included in those filters, if they meet the reporting requirements of the report. These options only display when the Extract Type is set to Student.
Calendar Selection	At least one calendar needs to be selected in order to generate the extract. Multiple calendars can be chosen by using the CTRL and SHIFT keys. It is advised that not all calendars be chosen at once due to the amount of data that is returned in the extracts. Calendars can be selected by active year, by school or by year. This option only displays when the Extract Type is set to Student.
Report Generation	Use the Generate Extract button to immediately display the results of the selected extract type/period. For a larger data set, use the Submit to Batch button. This allows the selection of a specific time in which the extract generates (after school hours). See the Batch Queue article for more information.

Generate the Attendance Audit Report

Select the desired Report Type.
Select the desired File Format.
Enter the appropriate Start Date and End Date.
Select students to include by choosing Grade Levels or an Ad hoc Filter.
Select the appropriate Calendars.
Click the Generate Extract or Submit to Batch. The report generates in the selected format.

Screenshot of Attendance Autdit Report, with Summary Type in CSV Format. Attendance Audit Report - Summary Type, CSV Format

Screenshot of Attendance Audit Report, with Detail Type in HTML Format Attendance Audit Report - Detail Type, HTML Format

Report Layout

Summary Report Type

Data Element	Description	Type, Format and Length	Campus Database	Campus Interface
Local Person ID	Reports the Campus-assigned identification number of the staff or student.	Numeric, 50 digits	Person.personID	Census > People > Identities > Person Information > PersonID
State School Number	Reports the State School Number.	Numeric, 4 digits	School.number	System Administration > Resources > School > State School Number
Student Ed Fi Number	Reports the student's Ed-Fi Number	Numeric, 10 digits	Person.edFiId	Census > People > Demographics > Ed-Fi ID
First Name	Reports the student's or staff person's legal first name from the current identity record. First name reports first from the Protected Identity Information fields. If all legal name fields are blank, this reports from the First Name field. Only allowable characters report (A-Z, hyphens, apostrophes, periods, spaces). If special characters are used, the accented character is removed with the equivalent non-accented character.	Alphanumeric, 50 characters	Identity.legalFirstName Identity.firstName	Census > People > Identities > Protected Identity Information > Legal First Name Census > People > Identities > Identity Information > First Name
Last Name	Reports the student's or staff person's legal last name from the current identity record. Last name reports first from the Protected Identity Information fields. If all legal name fields are blank, this reports from the Last Name field. Only allowable characters report (A-Z, hyphens, apostrophes, periods, spaces). If special characters are used, the accented character is removed with the equivalent non-accented character.	Alphanumeric, 50 characters	Identity.legalLastName Identity.lastName	Census > People > Identities > Protected Identity Information > Legal Last Name Census > People > Identities > Identity Information > Last Name
Gender	Reports the student's Gender from the current Identity record.	Alphanumeric, 1 character	Identity.gender	Census > People > Identities > Identity Information > Gender
Grade	Reports the student's Grade level of enrollment.	Alphanumeric, 2 characters	Enrollment.grade	Student Information > General > Enrollments > General Enrollment Information > Grade
State Enrollment Type	Reports the assigned State Enrollment Type.	Alphanumeric, 1 character	Enrollment.enrollment Type	Student Information > General > Enrollments > State Reporting Fields > State Enrollment Type
Enrollment Start Date	Indicates the student's first day of enrollment in the selected calendar.	Date field, 10 characters MM/DD/YYYY	Enrollment.startDate	Student Information > General > Enrollments > General Enrollment Information > Start Date
Enrollment End Date	Indicates the student's last day of enrollment in the selected calendar.	Date field, 10 characters MM/DD/YYYY	Enrollment.endDate	Student Information > General > Enrollments > General Enrollment Information > End Date
Instructional Day Count	Reports the total number of Instructional Days, School Days and Attendance Days between the student's enrollment start date and enrollment end date.	Numeric, 3 digits	Data not stored	System Administration > Calendar > Calendar > Days > Day Detail > Instruction/School/Attendance
Actual Days Attendance	Reports the student's total count of days of attendance from all enrollments in the school that have the same start date. This value reports when the State Enrollment Type is Primary; if not Primary, this field reports blank. This field is calculated based on the Start Date and End Date populated in the Extract Editor. Total of all actual days of attendance is calculated from the beginning of the enrollment to the current date. The count reports first from the Attendance Override field on the Enrollment record if that field is populated on any of the enrollments. When the Attendance Override field is not populated on all reporting enrollments, the following calculation is used: The Standard Day minutes entered on the Grade Level are used. If the student' enrollment determining the record has a grade level where the Standard Day is 0.5, the student is considered Partially Scheduled and the Partially Scheduled Students calculation should be used to determine their Attendance. If the Grade Level does NOT have Standard Day of 0.5, determine which calculation to use based on the student's Percent Enrolled. Percent Enrolled entered on the Enrollment is used to determine the calculation. If a student's enrollment determining the record has Percent Enrolled of 51 -100, or the field is not populated, the student is considered a Full Schedule student. If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student. Full Schedule Students Calculation For each instructional, attendance, school date where the student has a schedule, the student's attendance is determined as follows: If the student has no attendance marks, a value of 1 is added to actual days of attendance for that date. If the student has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of scheduled minutes for the student and the total minutes present for the student on that day. If the student's present minutes are 66% or more of the calculated minutes scheduled, a value of 1 is added to the actual days of attendance for that date. If the student's present minutes are 33% or more but less than 66% time present, a half day value (0.5) is added to the actual days of attendance for that date. If the student's present minutes are less than 33% time present, no additional values are added to the actual days of attendance for that date. Calendar Day Events that are 99: Health Emergency are ignored in the calculation. Partially Scheduled Students calculation For each instructional, attendance, school date where the student has a schedule, the student's attendance is determined as follows: If the student has no attendance marks, a value of 0.5 is added to the actual days of attendance for that date. If the student has attendance marks of Absent Excused or Absent Unexcused but is present 1 or more minutes, a value of 0.5 is added to the actual days of attendance for that date. If the student has attendance marks of Absent Excused or Absent Unexcused for the entire day with 0 minutes present, no additional values are added to the actual days of attendance for that date. Calendar Day Events that are 99: Health Emergency are ignored in the calculation. Report the total of all possible days of attendance for the date range provided.	Numeric, 5 digits	Data not stored	Student Information > General > Enrollment > Attendance Override System Administration > Calendar > Calendar > Grade Level > Standard Day System Administration > Calendar > Calendar > Days System Administration > Calendar > Calendar > Periods Student Information > General > Schedule Student Information > General > Attendance
Possible Days Attendance	Reports the student's total count of possible days of attendance from all enrollments in the school that have the same start date. This value reports when the State Enrollment Type is Primary; if not Primary, this field reports blank. This field is calculated based on the Start Date and End Date populated in the Extract Editor. Total of possible days of attendance is calculated from the beginning of the enrollment to the current date. The count reports first from the Membership Override field on the Enrollment record if that field is populated on any of the enrollments. When the Membership Override field is not populated on all reporting enrollments, the following calculation is used: The Standard Day minutes entered on the Grade Level are used. If the student' enrollment determining the record has a grade level where the Standard Day is 0.5, the student is considered Partially Scheduled and the Partially Scheduled Students calculation should be used to determine their Attendance. If the Grade Level does NOT have Standard Day of 0.5, determine which calculation to use based on the student's Percent Enrolled. Percent Enrolled entered on the Enrollment is used to determine the calculation. If a student's enrollment determining the record has Percent Enrolled of 51 -100, or the field is not populated, the student is considered a Full Schedule student. If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student. Full Schedule Students Calculation For each enrollment included in the record calculation from the enrollment start date to the current date, the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance is counted. If the student is not scheduled on that date, no possible days of attendance are counted for that date. If the student is scheduled into attendance taking courses, a value of 1 is added to the possible days of attendance. Calendar Day Events that are 99: Health Emergency are ignored in the calculation. Partially Scheduled Students calculation For each enrollment included in the record calculation from the enrollment start date to the current date, the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance are counted. If the student is not scheduled on that date, no possible days of attendance are counted for that date. If the student is scheduled into attendance taking courses, a value of 0.5 is added to the possible days of attendance. Calendar Day Events that are 99: Health Emergency are ignored in the calculation. Report the total of all possible days of attendance for the date range provided.	Numeric, 6 digits	Data not stored	Student Information > General > Enrollment > Membership Override Student Information > General > Schedule System Administration > Calendar > Calendar > Grade Level > Standard Day System Administration > Calendar > Calendar > Days System Administration > Calendar > Calendar > Periods
Attendance Percentage	Reports the percentage of Actual Days Attendance divided by the Possible Days of Attendance.	Numeric, 4 digits XX.XX	Data not stored	Student Information > General > Enrollment > Membership Override Student Information > General > Schedule System Administration > Calendar > Calendar > Grade Level > Standard Day System Administration > Calendar > Calendar > Days System Administration > Calendar > Calendar > Periods
Student Schedule	Reports whether the student is a Partial Schedule or a Full Schedule. When the student has a Percent Enrolled value that is under 50, a value of Partial Schedule due to Enrollment Percent reports. When the student is enrolled in a grade level where the Standard Day is 0.5, a value of Partial Schedule due to Grade Level reports. Otherwise, a value of Full Schedule reports.	Alphanumeric, 50 characters	Data not stored	Student Information > General > Enrollment > Percent Enrolled System Administrator > Calendar > Calendar > Grades > Standard Day

Detail Report Type

Data Element	Description	Type, Format and Length	Campus Database	Campus Interface
State School Number	Reports the State School Number.	Numeric, 4 digits	School.number	System Administration > Resources > School > State School Number
Student Ed Fi Number	Reports the student's Ed-Fi Number	Numeric, 10 digits	Person.edFiId	Census > People > Demographics > Ed-Fi ID
First Name	Reports the student's or staff person's legal first name from the current identity record. First name reports first from the Protected Identity Information fields. If all legal name fields are blank, this reports from the First Name field. Only allowable characters report (A-Z, hyphens, apostrophes, periods, spaces). If special characters are used, the accented character is removed with the equivalent non-accented character.	Alphanumeric, 50 characters	Identity.legalFirstName Identity.firstName	Census > People > Identities > Protected Identity Information > Legal First Name Census > People > Identities > Identity Information > First Name
Last Name	Reports the student's or staff person's legal last name from the current identity record. Last name reports first from the Protected Identity Information fields. If all legal name fields are blank, this reports from the Last Name field. Only allowable characters report (A-Z, hyphens, apostrophes, periods, spaces). If special characters are used, the accented character is removed with the equivalent non-accented character.	Alphanumeric, 50 characters	Identity.legalLastName Identity.lastName	Census > People > Identities > Protected Identity Information > Legal Last Name Census > People > Identities > Identity Information > Last Name
Gender	Reports the student's Legal Gender from the current Identity record. If the Legal Gender field is blank, reports from the Gender field on the current Identity record.	Alphabetic, 1 character	Identity.legalGender Identity.gender	Census > People > Identities > Protected Identity Information > Legal Gender Census > People > Identities > Identity Information > Gender
Grade	Reports the student's Grade level of enrollment.	Alphanumeric, 2 characters	Enrollment.grade	Student Information > General > Enrollments > General Enrollment Information > Grade
Date	Reports the date for each unique Instructional, School, Attendance date between the Enrollment Start Date and Enrollment End Date for each student.	Date field, 10 characters MM/DD/YYYY	Cal.date	Student Information > General > Enrollments > General Enrollment Information > Start Date, End Date System Administration > Calendar > Calendar > Days > Instructional, School, Attendance
Enrollment Service Type	Reports the Service Type of the student's enrollment - P, N or S.	Alphabetic, 1 character	Enrollment.enrollment Type	Student Information > General > Enrollment > General Enrollment Information > Service Type
Period Schedule	Reports the name of the Period Schedule assigned to the Calendar Day.	Alphanumeric, 15 characters	PeriodSchedule.name	System Administration > Calendar > Calendar > Day > Period Schedule
Instructional Minutes	Reports the total instructional minutes for the Calendar Day.	Numeric, 3 digits	Calendar.studentDay DayEvent.instructional Minutes	System Administration > Calendar > Calendar > Calendar > Instructional Minutes System Administration > Calendar > Calendar > Days
Attendance Minutes	For the reported day, the total number of Minutes Present for the student reports. If there is no attendance recorded, the full period is added to the attendance minutes for that day.	Numeric, 3 digits	Data not stored	System Administration > Calendar > Calendar > Day System Administration > Calendar > Calendar > Period Schedule Student Information > General > Attendance
Absence Minutes	For the day reported, report the total number of Minutes with an absence code of A (Absent) and a status of Excused for the Student. Subtract any Minutes Present for the period marked Absent	Numeric, 3 digits	Data not stored	System Administration > Calendar > Calendar > Day System Administration > Calendar > Calendar > Period Schedule Student Information > General > Attendance
Actual days Attendance Reported	Reports an aggregate from all enrollments in the school that have the same start date. This value reports when the State Enrollment Type is Primary; if not Primary, this field reports blank. This field is calculated based on the Start Date and End Date populated in the Extract Editor. The count reports first from the Membership Override field on the Enrollment record if that field is populated on any of the enrollments. When the Membership Override field is not populated on all reporting enrollments, the following calculation is used: The Standard Day minutes entered on the Grade Level are used. If the student' enrollment determining the record has a grade level where the Standard Day is 0.5, the student is considered Partially Scheduled and the Partially Scheduled Students calculation should be used to determine their Attendance. If the Grade Level does NOT have Standard Day of 0.5, determine which calculation to use based on the student's Percent Enrolled. Percent Enrolled entered on the Enrollment is used to determine the calculation. If a student's enrollment determining the record has Percent Enrolled of 51 -100, or the field is not populated, the student is considered a Full Schedule student. If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student. Full Schedule Students Calculation For each enrollment included in the record calculation from the start date to the end date in the extract editor, the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance is counted. If the student is not scheduled on that date, no possible days of attendance are counted for that date. If the student is scheduled into attendance taking courses, a value of 1 is added to the possible days of attendance. Calendar Day Events that are 99: Health Emergency are ignored in the calculation. Partially Scheduled Students calculation For each enrollment included in the record calculation from the start date to the end date in the extract editor, the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance are counted. If the student is not scheduled on that date, no possible days of attendance are counted for that date. If the student is scheduled into attendance taking courses, a value of 0.5 is added to the possible days of attendance. Calendar Day Events that are 99: Health Emergency are ignored in the calculation.	Numeric, 4 digits	Data not stored	System Administration > Calendar > Calendar > Day System Administration > Calendar > Calendar > Period Schedule Student Information > General > Attendance
Possible Days Attendance Reported	For each enrollment included in the record calculation from the start date to the end date in the extract editor: If the student has an active enrollment determine their schedule and a Percent Enrolled value that is under 50 is entered on the student's enrollment record, a value of 0.5 reports. If the student is enrolled in a grade level where the Standard Day is .5, a value of 0.5 reports. Otherwise, a value of 1 reports.	Numeric, 3 digits 0.00	Data not stored	System Administration > Calendar > Calendar > Day System Administration > Calendar > Calendar > Period Schedule Student Information > General > Schedule
Attendance Percentage	Reports the percentage of the Actual Days Attendance Reported value divided by the Possible Days of Attendance Reported value.	Numeric,4 digits XX.XX	Data not stored	Student Information > General > Enrollment > Membership Override Student Information > General > Schedule System Administration > Calendar > Calendar > Grade Level > Standard Day System Administration > Calendar > Calendar > Days System Administration > Calendar > Calendar > Periods

WISE Attendance Audit