Attendance Extract (Arizona)

Last Modified on 11/18/2024 10:41 am CST

Tool Search: Attendance Extract

The AZ Attendance Extract provides way for Arizona users to pull attendance data for comparison with reported AzEDS data. Additionally, the AZ Attendance Extract can be used in conjunction with the AzEDS ADM15 Report to facilitate the Charter School Audit Process.

To complete the Charter School Audit Process - Generate the Student Attendance Audit Extract using the first Instructional Day and the 40th Instructional Day. Complete the same process again for 100th Instructional Day.

There are four ways to generate this report:

Distance Learning School Summary: Provides distance learning statistics that are required by the State of Arizona.
Distance Learning Student Summary: Provides distance learning statistics per student.
Student Attendance Audit: Provides aggregate totals of attendance data per student.
Student Attendance Detail: Generates individual attendance records submitted to the state for each student.

Screenshot of the Attendance Extract Editor, located at Reporting, AZ State Reporting.

Arizona Attendance Extract

Reporting Logic

The following logic is used when generate Attendance extracts:

Report all students enrolled within the Start/End date in the calendar selected in the toolbar.

Student must be rostered into a course .

For the Distance Learning reports, the course must have a state code populated and the course must not be State Excluded.
For the Student Attendance Audit, there are no course limitations, the student just needs to be rostered in a course.

Note: The distance learning numbers are based on a student being scheduled into a course to determine what percent of time is spent distance learning. In addition, the Attendance Audit has a field to show how many courses a student is rostered into.

Ignore AOI enrollments in the Distance Learning School Summary, Distance Learning Student Summary, and Student Attendance Detail.
Note: AOI enrollments should still report on the Student Attendance Audit, we just won't populate any Ed-Fi fields

Do not report students whose enrollment records are state excluded.

Do not report students whose enrollment records are tied to a calendar that is state excluded.

Do not report students whose enrollment records are tied to a grade level that is state excluded.

Do not report students whose enrollment records are marked as "No Show".

If the Start Date is NULL, consider 7/1/YYYY as the default begin of the report time span (with YYYY as the start year set in the Campus toolbar).

If the End Date is NULL, consider currentDate as the default end of the report time span.

Distance Learning School Summary: Report school summary numbers for students that are enrolled in the selected calendars based on the start/end date selected in the extract editor.
Distance Learning Student Summary: Report 1 row for each Student/Enrollment combination.
Student Attendance Detail: Report 1 row for each Student School Attendance Event submitted.
Student Attendance Audit: Report 1 row for each Student/Enrollment combination.

File names should be the following:

Distance Learning School Summary:: AZ_DLS_School_mmddyyyy.csv
Distance Learning Student Summary: AZ_DLS_Student_mmddyyyy.csv
Student Attendance Detail: AZ_AttDet_mmddyyyy.csv
Student Attendance Audit: AZ_AttAudit_mmddyyyy.csv

Batch Queue report title:

Distance Learning School Summary: AZ Distance Learning School Extract
Distance Learning Student Summary: AZ Distance Learning Student Extract
Student Attendance Detail: AZ Attendance Detail Extract
Student Attendance Audit: AZ Attendance Audit Extract

Generate the Report

Select the Report Type.
- Distance Learning School Summary - Provides distance learning statistics that are required by the State of Arizona.
- Distance Learning Student Summary - Provides distance learning statistics per student.
- Student Attendance Audit - Provides aggregate totals of attendance data per student.
- Student Attendance Detail - Generates individual attendance records submitted to the state for each student.
Enter a Start Date.
Enter an End Date. Only active student enrollments between the start date and end date entered are considered for reporting.
Select which Grade(s) to report data.
Select the report Format.
Select which calendar(s) will report data.
Select an Ad Hoc Filter (optional).
To generate the extract immediately, click Generate Extract or to schedule when the system will process and generate the extract, select Submit to Batch.

The extracts can be resource intensive so it is recommended to always use the Submit to Batch option for the distance learning reports and the attendance audit.

Distance Learning School Summary

The Distance Learning Student Summary provides distance learning statistics that are required by the State of Arizona.

