Classic View: AZ State Reporting > Attendance Extract
Search Terms: Attendance Extract
The Attendance Extracts provide way for Arizona users to pull attendance data for comparison with reported AzEDS data.
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.
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.
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 with a valid state code in the Distance Learning School Summary and Distance Learning Student Summary. |
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. |
|
File names should be the following:
|
Batch Queue report title:
|
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.
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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.
| 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.
| 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
| 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
| 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
| 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
| 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
| 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
| 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:
| 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:
| 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:
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |
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. | Census > People > Demographics > Person Identifiers > Ed-Fi ID |
Last Name | The reporting student's last name. | Census > People > Demographics > Person Information > Last Name |
First Name | The reporting student's first name. | Census > People > Demographics > Person Information > First Name |
School Name | The name of the school the student is enrolled . | System Administration > Calendar > Calendar > School |
Grade | The reporting student's grade level. | Student Information > General > Enrollments > Grade |
Enrollment Start Date | The student's enrollment record start date. | Student Information > General > Enrollments > Start Date |
Enrollment End Date | The student's enrollment record end date. | Student Information > General > Enrollments > End Date |
Aggregate Days Enrolled | Report total number of instructional days student was enrolled
| Calculated |
Aggregate Membership days | Report total number of days student is scheduled in classes
| Calculated |
Aggregate Membership hours | Report total number of hours student is scheduled in classes
| Calculated |
Aggregate Days in Distance Learning | Report total number of scheduled days student attended virtually
| Calculated |
Aggregate Hours in Distance Learning | Report total number of scheduled hours student attended virtually
| Calculated |
Percentage of Scheduled Days in Distance Learning | Report total percent of scheduled days student attended virtually
| Calculated |
Percentage of Scheduled Hours in Distance Learning | Report total percent of scheduled days student attended virtually
| Calculated |
ELL Flag | If a student has an active EL Service record, report Y Else, report N
| Student Information > Program Participation > English Learners (EL) > EL Services > Start Date Student Information > Program Participation > English Learners (EL) > 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
| 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 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
| 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 Flag | If a student has an active IEP with one of the following disabilities in any one of the disability fields, report Y
Else, report N
| 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 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
| 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 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
| 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 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
| 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 |
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. | Census > People > Demographics > Person Identifiers > Ed-Fi ID |
Student ID | The reporting student's unique person ID. | Census > People> Demographics > Person Information > Person ID |
Last Name | The reporting student's last name. | Census > People > Demographics > Person Information > Last Name identity.lastName |
First Name | The reporting student's first name. | Census > People > Demographics > Person Information > First Name identity.firstName |
School Name | Report name of the school the student is enrolled in. | System Administration > Calendar > Calendar > School |
Grade | The grade level of the reporting student. | Student Information > General > Enrollments > Grade |
Enrollment Start Date | The student's enrollment record start date. | Student Information > General > Enrollments > Start Date enrollment.StartDate |
Enrollment End Date | The student's enrollment record end date. | Student Information > General > Enrollments > End Date enrollment.StartDate |
Attendance Type | Report the Attendance Type value (Positive, Negative Method 1, Negative Method 2) | System Administration > Calendar > Calendar > Attendance Type |
Aggregate Days Enrolled | Report total number of instructional days student was enrolled
| Calculated |
Aggregate Membership days | Report total number of days student is scheduled in classes.
| Calculated |
Aggregate Membership Hours | Report total number of hours student is scheduled in classes.
| Calculated |
Aggregate Present Minutes | Calculate sum of positive minutes. This is pulled from the positive attendance events logged in campus.
| 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.
| Calculated |
Aggregate IC Days Absent | Report total number of days student was marked absent according to what was entered in Campus
| 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.
| 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
| N/A |
Number of Classes | Report the total number of classes a student is rostered in for the time period of the extract
| 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. | Census > People > Demographics > Person Identifiers > Ed-Fi ID |
Last Name | The reporting student's Last Name. | Census > People > Demographics > Person Information > Last Name identity.lastName |
First Name | The reporting student's First Name. | Census > People > Demographics > Person Information > First Name identity.firstName |
School Name | Report name of the school the student is enrolled in | System Administration > Calendar > Calendar > School |
Enrollment Start Date | The student's enrollment record start date. | Student Information > General > Enrollments > Start Date enrollment.StartDate |
Enrollment End Date | The student's enrollment record end date. | Student Information > General > 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 |
Previous Versions
Attendance Extract (Arizona) [.2136 - .2140]
Attendance Extract (Arizona) [.2116 - .2132]
Attendance Extract (Arizona) [.2048 - .2112]
Attendance Extract (Arizona) [.2040-.2044]