Attendance Extract (Arizona)

Last Modified on 04/10/2024 12:56 pm CDT

Classic View: AZ State Reporting > Attendance Extract

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

Tool Rights

PATH: System Administration > User Security > Users > Tool Rights

Search Term: Tool Rights

Users must have at least R(ead) tool rights in order to view and generate the Attendance Extract.

Screenshot of the tool rights options for the 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	System Administration > Calendar > Calendar > 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.	Student Information > General > 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.	Student Information > General > 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	Student Information > General > 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	Student Information > General > 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.	Student Information > General > 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	Student Information > General > 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	Student Information > General > 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.	Student Information > General > 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	Student Information > Program Participation > English Learners (EL) > EL Services > Start Date Student Information > Program Participation > English Learners (EL) > 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.	Student Information > Program Participation > English Learners (EL) > EL Services > Start Date Student Information > Program Participation > English Learners (EL) > 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	Student Information > Program Participation > English Learners (EL) > EL Services > Start Date Student Information > Program Participation > English Learners (EL) > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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.	Student Information > General > Enrollments > Special Ed Fields > Service Start Date Student Information > General > Enrollments > Special Ed Fields > Service Exit Date Student Information > General > Enrollments > Special Ed Fields > Primary Disability Student Information > General > Enrollments > Special Ed Fields > Secondary Disability Student Information > General > Enrollments > Special Ed Fields > Tertiary Disability Student Information > General > Enrollments > Special Ed Fields > Disability 4 Student Information > General > Enrollments > Special Ed Fields > Disability 5 Student Information > General > 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

System Administration > Calendar > Calendar > 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.

Student Information > General > 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.

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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.

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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.

Student Information > General > 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

Student Information > Program Participation > English Learners (EL) > EL Services > Start Date

Student Information > Program Participation > English Learners (EL) > 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.

Student Information > Program Participation > English Learners (EL) > EL Services > Start Date

Student Information > Program Participation > English Learners (EL) > 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

Student Information > Program Participation > English Learners (EL) > EL Services > Start Date

Student Information > Program Participation > English Learners (EL) > 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

Student Information > General > Enrollments > Special Ed Fields > Service Start Date

Student Information > General > Enrollments > Special Ed Fields > Service Exit Date

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

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

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

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

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

Student Information > General > 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.