Data Element	Description and Logic	Data Source GUI Path
Schools Reporting	List out the schools selected to report based on calendars selected in the extract editor	Calendar Setup > School
Grades K-3 Number of Students Distance Learning	Calculates the number of students that attended virtually at anytime within the dates selected that are in Grades K-3. A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day.	Enrollments > Grade
Grades K-3 Percentage of scheduled days Distance Learning	Calculate the percent of days students in Grades K-3 were scheduled to attend virtually Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Grade
Grades K-3 Percentage of scheduled hours Distance Learning	Calculate the percent of hours students in Grades K-3 were scheduled to attend virtually Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Grade
Grades 4-8 Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that are in Grades 4-8 A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Grade
Grades 4-8 Percentage of scheduled days Distance Learning	Calculate the percent of days students in Grades 4-8 were scheduled to attend virtually Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Grade
Grades 4-8 Percentage of scheduled hours Distance Learning	Calculate the percent of hours students in Grades 4-8 were scheduled to attend virtually Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Grade
Grades 9-12 Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that are in Grades 9-12 A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Grade
Grades 9-12 Percentage of scheduled days Distance Learning	Calculate the percent of days students in Grades 9-12 were scheduled to attend virtually Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Grade
ELL Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that have an active EL Service record An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	English Learners (EL) Services > Start Date English Learners (EL) Services > End Date
ELL Percentage of scheduled days Distance Learning	Calculate the percent of days students with an active EL Service record were scheduled to attend virtual. An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	English Learners (EL) Services > Start Date English Learners (EL) Services > End Date
ELL Percentage of scheduled hours Distance Learning	Calculate the percent of hours students with an active EL Service record were scheduled to attend virtually. An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	English Learners (EL) Services > Start Date English Learners (EL) Services > End Date
HI Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
HI Percentage of scheduled days Distance Learning	Calculate the percent of days students with an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
HI Percentage of scheduled hours Distance Learning	Calculate the percent of hours students with an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MD-SSI Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MD-SSI Percentage of scheduled days Distance Learning	Calculate the percent of days students with an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MD-SSI Percentage of scheduled hours Distance Learning	Calculate the percent of hours students with an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
*DD, ED, MIID, SLD, SLI, OHI Number of Students Distance Learning*	Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability listed below in any one of the disability fields. Disabilities: DD (Developmental Delay) ED (Emotional Disability) MIID (Mild Intellectual Disability) SLD (Specific Learning Disability) SLI (Speech/Language Impairment) OHI (Other Health Impairment) An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
*DD, ED, MIID, SLD, SLI, OHI Percentage of scheduled days Distance Learning*	Calculate the percent of days students with an active IEP with a disability listed below in any one of the disability fields were scheduled to attend virtually Disabilities: DD (Developmental Delay) ED (Emotional Disability) MIID (Mild Intellectual Disability) SLD (Specific Learning Disability) SLI (Speech/Language Impairment) OHI (Other Health Impairment) An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
*DD, ED, MIID, SLD, SLI, OHI Percentage of scheduled hours Distance Learning*	Calculate the percent of hours students with an active IEP with a disability listed below in any one of the disability fields were scheduled to attend virtually Disabilities: DD (Developmental Delay) ED (Emotional Disability) MIID (Mild Intellectual Disability) SLD (Specific Learning Disability) SLI (Speech/Language Impairment) OHI (Other Health Impairment) An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
ED-P Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
ED-P Percentage of scheduled days Distance Learning	Calculate the percent of days students with an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
ED-P Percentage of scheduled hours Distance Learning	Calculate the percent of hours students with an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MOID Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MOID Percentage of scheduled days Distance Learning	Calculate the percent of days students with an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MOID Percentage of scheduled hours Distance Learning	Calculate the percent of hours students with an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
VI Number of Students Distance Learning	Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
VI Percentage of scheduled days Distance Learning	Calculate the percent of days students with an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
VI Percentage of scheduled hours Distance Learning	Calculate the percent of hours students with an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields were scheduled to attend virtually An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day.	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability

Data Element

Description and Logic

Data Source GUI Path

Schools Reporting

List out the schools selected to report based on calendars selected in the extract editor

Calendar Setup > School

Grades K-3 Number of Students Distance Learning

Calculates the number of students that attended virtually at anytime within the dates selected that are in Grades K-3.

A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day.

Enrollments > Grade

Grades K-3 Percentage of scheduled days Distance Learning

Calculate the percent of days students in Grades K-3 were scheduled to attend virtually

Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Grade

Grades K-3 Percentage of scheduled hours Distance Learning

Calculate the percent of hours students in Grades K-3 were scheduled to attend virtually

Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Grade

Grades 4-8 Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that are in Grades 4-8

