WISE Attendance Audit

Classic View: WI State Reporting > WISE Attendance Audit

Search Terms: 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.

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

FieldDescription
Report TypeIndicates which report generates - the Summary or the Detail.
File FormatThe 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 GenerationUse 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

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

Attendance Audit Report - Summary Type, CSV Format

Attendance Audit Report - Detail Type, HTML Format

Attendance Audit Report - Detail Type, HTML Format

Report Layout

Summary Report Type

Data ElementDescriptionType, Format and LengthCampus DatabaseCampus Interface
Local Person IDReports the Campus-assigned identification number of the staff or student.Numeric, 50 digitsPerson.personIDCensus > People > Identities > Person Information > PersonID
State School NumberReports the State School Number.Numeric, 4 digitsSchool.numberSystem Administration > Resources > School > State School Number
Student Ed Fi NumberReports the student's Ed-Fi NumberNumeric, 10 digitsPerson.edFiIdCensus > 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 TypeReports the assigned State Enrollment Type.Alphanumeric, 1 characterEnrollment.enrollment TypeStudent Information > General > Enrollments > State Reporting Fields > State Enrollment Type
Enrollment Start DateIndicates the student's first day of enrollment in the selected calendar.

Date field, 10 characters

MM/DD/YYYY

Enrollment.startDateStudent Information > General > Enrollments > General Enrollment Information > Start Date
Enrollment End DateIndicates the student's last day of enrollment in the selected calendar.

Date field, 10 characters

MM/DD/YYYY

Enrollment.endDateStudent Information > General > Enrollments > General Enrollment Information > End Date
Instructional Day CountReports the total number of Instructional Days, School Days and Attendance Days between the student's enrollment start date and enrollment end date.Numeric, 3 digitsData not storedSystem 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 digitsData 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 charactersData not stored

Student Information > General > Enrollment > Percent Enrolled


System Administrator > Calendar > Calendar > Grades > Standard Day

Detail Report Type

Data ElementDescriptionType, Format and LengthCampus DatabaseCampus Interface
State School NumberReports the State School Number.Numeric, 4 digitsSchool.numberSystem Administration > Resources > School > State School Number
Student Ed Fi NumberReports the student's Ed-Fi NumberNumeric, 10 digitsPerson.edFiIdCensus > 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
DateReports 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 TypeReports the Service Type of the student's enrollment - P, N or S.Alphabetic, 1 characterEnrollment.enrollment TypeStudent Information > General > Enrollment > General Enrollment Information > Service Type
Period ScheduleReports the name of the Period Schedule assigned to the Calendar Day.Alphanumeric, 15 charactersPeriodSchedule.nameSystem 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 digitsData 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 digitsData 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