A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Grade

Grades 4-8 Percentage of scheduled days Distance Learning

Calculate the percent of days students in Grades 4-8 were scheduled to attend virtually

Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Grade

Grades 4-8 Percentage of scheduled hours Distance Learning

Calculate the percent of hours students in Grades 4-8 were scheduled to attend virtually

Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Grade

Grades 9-12 Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that are in Grades 9-12

A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Grade

Grades 9-12 Percentage of scheduled days Distance Learning

Calculate the percent of days students in Grades 9-12 were scheduled to attend virtually

Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Grade

ELL Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active EL Service record

An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

English Learners (EL) Services > Start Date

English Learners (EL) Services > End Date

ELL Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active EL Service record were scheduled to attend virtual.

An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

English Learners (EL) Services > Start Date

English Learners (EL) Services > End Date

ELL Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active EL Service record were scheduled to attend virtually.

An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

English Learners (EL) Services > Start Date

English Learners (EL) Services > End Date

HI Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

HI Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

HI Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

MD-SSI Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

MD-SSI Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Student Information > General > Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

MD-SSI Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

DD*, ED, MIID, SLD, SLI*, OHI Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability listed below in any one of the disability fields.

Disabilities:

DD (Developmental Delay)
ED (Emotional Disability)
MIID (Mild Intellectual Disability)
SLD (Specific Learning Disability)
SLI (Speech/Language Impairment)
OHI (Other Health Impairment)

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

DD*, ED, MIID, SLD, SLI*, OHI Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active IEP with a disability listed below in any one of the disability fields were scheduled to attend virtually

Disabilities:

DD (Developmental Delay)
ED (Emotional Disability)
MIID (Mild Intellectual Disability)
SLD (Specific Learning Disability)
SLI (Speech/Language Impairment)
OHI (Other Health Impairment)

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

DD*, ED, MIID, SLD, SLI*, OHI Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active IEP with a disability listed below in any one of the disability fields were scheduled to attend virtually

Disabilities:

DD (Developmental Delay)
ED (Emotional Disability)
MIID (Mild Intellectual Disability)
SLD (Specific Learning Disability)
SLI (Speech/Language Impairment)
OHI (Other Health Impairment)

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

ED-P Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

ED-P Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

ED-P Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

MOID Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

MOID Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

MOID Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

VI Number of Students Distance Learning

Calculate the number of students that attended virtually at anytime within the dates selected that have an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

VI Percentage of scheduled days Distance Learning

Calculate the percent of days students with an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing days in distance learning by membership days only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day
If a student has more than one enrollment, only count distance learning days for the Primary enrollment
This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

VI Percentage of scheduled hours Distance Learning

Calculate the percent of hours students with an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields were scheduled to attend virtually

An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected
Calculate this by dividing hours in distance learning by membership hours only for the students that have participated in distance learning
A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day.

Enrollments > Special Ed Fields > Service Start Date

Enrollments > Special Ed Fields > Service Exit Date

Enrollments > Special Ed Fields > Primary Disability

Enrollments > Special Ed Fields > Secondary Disability

Enrollments > Special Ed Fields > Tertiary Disability

Enrollments > Special Ed Fields > Disability 4

Enrollments > Special Ed Fields > Disability 5

Enrollments > Special Ed Fields > Sixth Disability

Distance Learning Student Summary

The Distance Learning Student Summary provides distance learning statistics per student.

Data Element	Description and Logic	Data Source GUI Path
Ed-Fi ID	The reporting student's Ed-Fi ID (Student State ID).	Demographics > Person Identifiers > Student State ID
Last Name	The reporting student's last name.	Demographics > Person Information > Last Name
First Name	The reporting student's first name.	Demographics > Person Information > First Name
School Name	The name of the school the student is enrolled .	Calendar SEtup > School
Grade	The reporting student's grade level.	Enrollments > Grade
Enrollment Start Date	The student's enrollment record start date.	Enrollments > Start Date
Enrollment End Date	The student's enrollment record end date.	Enrollments > End Date
Aggregate Days Enrolled	Report total number of instructional days student was enrolled If extract editor start/end date is null, calculate enrolled days through the current date If extract editor start/end dates are populated, calculate enrolled days based on the entered dates	Calculated
Aggregate Membership days	Report total number of days student is scheduled in classes Note, we are looking at days, not instructional time. For example, if a student is only scheduled in classes for 50% of the day, we would still count this as 1. This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Calculated
Aggregate Membership hours	Report total number of hours student is scheduled in classes Calculate this by summing all hours a student was scheduled to attend classes	Calculated
Aggregate Days in Distance Learning	Report total number of scheduled days student attended virtually If extract editor start/end date is null, calculate virtual days through the current date If extract editor start/end dates are populated, calculate virtual days based on the entered dates A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day If a student has more than one enrollment, only count distance learning days for the Primary enrollment Note, we are looking at days, not instructional time. For example, if a student is only scheduled in classes for 50% of the day, we would still count this as 1. This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Calculated
Aggregate Hours in Distance Learning	Report total number of scheduled hours student attended virtually If extract editor start/end date is null, calculate virtual days through the current date If extract editor start/end dates are populated, calculate virtual days based on the entered dates A student is considered attending virtually if they are in a blended learning group that has a day event on a given instructional day or if a day event of 'Virtual Day Override' (code 99) exists on a given instructional day	Calculated
Percentage of Scheduled Days in Distance Learning	Report total percent of scheduled days student attended virtually Calculate this by dividing days in distance learning by membership days If a student has more than one enrollment, only count distance learning days for the Primary enrollment This value is calculated based on the enrollment record that is active in the calendar selected in the extract editor.	Calculated
Percentage of Scheduled Hours in Distance Learning	Report total percent of scheduled days student attended virtually Calculate this by dividing hours in distance learning by membership hours	Calculated
ELL Flag	If a student has an active EL Service record, report Y Else, report N An EL Service record is considered active when the EL Program Status is 'EL' and the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	English Learners (EL) Services > Start Date English Learners (EL) Services > End Date
HI Flag	If a student has an active IEP with a disability of HI (Hearing Impairment) in any one of the disability fields, report Y Else, report N An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MD-SSI Flag	If a student has an active IEP with a disability of MDSSI (Multiple Disabilities Sever Sensory Impairment) in any one of the disability fields, report Y Else, report N An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
*DD, ED, MIID, SLD, SLI, OHI Flag*	If a student has an active IEP with one of the following disabilities in any one of the disability fields, report Y DD (Developmental Delay) ED (Emotional Disability) MIID (Mild Intellectual Disability) SLD (Specific Learning Disability) SLI (Speech/Language Impairment) OHI (Other Health Impairment) Else, report N An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
ED-P Flag	If a student has an active IEP with a disability of EDP (Emotional Disability (Separate Facility, Private School)) in any one of the disability fields, report Y Else, report N An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
MOID Flag	If a student has an active IEP with a disability of MOID (Moderate Intellectual Disability) in any one of the disability fields, report Y Else, report N An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability
VI Flag	If a student has an active IEP with a disability of VI (Vision Impairment) in any one of the disability fields, report Y Else, report N An IEP is considered active when the start date is before or within the dates selected and the exit date is null or is after or within the dates selected	Enrollments > Special Ed Fields > Service Start Date Enrollments > Special Ed Fields > Service Exit Date Enrollments > Special Ed Fields > Primary Disability Enrollments > Special Ed Fields > Secondary Disability Enrollments > Special Ed Fields > Tertiary Disability Enrollments > Special Ed Fields > Disability 4 Enrollments > Special Ed Fields > Disability 5 Enrollments > Special Ed Fields > Sixth Disability

Student Attendance Audit

The Student Attendance Audit provides aggregate totals of attendance data per student.

This report will not populate the Aggregate Ed-Fi Days Absent field for any school year prior to the 19-20 school year. For the 19-20 school year, the field will only report if a resync of the attendance data can successfully be performed. There are no issues in reporting for the 20-21 school year and beyond.

Data Element Label	Description and Logic	Data Source GUI Path and Database Field
Ed-Fi ID	The reporting student's Ed-Fi ID (Student State ID).	Demographics > Person Identifiers > Student State ID
Student ID	The reporting student's unique person ID.	Demographics > Person Information > Person ID
Last Name	The reporting student's last name.	Demographics > Person Information > Last Name identity.lastName
First Name	The reporting student's first name.	Demographics > Person Information > First Name identity.firstName
School Name	Report name of the school the student is enrolled in.	Calendar Setup > School
Grade	The grade level of the reporting student.	Enrollments > Grade
Enrollment Start Date	The student's enrollment record start date.	Enrollments > Start Date enrollment.StartDate
Enrollment End Date	The student's enrollment record end date.	Enrollments > End Date enrollment.StartDate
Attendance Type	Report the Attendance Type value (Positive, Negative Method 1, Negative Method 2)	Calendar Setup > Attendance Type
Aggregate Days Enrolled	Report total number of instructional days student was enrolled If extract editor start/end date is null, calculate enrolled days through the current date If extract editor start/end dates are populated, calculate enrolled days based on the entered dates Reports regardless if the student is in person or virtual.	Calculated
Aggregate Membership days	Report total number of days student is scheduled in classes. AOI enrollments should be reported If multiple enrollments in the same school, only report membership days for the primary enrollment. Note, we are looking at days, not instructional time. For example, if a student is only scheduled in classes for 50% of the day, we would still count this as 1. Reports regardless if the student is in person or virtual.	Calculated
Aggregate Membership Hours	Report total number of hours student is scheduled in classes. Calculate this by summing all hours a student was scheduled to attend classes. AOI enrollments should be reported Reports regardless if the student is in person or virtual.	Calculated
Aggregate Present Minutes	Calculate sum of positive minutes. This is pulled from the positive attendance events logged in campus. Reports regardless if the student is in person or virtual.	Calculated
Aggregate Ed-Fi Days Absent	Report total number of days student was absent by retrieving all 'Excused' and 'Unexcused' Student School Attendance Event resources for given student and sum the EventDuration field. If extract editor start/end date is null, calculate absent days through the current date If extract editor start/end dates are populated, calculate absent days based on the entered dates This should ignore any AOI enrollments This should only sum the following event categories Excused Unexcused	Calculated
Aggregate IC Days Absent	Report total number of days student was marked absent according to what was entered in Campus If extract editor start/end date is null, calculate absent days through the current date If extract editor start/end dates are populated, calculate absent days based on the entered dates This should ignore any AOI enrollments Reports regardless if the student is in person or virtual. Only calculate absences for active trials.	Calculated
Aggregate Virtual Days Present	Reports the total number of days student was virtual and present. Logic retrieves all 'In Attendance - DL' Student School Attendance Event resources for given student and sums the EventDuration field, then divides by 100. If extract editor start/end date is null, calculate present days through the current date If extract editor start/end dates are populated, calculate present days based on the entered dates This should ignore any AOI enrollments This should only sum the following event category In Attendance - DL	N/A
Aggregate Virtual Days Absent	Report total number of days student was virtual and absent. Logic retrieves all 'Absence - DL' Student School Attendance Event resources for given student and sums the EventDuration field, then divides by 100 If extract editor start/end date is null, calculate present days through the current date If extract editor start/end dates are populated, calculate present days based on the entered dates This should ignore any AOI enrollments This should only sum the following event category Absence - DL	N/A
Number of Classes	Report the total number of classes a student is rostered in for the time period of the extract AOI enrollments should be reported	Calculated

Student Attendance Detail

The Student Attendance Detail generates individual attendance records submitted to the state for each student.

This report will not populate properly for any school year prior to the 19-20 school year. For the 19-20 school year, the report will only populate correctly if a resync of the attendance data can successfully be performed. There are no issues in population for the 20-21 school year and beyond.

Data Element Label	Description and Logic	Data Source GUI Path and Database Field
Ed-Fi ID	The reporting student's Ed-Fi ID (Student State ID).	Demographics > Person Identifiers > Student State ID
Last Name	The reporting student's Last Name.	Demographics > Person Information > Last Name identity.lastName
First Name	The reporting student's First Name.	Demographics > Person Information > First Name identity.firstName
School Name	Report name of the school the student is enrolled in	Calendar Setup > School
Enrollment Start Date	The student's enrollment record start date.	Enrollments > Start Date enrollment.StartDate
Enrollment End Date	The student's enrollment record end date.	Enrollments > End Date enrollment.endDate
Attendance Event Date	Report eventDate from the Student School Attendance Events resource.	Student School Attendance Events resource > Event Date
Absence Code	Report the attendanceEventCategoryDescriptor from the Student School Attendance Events resource.	Student School Attendance Events resource > Attendance Event Category Descriptor
Event Duration	Report the eventDuration from the Student School Attendance Events resource.	Student School Attendance Events resource > Event Duration

Was this helpful?

Attendance Extract (Arizona)

Reporting Logic

Generate the Report

Distance Learning School Summary

Distance Learning Student Summary

Student Attendance Audit

Student Attendance Detail

Related Articles