Arizona Ed-Fi Data v3.5 - Student School Attendance Events

Last Modified on 10/22/2022 10:12 am CDT

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This event entity represents the recording of whether a student is in attendance on a daily basis at their school.

Object Triggering for Negative Attendance

This table describes logic for triggering Negative Attendance syncing of this object.

Action	Trigger
Post	When a new attendance event is verified and saved for a student.
	Calendar Attendance Type is = 004 or Student Enrollment Type = 004 When a student has two enrollments in the same school in the same school year, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services
	Unknown attendance events will not send an event to Ed-Fi. The original post will not appear until an excuseID is entered in the attendance table.
	Do not send records if the student's enrollment is marked as a No Show or State Exclude.
	Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
	Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
	A record will send for each distinct Date and Attendance Event Category Descriptor.
	Do not send a record if the only attendance records associated with a date are marked as Tardy.
	Do not send a record if the only attendance records associated with a date are marked as Exempt.
	Do not send records if the Grade Level Exclude checkbox is marked in the grade level tied to the calendar in which the student is enrolled.
	Update the attendance event if new attendance is entered. If an attendance status is changed, the first event must be deleted from Ed-Fi and a new record sent. The Attendance Event Category Descriptor is a primary key and does now allow updates in Ed-Fi.
Delete	Delete attendance record if all attendance is removed for the day.

Object Triggering Logic for AOI Positive Attendance

Setting Up AOI Positive Attendance

For AOI positive attendance to be enabled in any school, System Administration > Attendance > Positive Attendance Preference MUST be set to Yes.
- Note: Toggling this to 'on' does nothing to preclude negative attendance or non-AOI positive attendance from working in the district.
Student must be set up with a service type = T:AOI.
Student should also have attendance type = 017.
Positive Attendance checkbox must be checked on a course.
- The regular Attendance checkbox can remain checked and will have no impact on reporting.
If a student is reporting positive AOI attendance - any other type of attendance (if entered) will be completely ignored.
AOI positive attendance will ONLY send data if present minutes exist and are entered/saved for a valid student (no defaults for being present are sent as is done with Non-AOI).
- AOI positive attendance WILL send whatever duration is saved, even if the amount of present minutes exceeds the actual course (it is based entirely off of time in/time out entered).
  - lunch minutes and passing minutes are a not looked at in any way for AOI positive attendance.
Once AOI positive attendance is entered/saved (via either teacher's campus instruction positive attendance module or via student's positive attendance module) it will automatically push to Ed-Fi, with no resync needed.

This table describes logic for triggering AOI Positive Attendance syncing of this object.

Enrollment Service Type is = T: AOI
Calendar Attendance Type is = 017 or Student Enrollment Type = 017
Do not send records if the student's enrollment is marked as a No Show or State Exclude.
Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
A record will send for each distinct Date and Attendance Event Category Descriptor.
Do not send a record on a date where a student has '0' instructional minutes.

Action	Trigger
Post	When a positive attendance amount is entered and saved to the attendance unit table.
Put	Update the attendance event if attendance events are changed/added.
Delete	Delete attendance record if all attendance is deleted for a day. Delete attendance events that exist past the end date when a student's enrollment in a course or program is ended.

Object Triggering Logic for Non-AOI Positive Attendance

This table describes logic for triggering non-AOI Positive Attendance syncing of this object.

Enrollment Service Type is NOT = T: AOI
Calendar Attendance Type is = 017 or Student Enrollment Type = 017
Do not send records if the student's enrollment is marked as a No Show or State Exclude.
Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
A record will send for each distinct Date and Attendance Event Category Descriptor.
Do not send a record on a date where a student has '0' instructional minutes.
Only positive attendance records for the school that the student is actively enrolled in on a given date are sent.

Action	Trigger
Post	Records will be suppressed for the current day and sent in a batch at midnight of each day.
Put	Update the attendance event if attendance events are changed/added for any day that is not the current day.
Delete	Delete attendance record if all attendance is deleted for any day that is not the current day. Delete attendance events that exist past the end date when a student's enrollment in a course or program is ended.

Object Triggering for Learning Modality

If a student is in blended learning group that is 100% virtual or there is a 'Virtual Code Override' day event on the calendar, then districts should not use the distance learning attendance codes on the virtual days. If the distance learning attendance codes are used in this scenario, it will create a duplicate learning modality record causing data issues at the state.

This table describes logic for triggering Learning Modality syncing of this object.

Action	Trigger
Post	Records will be sent daily for each day the student is marked as attending any part of the day remote. It will be sent through batch at midnight of the day the student is marked as attending any part of the day remote.
Post	Send attendance event if a blended learning group is added to the current day or previous days for a student that was previously 100% in person and is now remote for any portion of the day. Note: If the blended learning group is added for a future date, the attendance event will be sent at midnight on the day the membership starts.
Post	Send attendance event if a 'Virtual Override' day event is added to the current day or a previous day on the calendar. Note: If the day event is added to a future date on the calendar, the attendance event will be sent at midnight on the day of the event.
Put	Update the attendance event if attendance events are changed/added for any day the student spent any amount of the day remote.
Delete	Delete attendance record if all attendance is deleted for any day that the student attended any amount of the day remote Note: If the student is 100% virtual due to a blended learning group or 'Virtual Override' day event and attendance records are deleted, only the 'Absent' attendance events will be deleted.
Delete	Delete attendance record if student's blended learning group is updated moving the student to 100% in person when they were previously remote for any portion of the day.
Delete	Delete attendance record if the 'Virtual Override' day event is removed from the current day or a previous day on the calendar.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data remains in the ODS but no new data sends.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Post/Delete	If any part of the Natural Key Changes If the School ID changes, all data remains under the old number and a resync needs to be completed to populate data under the new number. The delete tool needs to be used to remove all data from the old School ID. If an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger. The natural key changes for Student and Sessions results in a delete/post of Student School Attendance Events. If the Attendance Status, Excuse or Date changes, a delete/post occurs.

Action

Trigger

Post/Delete

If any part of the Natural Key Changes

If the School ID changes, all data remains under the old number and a resync needs to be completed to populate data under the new number. The delete tool needs to be used to remove all data from the old School ID. If an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger.
The natural key changes for Student and Sessions results in a delete/post of Student School Attendance Events.
If the Attendance Status, Excuse or Date changes, a delete/post occurs.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Attendance sends to the scope year for the school year the attendance dates are associated with based on the student's enrollment. Data only sends for the years that have a valid configuration.

Logic

Attendance sends to the scope year for the school year the attendance dates are associated with based on the student's enrollment.

Data only sends for the years that have a valid configuration.

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
attendance	Post/Put/Delete	The primary table used for sending data for this resource.

Object Data Elements

This table describes data elements sent within the Student School Attendance Event resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
attendance Event Category Descriptor	Key for Attendance Event Category Type.	Reports when a student has a verified attendance status/excuse combination. When reporting learning modality: Report 'In Attendance - DL' (4) when student was remote for any portion of the day and was in attendance. Report 'Absence - DL' (5) when student was remote for any portion of the day and was absent during the time they were supposed to be remote.	M	Attendance > Status + Excuse	attendance. status attendance. excuse
eventDate	Date for this attendance event.	Enter the date for the attendance record being reported.	M	Attendance> Date	attendance. date
school Reference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the School resource.	M
session Reference	A reference to the related Session resource.	Reports the fields that are part of the Natural Key for the Sessions resource: For sessionName, if the Session Name Override checkbox is checked in the Session resource preferences, then report the 'District Id - Term Descriptor of the term being reported'. Otherwise, report the Term Descriptor of the term being reported. Only report the Term Type from the Terms tab that is associated with the date and term schedule for which the attendance is being reported.	M
student Reference	A reference to the related Student resource.	Reports the fields that are part of the Natural Key for the Student resource. Note: The Ed-Fi ID reports from the Student State ID field.	M
attendance Event Reason	The reported reason for a student's absence.	This is optional, does not report.	O
educational Environment Descriptor	The setting in which a child receives education and related services.	This is optional, does not report.	O
event Duration	The amount of time for the event as recognized by the school. Absence Amounts must be less than or equal to the Student Membership FTE, since absences are measured in quarter day increments. (For brick and morter Schools) (0.25, 0.50, 0.75, 1.00)	Only report field when reporting attendance. Do not report when reporting Learning Modality. See AZ Attendance Calculation Appendix below.	C
instructional Minutes	The amount of time, in minutes, that the student received instruction during the reported attendance period and the "In Attendance" code is used (For AOI schools) (1, 2, 3).	Only report for students with attendance code of '017: Positive'. Report the sum of all positive attendance minutes entered for the student for that day.	C	System Administration > Calendar > Calendar > Attendance Type Student Information > General > Enrollments > Attendance Type	attendance Unit table
modalityTimeType DescriptorId	The Modality Time Type is defined for a student.	If reporting Learning Modality, report 'Percentage'. Otherwise, do not report.	C
modalityType DescriptorId	The ModalityType is defined for a student.	If reporting Learning Modality, report 'Remote'. Otherwise, do not report.	C
modalityTime	The amount of time, in percentage, the student was either present remote or absent remote in a give day. Valid values are 25, 50, 75, 100.	If reporting Learning Modality, see AZ Attendance Calculation Appendix. Otherwise, do not report.	C
etag	A unique system-generated value that identifies the version of the resource.		O

Types/Descriptors

Attendance Event Category Descriptors

Code Value	Description
1	EXCUSED_ABSENCE
2	UNEXCUSED_ABSENCE
3	IN_ATTENDANCE
4	IN ATTENDANCE - DL
5	ABSENCE - DL

AZ Attendance Calculation Appendix

Event Duration Calculations

This is reported in Negative Attendance attendance reporting.

For ALL grade levels:

The following are not considered when calculating attendance:

No Show flag
Threshold values on the calendar or grade level tab.
Students Homebound on the day of the absence
- Student Information > General > Programs > Program

The following are considered when calculating attendance:

State Exclude flags on the enrollment, calendar, and grade levels
Students who have absences during the year in which the 004 Absence Transaction is being generated.
Students FTE value:
- For all reporting based on FTE value, FTE value is identified in the following method:
  a. If Enrollment.percentEnrolled is not NULL, report based on the value entered in the record.
  b. If Enrollment.percentEnrolled is NULL, report based on the value entered into the default field on the Enrollment.percentEnrolled attribute.
  c. If Enrollment.percentEnrolled is NULL, and the default field on the Enrollment.percentEnrolled attribute is NULL, report based on a value of '1.00'.
- Student's absent amount cannot exceed their FTE value.
Exclude Present Minutes from total minutes missed.
- Student Information > General > Attendance
Present minutes for student's cannot include Lunch Time.
- System Administration > Calendar > Calendar > Periods
- All State Grade Level codes except for the following.
  - PS: Preschool
    - Students are reported in positive attendance minutes on '017'.
Exclude Absence Types of: 'Tardy', 'Present', and 'Early Release'.
Exclude Absence Status of: 'Exempt'.

Half Day KG: Kindergarten or UE: Ungraded Elementary (Excluding Homebound Students)

Kindergarten Code must = A: Half Day Every Day

System Administration > Calendar > Calendar > Grade Levels
- Calculation: Number of Instructional minutes attended / (Scheduled minutes X FTE)
  Percent Attended Absence Reported
  26% or more Do not report student
  0 - 25% 100/75/50% FTE: .50
  25% FTE: .25

Percent Attended	Absence Reported
26% or more	Do not report student
0 - 25%	100/75/50% FTE: .50 25% FTE: .25

Full Day KG: Kindergarten or UE: Ungraded Elementary (Excluding Homebound Students)

Kindergarten Code must equal one of the following codes:

B: Full Day Every Other Day
C: Full Day 3 Days a week
D: Full Day Every Day Spring-Only
E: Full Day Every Day
F: Full Day Every Day Title 1
System Administration > Calendar >Calendar > Grade Levels
- Calculation: Number of Instructional minutes attended / (Scheduled minutes X FTE )

Percent Attended	Absence Reported
51% or more	Do not report student
0 - 50%	100% FTE: 1.00 75% FTE: .75 50% FTE: .5 25% FTE: .25

Grades 1-8 (Excluding Homebound Students)

The Attendance Calculation drop list value will determine how a school will calculate attendance for grades 1-8. Please note that grades 9-12 and kindergarten do not use this setting.

System Administration > Calendar > Calendar > Calendar
HW
Half Day/Whole Day
QD
Quarter Day

2. Calculation: Number of Instructional minutes attended / (Scheduled Instructional Minutes X FTE)

Note: Scheduled Instructional Minutes will sum all instructional periods with period start/end times that a student has ANY active, non-state excluded, attendance taking course scheduled into it.

When 'Attendance Calculation' = QD: Quarter Day, report as follows:

100% FTE		75% FTE		50% FTE		25% FTE
Percent Attended	Absence Reported	Percent Attended	Absence Reported	Percent Attended	Absence Reported	Percent Attended	Absence Reported
1 or greater	Do not report.	1 or greater	Do not report.	1 or greater	Do not report.	1 or greater	Do not report.
.75 -.99	.25	.66 -.99	.25	.5 -.99	.25	0 -.99	.25
.50 -.74	.5	.33 -.65	.5	0 -.49	.5
.25 -.49	.75	0 -.32	.75
0 -.24	1

When 'Attendance Calculation' = HW: Half Day/Whole Day, report as follows:

100% FTE		75% FTE		50% FTE		25% FTE
Percent Attended	Absence Reported	Percent Attended	Absence Reported	Percent Attended	Absence Reported	Percent Attended	Absence Reported
.75 - 1 or greater	Do not report	.75 - 1 or greater	Do not report	.75 - 1 or greater	Do not report	.25 - 1 or greater	Do not report
.25 - .74	.5	.25 - .74	.25	.25 - .74	.25	0 - .24	.25
0 -.24	1	0 -.24	.75	0 -.24	.5

Grades 9-12

The following considerations will be made:

A course is only considered as attendance taking if it meets the following criteria:
1. Course is active
2. Attendance checkbox is checked
3. State Exclude is unchecked
4. Course has a grading task where the credit value is greater than 0 or Null
  1. Scheduling > Courses > Grading Tasks > Credit
4 day calendar
5 day calendar
For 004a: Negative Method 1 Attendance, report students as such:
1. Absence amount = FTE x (1 - ((The number of classes attended) / (The number of classes scheduled)))
2. Value is reported as rounded UP to the nearest quarter (eg.: 1, .75, .50, .25, 0).
  a. It should be impossible to send a value of '0', since that would suggest that a student's negative absence record for a date is '0', meaning there was no negative attendance event.
3. To be considered a class for the purposes of the calculation, the course needs to be scheduled into an instructional period, and the student actively rostered into a course/section on a given attendance date.
For 004: Negative Method 2 Attendance, report students as such:

- Example Calculations

Example 1

Student is 100% FTE.

Schedule is a full day.

Student is absent for the full day (a full day of attendance should report).

Period 1 – 55 minutes (Absent)
Period 2 – 60 minutes (Absent)
Period 3 – 45 minutes (Absent)
Period 4 – 75 minutes (Absent)
- Sum of attended minutes
  1. 0 attended minutes (Absent all periods)
- Report absence of 1.

Example 2

Student is 100% FTE.

Schedule is a full day.

Student is not absent at all (no attendance should report).

Period 1 – 55 minutes (Present)
Period 2 – 60 minutes (Present)
Period 3 – 45 minutes (Present)
Period 4 – 75 minutes (Present)
- Sum of attended minutes
  - 240 attended minutes
    - Period 1 (60) + Period 2 (60) + Period 3 (45) + Period 4 (75) = 240
- Total attended minutes divided by 60
  - 4 hours
    - Total Attended Minutes (240) / 60 = 4
    - 4 = Expected FTE Hours (4), so do not report.

Example 3

Student is 100% FTE.

Schedule is a half day.

Student is partially absent (some amount of attendance should report).

Period 1 – 30 minutes (Absent)
Period 2 – 25 minutes (Present)
Period 3 – 35 minutes (Present)
Period 4 – 30 minutes (Present)
Period 5 - 25 minutes (Present)
Period 6 - 40 minutes (Present)
- Sum of attended minutes
  - 155 minutes
    - Period 2 (25) + Period 3 (35) + Period 4 (30) + Period 5 (25) + Period 6 (40) = 155
- Total attended minutes divided by 60
  - 2.58 hours
    - Total Attended Minutes(155) / 60 = 2.58
    - 2.58 < Expected FTE Hours (4)
- Total scheduled minutes
  - 185 minutes
    - Period 1 (30) + Period 2 (25) + Period 3 (35) + Period 4 (30) + Period 5 (25) + Period 6 (40) = 185
- Total scheduled hours
  - 3.08 hours
    - Total Scheduled Minutes (185) /60 = 3.08
    - 3.08 < Expected FTE (4) - Leave scheduled minutes at 185
- Percent attended
  - Total Attended Minutes (155) / Total Scheduled Minutes (185) = .84
  - Absent should report as .25.
    - .84 is between .75 -.99 so should report as .25.

Example 4

Student is 100% FTE.

Schedule is a half day.

Student is partially absent (some amount of attendance should report).

Period 1 – 30 minutes (Absent)
Period 2 – 25 minutes (Absent)
Period 3 – 35 minutes (Absent)
Period 4 – 30 minutes (Present)
Period 5 - 25 minutes (Present)
Period 6 - 40 minutes (Present)
- Sum of attended minutes
  - 95 minutes
    - Period 4 (30) + Period 5 (25) + Period 6 (40) = 95
- Total attended minutes divided by 60
  - 1.58 hours
    - Total Attended Minutes (95) / 60 = 1.58
    - 1.58 < Expected FTE Hours (4)
- Total scheduled minutes
  - 185 minutes
    - Period 1 (30) + Period 2 (25) + Period 3 (35) + Period 4 (30) + Period 5 (25) + Period 6 (40) = 185
- Total scheduled hours:
  - 3.08 hours
    - 185 / 60 = 3.08
    - 3.08 < Expected FTE hours (4) - Leave scheduled minutes at 185
- Percent attended
  - Total Attended Minutes (95) / Total Scheduled Minutes (185) = .51
  - Absent should report as .5.
    - .51 is between .50 -.74, so should report as .5.

Example 5

Student is 100% FTE.

Schedule is a full day.

Student is partially absent (some amount of attendance should report).

Period 1 – 55 minutes (Absent)
Period 2 – 60 minutes (Absent)
Period 3 – 45 minutes (Absent)
Period 4 – 80 minutes (Present)
Period 5 - 55 minutes (Present)
Period 6 - 70 minutes (Present)
- Sum of attended minutes
  - 210 minutes
    - Period 4 (80) + Period 5 (60) + Period 6 (70) = 210
- Total attended minutes divided by 60
  - 3.5 hours
    - Total Attended Minutes (210) / 60 = 3.5
    - 3.5 < Expected FTE Hours (4)
- Total scheduled minutes
  - 375 minutes
    - Period 1 (60) + Period 2 (60) + Period 3 (45) + Period 4 (80) + Period 5 (60) + Period 6 (70) = 375
- Total scheduled hours:
  - 6.25 hours
    - Total Scheduled Minutes (375) / 60 = 6.25
    - Total scheduled hours (6.25) > Expected FTE hours (4) - need to recalculate total scheduled minutes to match FTE
- Total scheduled minutes
  - 240 minutes
    - Expected FTE hours (4) * 60 = 240
- Percent attended
  - Total Attended Minutes (210) / Total Scheduled Minutes (240) = .88
  - Absent should report as .25.
    - .88 is between .75 -.99, so should report as .25.

Example 6

Student is 75% FTE.

Schedule is a half day.

Student is partially absent (some amount of attendance should report).

Period 1 – 30 minutes (Absent)
Period 2 – 25 minutes (Absent)
Period 3 – 35 minutes (Absent)
Period 4 – 30 minutes (Present)
Period 5 - 25 minutes (Present)
Period 6 - 40 minutes (Present)
- Sum of attended minutes
  - 95 minutes
    - Period 4 (30) + Period 5 (25) + Period 6 (40) = 95
- Total attended minutes divided by 60
  - 1.58 hours
    - Total Attended Minutes (95) / 60 = 1.58
    - 1.58 < Expected FTE Hours (3)
- Total scheduled minutes
  - 185 minutes
    - Period 1 (30) + Period 2 (25) + Period 3 (35) + Period 4 (30) + Period 5 (25) + Period 6 (40) = 185
- Total scheduled hours:
  - 3.08 hours
    - Total Scheduled Minutes (185) / 60 = 3.08
    - 3.08 > Expected FTE hours (3) - need to recalculate total scheduled minutes to match FTE
- Total scheduled minutes
  - 180 minutes
    - Expected FTE hours (3) * 60 = 180
- Percent attended
  - Total Attended Minutes (95) / Total Scheduled Minutes (180) = .53
  - Absent should report as .5.
    - .53 is between .33 -.65, so should report as .5.

The number of hours a student is expected to attend on a regular school day is based on the FTE value for the student:
1. If the student has 100% FTE, the student is expected for 4 hours
2. If the student has 75% FTE, the student is expected for 3 hours.
3. If the student has 50% FTE, the student is expected for 2 hours.
4. If the student has 25% FTE, the student is expected for 1 hours.
5. If the student has 00% FTE, the student is not expected for any hours.
Sum total attended minutes for the day:
1. An attended period is a period that has no attendance code or has an attendance code with an Absent Status that is NOT 'Absent'.
2. If a period is between 55 - 60 minutes, then it should count as 60 minutes in the sum.
If total attended minutes is 0, report an absence equivalent to the student's FTE:
1. Stop processing here as the resource is reporting.
2. Student FTE reporting:
  Student's FTE Absence to Report
  100 1
  75 .75
  50 .50
  25 .25
If total attended minutes divided by 60 is >= expected FTE hours, do not report resource at all:
1. Stop processing here as resource should not report.

Student's FTE	Absence to Report
100	1
75	.75
50	.50
25	.25

If total attended minutes divided by 60 is < expected FTE hours, complete the following:

Sum total scheduled minutes for the day.
- Note: If a period is between 55 - 60 minutes, then it should count as 60 minutes in the sum.
Calculate total scheduled hours by dividing total scheduled minutes by 60.
- Note: Do NOT round this value.
If total scheduled hours is > expected FTE hours, then set scheduled minutes to expected FTE hours multiplied by 60. Else, leave scheduled minutes as the original calculation.
Calculate percent attended by dividing total attended minutes by total scheduled minutes. Round to the second decimal place using normal rounding.

Report absence value based on the student's FTE table below:

100% FTE		75% FTE		50% FTE		25% FTE
Percent Attended	Absence Reported	Percent Attended	Absence Reported	Percent Attended	Absence Reported	Percent Attended	Absence Reported
1	Nothing reported	1	Nothing reported	1	Nothing reported	1	Nothing reported
.75 -.99	.25	.66 -.99	.25	.50 -.99	.25	.0 -.99	.25
.50 -.74	.5	.33 -.65	.5	0 -.49	.5
.25 -.49	.75	0 -.32	.75
0 -.24	1

Excludes/Defaults

For all calculations:

Do not report data with the following State Exclude Flags:

Enrollment State Exclude flag omits student from report.
Calendar Exclude flag omits school from report.
Grade Level State Exclude flag does not omit student from report (Will discuss with focus group if this flag should be activated 11/9/09).

For the calculations in Appendix A:

If FTE is missing, the default is = 1.

Learning Modality

Student is 100% virtual for a day:

If the student is in a blended learning group (BLG) and the BLG has a day event on the calendar (marking the day as virtual) or there is a 'Virtual Code Override' day event on the calendar:

When reporting attendanceEventReason of 'In Attendance - DL'
- Use calculation for Event Duration to determine percent of time in attendance.

If grade is KG or UE and Kindergarten Code is 'A: Half Day Every Day'

100%/75%/50% FTE		25% FTE
Absent Calculation	'In Attendance - DL' to report	Absent Calculation	'In Attendance - DL' to report
.5	Do not report	.25	Do not report
0	50	0	25

Otherwise:

100% FTE		75% FTE		50% FTE		25% FTE
Absent Calculation	'In Attendance - DL' to report	Absent Calculation	'In Attendance - DL' to report	Absent Calculation	'In Attendance - DL' to report	Absent Calculation	'In Attendance - DL' to report
1	Do not report	1	Do not report	1	Do not report	1	Do not report
.75	25	.75	Do not report	.75	Do not report	.75	Do not report
.5	50	.5	25	.5	Do not report	.50	Do not report
.25	75	.25	50	.25	25	.25	Do not report
0	100	0	75	0	50	0	25

Note: The value cannot exceed the student's FTE. For example, if a student is 75% FTE and present all day, only 75 can report, not 100.

2. When reporting attendanceEventReason of 'Absence - DL':

- Use calculation for Event Duration to determine percent of time absent.

Student is virtual for part of the day

If the student has an attendance code with a State Code of 'DLA' or 'DLP' on a given day:

If the student is in Grades 9 - 12:

Sum total in person attended minutes and store this value:
- An in person attended period is a period that has no attendance code or has an attendance code with an Absent Status that is not 'Absent' and the state code is not 'DLA' or 'DLP'.
- If a period is between 55 - 60 minutes, then it should count as 60 minutes in the sum.
Calculate the number of in person hours a student has attended by dividing total in person attended minutes by 60
- If in person attended hour count is greatr than or equal to FTE hours, do not report resource at all:
  1. Stop processing here as resource should not report.
  2. If the student has 100% FTE, the student is expected for 4 hours.
  3. If the student has 75% FTE, the student is expected for 3 hours.
  4. If the student has 50% FTE, the student is expected for 2 hours.
  5. If the student has 25% FTE, the student is expected for 1 hours.
  6. If the student has 00% FTE, the student is not expected for any hours.
- If in person attended hour count is less than FTE hours, complete the following:
  1. Calculate the total remaining hours student needs to attend by subtracting the in person attended hours (rounded down to nearest whole number) from the FTE expected hour count. Store this number for future use.
  2. Calculate the total attended minutes for the student using the Negative Method 2 calculation
    - If total attended minutes divided by 60 is >= FTE hours, then multiply the total remaining hours student needs to attend by 25. Report this value as 'In Attendance - DL'.
      1. Stop processing here as 'In Attendance - DL' should only report.
      2. Example Calculation:
        Student is 75% FTE
        Period 1 - 28 minutes (Distance Learning Present)
        Period 2 - 33 minutes (Distance Learning Present)
        Period 3 - 38 minutes (Distance Learning Present)
        Period 4 - 33 minutes (Distance Learning Absent)
        Period 5 - 33 (In Person Present)
        Period 6 - 33 (In Person Present)
        Period 7 - 32 (In Person Present)
        In Person attended hours calculation:
        Attended 1 hour
        (Period 5 + Period 6 + Period 7) / 60 = 1.63 (Round down to nearest whole number, which is 1)
        1 (calculated attended hour) is not >= 3 (expected hour count for 75% FTE)
        Total remaining hours calculation:
        2 remaining hours
        FTE hours expected (3) - In Person Hours attended (1) = 2
        Total attended minutes calculation:
        Attended 197 minutes
        (Period 1 + Period 2 + Period 3 + Period 5 + Period 6 + Period 7) = 197
        197 / 60 = 3.28 (Round down to nearest whole number, which is 3)
        3 (attended hours) = 3 (expected hour count for 75% FTE)
        Total attended distance learning calculation:
        In Attendance - DL should report as 50.
        Total remaining hours (2) * 25 = 50
    - If total attended hours is less than FTE
      - Sum total distance learning attended minutes:
        A distance learning attended period is a period that has an attendance code with a state code of 'DLP'.
        If a period is between 55 - 60 minutes, then it should count as 60 minutes in the sum.
      - Sum total scheduled minutes for the day:
        Note: If a period is between 55 - 60 minutes, then it should count as 60 minutes in the sum.
      - Calculate total scheduled hours by dividing total scheduled minutes by 60.
        Note: Do NOT round this value.
      - If total scheduled hours is > expected FTE hours, then set scheduled minutes to expected FTE hours multiplied by 60. Else, leave scheduled minutes as the original calculation.
      - Report 'In Attendance - DL' by completing the following:
        Divide total distance learning attended minutes by total scheduled minutes and round to the second decimal place using normal rounding.
        Report 'In Attendance- DL' value based on the table below using percent attended and student's FTE:
        100% FTE
        Percent Attended Absence Reported
        1 100
        .75 -.99 75
        .50 -.74 50
        .25 -.49 25
        0 -.24 Nothing reported
        75% FTE
        Percent Attended
        Absence Reported
        1
        75
        .66 -.99
        50
        .33 -.65
        25
        0 -.32
        Nothing reported
        50% FTE
        Percent Attended
        Absence Reported
        1
        50
        .50 -.99
        25
        0 -.49
        Nothing reported
        25% FTE
        Percent Attended
        Absence Reported
        1
        25
        .0 -.99
        Nothing reported
        Continue processing to determine what, if anything for 'Absence DL' should report.

Percent Attended	Absence Reported
1	100
.75 -.99	75
.50 -.74	50
.25 -.49	25
0 -.24	Nothing reported

Percent Attended	Absence Reported
1	75
.66 -.99	50
.33 -.65	25
0 -.32	Nothing reported

Percent Attended	Absence Reported
1	50
.50 -.99	25
0 -.49	Nothing reported

Percent Attended	Absence Reported
1	25
.0 -.99	Nothing reported

If total attended minutes is greater than or equal to total scheduled minutes, do nothing further.
1. Stop processing here as no 'Absence - DL' record should report.
2. Example Calculation:
  - Student is 100% FTE.
  - Period 1 - 28 minutes (Distance Learning Present)
  - Period 2 - 33 minutes (Distance Learning Present)
  - Period 3 - 38 minutes (Distance Learning Present)
  - Period 4 - 33 minutes (Distance Learning Present)
  - Period 5 - 33 (In Person Present)
  - Period 6 - 33 (In Person Present)
  - Period 7 - 32 (In Person Present)
  - In Person attended hours calculation:
    1. Attended 1 hour
      (Period 5 + Period 6 + Period 7) / 60 = 1.63 (Round down to nearest whole number, which is 1)
    2. 1 (calculated attended hour) < 4 (expected hour count for 100% FTE)
  - Total remaining hours calculation:
    1. 3 remaining hours
      FTE hours expected (4) - In Person Hours attended (1) = 3
  - Total attended minutes calculation:
    1. Attended 230 minutes
      Period 1 (28) + Period 2 (33) + Period 3 (38) + Period 4 (33) + Period 5 (33) + Period 6 (33) + Period 7 (32) = 230
      230/ 60 = 3.83 (Round down to nearest whole number, which is 3)
      3 < 4 (expected hour count for 100% FTE)
  - Distance Learning attended minutes:
    1. Attended 132 minutes
      Period 1 (28) + Period 2 (33) + Period 3 (38) + Period 4 (33) = 132
  - Total scheduled minutes
    1. 230 minutes
      Period 1 (28) + Period 2 (33) + Period 3 (38) + Period 4 (33) + Period 5 (33) + Period 6 (33) + Period 7 (32) = 230
  - Total scheduled hours
    1. 3.83 hours
      230 / 60 = 3.83
      3.83 < Expected FTE (4), so scheduled minutes is 230
  - Total attended distance learning calculation
    1. In Attendance - DL should report as 50.
      Distance Learning attended minutes (132) / Total scheduled minutes (230) = .57
      .57 is between .50 -.74 so should report as 50.
  - Total attended minutes (230) = Total scheduled minutes (230), so do nothing further.
If total attended minutes is less than total scheduled minutes, do the following:
- Calculate the number of in person absent and distance learning absent minutes a student has and store each value.
  - In person absent minutes are when a student has an attendance code with an Absent Status of 'Absent' and the state code is NOT 'DLA'.
  - Distance learning absent hours are when a student has an attendance code with a state code of 'DLA' .
- If distance learning absent minutes = 0, then do nothing.
  - Stop processing here as no 'Absence - DL' record should report
- Calculate percent attended by dividing total attended minutes by total scheduled minutes. Round to the second decimal place using normal rounding. Store this value
- If in person absent minutes = 0, then do the following
  - Report 'Absence - DL' value based on the table below using percent attended and student's FTE (Note, this value should match what was reported in Event Duration * 100)
    - 100% FTE
      Percent Attended Absence Reported
      1 Nothing reported
      .75 -.99 25
      .50 -.74 50
      .25 -.49 75
      0 - .24 100
    - 75% FTE
      Percent Attended
      Absence Reported
      1
      Nothing reported
      .66 -.99
      25
      .33 -.65
      5
      0 -.32
      75
    - 50% FTE
      Percent Attended
      Absence Reported
      1
      Nothing reported
      .50 - .99
      25
      0 - .49
      50
    - 25% FTE
      Percent Attended
      Absence Reported
      1
      Nothing reported
      .0 -.99
      25
- Stop processing here as all values have reported.
- Example Calculations:
  - Example 1:
    1. Student is 100% FTE.
    2. Period 1 - 55 minutes (In Person present)
    3. Period 2 - 60 minutes (In Person present)
    4. Period 3 - 55 minutes (Distance Learning present)
    5. Period 4 - 60 minutes (Distance Learning absent)
    6. In Person attended hours calculation:
      - Attended 2 hours
        60 + 60 = 120 / 60 = 2
        2 < 4 (expected hour count for 100% FTE)
    7. Total remaining hours calculation:
      - 2 remaining hours
        FTE hours expected (4) - In Person Hours attended (2) = 2
    8. Total attended minutes calculation:
      - Attended 180 minutes
        Period 1 (60) + Period 2 (60) + Period 3 (60) = 180
        180 / 60 = 3
        3 < 4 (expected hour count for 100% FTE)
    9. Distance Learning attended minutes:
      - Attended 60 minutes (Period 3 is between 55 - 60 minutes so it counts as 60 minutes)
    10. Total scheduled minutes:
      1. 240 minutes
        Period 1 (60) + Period 2 (60) + Period 3 (60) + Period 4 (60) = 240
    11. Total scheduled hours:
      - 4 hours
        240 / 60 = 4
        4 = Expected FTE (4), so scheduled minutes is 240
        Total attended minutes (180) < Total scheduled minutes (240)
    12. Total attended distance learning calculation:
      - In Attendance - DL should report as 25
        Distance Learning attended minutes (60) / Total Scheduled minutes (240) = .25
        .25 is between .25 - .49 so should report as 25
    13. In Person Absent minutes calculation:
      - 0 minutes (no in person absent periods)
    14. Distance Learning Absent minutes calculation:
      - 60 minutes (Period 4 is between 55 - 60 minutes so it counts as 60 minutes)
    15. Percent attended
      - Total attended minutes (180) / Total scheduled minutes (240) = .75
    16. 'Absence - DL' reporting
      - Absence - DL should report as 25.Percent attended (.75) is between .75 - .99 so should report as 25
  - Example 2:
    - Student is 100% FTE.
    - Period 1 - 55 minutes (In Person present)
    - Period 2 - 60 minutes (In Person present)
    - Period 3 - 55 minutes (Distance Learning present)
    - Period 4 - 60 minutes (Distance Learning absent)
    - Period 5 - 60 minutes (Distance Learning absent)
    - In Person attended hours calculation:
      - Attended 2 hours
        60 + 60 = 120 / 60 = 2
        2 < 4 (expected hour count for 100% FTE)
    - Total remaining hours calculation:
      - 2 remaining hours
        FTE hours expected (4) - In Person Hours attended (2) = 2
    - Total attended minutes calculation:
      - Attended 180 minutes
        Period 1 (60) + Period 2 (60) + Period 3 (60) = 180
        180 / 60 = 3
        3 < 4 (expected hour count for 100% FTE)
    - Distance Learning attended minutes:
      - Attended 60 minutes (Period 3 is between 55 - 60 minutes so it counts as 60 minutes)
    - Total scheduled minutes:
      - 300 minutes
        Period 1 (60) + Period 2 (60) + Period 3 (60) + Period 4 (60) + Period 5 (60) = 300
    - Total scheduled hours:
      - 5 hours
        300 / 60 = 5
        5 > Expected FTE (4)
    - Total scheduled minutes:
      - 240 minutes
        Expected FTE hours (4) * 60 = 240
        Total attended minutes (180) < Total scheduled minutes (240)
    - Total attended distance learning calculation:
      - In Attendance - DL should report as 25.
        Distance Learning attended minutes (60) / Total Scheduled minutes (240) = .25
        .25 is between .25 - .49 so should report as 25
    - In Person Absent minutes calculation:
      - 0 minutes (no in person absent periods)
    - Distance Learning Absent minutes calculation:
      - 120 minutes (Period 4-5 are both between 55 - 60 minutes so each counts as 60 minutes)
    - Percent attended
      - Total attended minutes (180) / Total scheduled minutes (240) = .75
    - 'Absence - DL' reporting
      - Absence - DL should report as 25
        Percent attended (.75) is between .75 - .99 so should report as 25.
- If both distance learning absent minutes and in person absent minutes are greater than 0, then do the following:
  1. Calculate in person percent absent by dividing in person absent minutes by total scheduled minutes
  2. If in person percent absent + percent attended is greater than or equal to 1, then do nothing.
    - Stop processing here as no 'Absence - DL' record should report.
    - Example Calculation:
      Student is 100% FTE
      Period 1 – 55 minutes (In Person Present)
      Period 2 – 55 minutes (In Person Absent)
      Period 3 – 60 minutes (In Person Absent)
      Period 4 – 60 minutes (DL Absent)
      Period 5 – 55 minutes (DL Present)
      Period 6 – 55 minutes (DL Present)
      In Person attended hours calculation:
      Attended 1 hour (Period 1 is between 55 - 60 minutes so counts as 60 minutes or 1 hour)
      1 < 4 (Expected FTE)
      Total remaining hours calculation:
      3 remaining hours
      FTE hours expected (4) - In Person Hours attended (1) = 3
      Total attended minutes calculation:
      Attended 180 minutes
      Period 1 (60) + Period 5 (60) + Period 6 (60) =180
      180 / 60 = 3
      3 < 4 (expected hour count for 100% FTE)
      Distance Learning attended minutes calculation:
      Attended 120 minutes
      Period 5 (60) + Period 6 (60) = 120
      Total scheduled minutes:
      360 minutes
      Period 1 (60) + Period 2 (60) + Period 3 (60) + Period 4 (60) + Period 5 (60) + Period 6 (60) = 360
      Total scheduled hours:
      6 hours
      360 / 60 = 6
      6 > Expected FTE (4)
      Total scheduled minutes:
      240 minutes
      Expected FTE hours (4) * 60 = 240
      Total attended minutes (180) < Total scheduled minutes (240)
      Total attended distance learning calculation:
      In Attendance - DL should report as 50
      Distance Learning attended minutes (120) / Total Scheduled minutes (240) = .5
      .5 is between .5 -.74 so should report as 50
      In Person Absent minutes calculation:
      120 minutes
      Period 2 (60) + Period 3 (60) = 120
      Distance Learning Absent minutes calculation:
      60 minutes (Period 4 is between 55-60 minutes so is counted as 60 minutes)
      Percent attended:
      Total attended minutes (180) / Total scheduled minutes (240) = .75
      In Person absent percent:
      In Person absent minutes (120) / Total scheduled minutes (240) = .5
      Report nothing further:
      In Person absent percent (.5) + percent attended (.75) = 1.25
      1.25 > 1
  3. If in person percent absent + percent attended is less than 1, then do the following:
    1. Calculate distance learning percent absent by subtracting both in person percent absent and percent attended from 1.
    2. Report 'Absence - DL' based on the table for the student's FTE:
      - 100%
        DL Percent Absent 'Absence - DL' Reported
        0 Nothing reported
        .01 -.25 25
        .26 -.5 50
        .51 -.75 75
        .76 - 1 100
      - 75%
        DL Percent Absent
        'Absence - DL' Reported
        0
        Nothing reported
        .01 -.33
        25
        .34 -.65
        50
        .66 -1
        75
      - 50%
        DL Percent Absent
        'Absence - DL' Reported
        0
        Nothing reported
        .01 -.49
        25
        .50 - 1
        50
      - 25%
        DL Percent Absent
        'Absence - DL' Reported
        1
        Nothing reported
        .01 - 1
        25
    3. Example Calculations:
      Example 1
      1. Student is 100% FTE
      2. Period 1 – 55 minutes (In Person Present)
      3. Period 2 – 55 minutes (In Person Absent)
      4. Period 3 – 60 minutes (DL Absent)
      5. Period 4 – 55 minutes (DL Present)
      6. In Person attended hours calculation:
        Attended 1 hour (Period 1 is between 55 - 60 minutes so counts as 60 minutes or 1 hour)
        1 < 4 (Expected FTE)
      7. Total remaining hours calculation:
        3 remaining hours
        FTE hours expected (4) - In Person Hours attended (1) = 3
      8. Total attended minutes calculation:
        Attended 120 minutes
        Period 1 (60) + Period 4 (60) = 120
        120 / 60 = 2
        2 < 4 (Expected FTE hours)
      9. Distance Learning attended minutes calculation:
        60 minutes (Period 4 is between 55 - 60 minutes so counts as 60 minutes)
      10. Total scheduled minutes:
        240 minutes
        Period 1 (60) + Period 2 (60) + Period 3 (60) + Period 4 (60) = 240
      11. Total scheduled hours:
        4 hours
        240 / 60 = 4
        4 = Expected FTE (4), so scheduled minutes is 240
        Total attended minutes (120) < Total scheduled minutes (240)
      12. Total attended distance learning calculation:
        In Attendance - DL should report as 25
        Distance Learning attended minutes (60) / Total Scheduled minutes (240) = .25
        .25 is between .25 -.49 so should report as 25
      13. In Person Absent minutes calculation:
        60 minutes (Period 2 is between 55-60 minutes so counts as 60 minutes)
      14. Distance Learning Absent minutes calculation:
        60 minutes (Period 3 is between 55 - 60 minutes so counts as 60 minutes)
      15. Percent attended:
        Total attended minutes (120) / Total scheduled minutes (240) = .5
      16. In person absent percent:
        In Person absent minutes (60) / Total scheduled minutes (240) = .25
        Percent attended (.5) + In person absent percent (.25) = .75
        .75 < 1
      17. Distance learning percent:
        1 - In person absent percent (.25) - Percent attended (.75) = .25
        Absence - DL should report as 25
        Distance learning percent (.25) is between 0 - .25, so should report as 25
- Example 2:
  - Student is 75% FTE.
  - Period 1 – 55 minutes (In Person Present)
  - Period 2 – 55 minutes (In Person Absent)
  - Period 3 – 60 minutes (DL Absent)
  - In Person attended hours calculation:
    - Attended 1 hour (Period 1 is between 55-60 minutes so counts as 60 minutes or 1 hour)
    - 1 < 3
  - Total remaining hours calculation:
    - 2 remaining hours
      1. FTE hours expected (3) - In Person Hours attended (1) = 2
  - Total attended minutes calculation:
    - Attended 60 minutes
      - Period 1 (60)
      - 60 / 60 = 1
      - 1 < 3 (Expected FTE hours)
  - Distance Learning attended minutes calculation:
    - Attended 0 minutes
  - Total scheduled minutes:
    - 180 minutes
      - Period 1 (60) + Period 2 (60) + Period 3 (60) = 180
  - Total scheduled hours:
    - 3 hours
      - 180 / 60 = 3
        3 = Expected FTE (3) so total scheduled minutes remains at 180
        Total attended minutes (60) < Total scheduled minutes (180)
  - Total attended distance learning calculation:
    - In Attendance - DL should NOT report
      - Distance Learning attended minutes (0) / Total Scheduled minutes (180) = 0
      - Student has not DL attended minutes so should not report
  - In Person Absent minutes calculation:
    - 60 minutes (Period 2 is between 55-60 minutes so counts as 60 minutes)
  - Distance Learning Absent minutes calculation:
    - 60 minutes
      - Period 3 (60)
  - Percent attended:
    - Total attended minutes (60) / Total scheduled minutes (180) = .33
  - In person absent percent:
    - In Person absent minutes (60) / Total scheduled minutes (180) = .33
      - Percent attended (.33) + In person absent percent (.33) = .66
      - .66 < 1
  - Distance learning percent:
    - 1 - In person absent percent (.33) - Percent attended (.33) = .33
    - Absence - DL should report as 25
      - Distance learning percent (.33) is between 0 -.33, so should report as 25.

Percent Attended	Absence Reported
1	Nothing reported
.75 -.99	25
.50 -.74	50
.25 -.49	75
0 - .24	100

Percent Attended	Absence Reported
1	Nothing reported
.66 -.99	25
.33 -.65	5
0 -.32	75

Percent Attended	Absence Reported
1	Nothing reported
.50 - .99	25
0 - .49	50

Percent Attended	Absence Reported
1	Nothing reported
.0 -.99	25

DL Percent Absent	'Absence - DL' Reported
0	Nothing reported
.01 -.25	25
.26 -.5	50
.51 -.75	75
.76 - 1	100

DL Percent Absent	'Absence - DL' Reported
0	Nothing reported
.01 -.33	25
.34 -.65	50
.66 -1	75

DL Percent Absent	'Absence - DL' Reported
0	Nothing reported
.01 -.49	25
.50 - 1	50

DL Percent Absent	'Absence - DL' Reported
1	Nothing reported
.01 - 1	25

If the Student is in Grades KG, UE, or 1-8:

Sum total scheduled minutes and multiply by student's FTE and store this value.
Sum total in person attended minutes and store this value.
- An in person attended period is a period that has no attendance code or has an attendance code with an Absent Status that is not 'Absent' and the state code is not 'DLA' or 'DLP'.
- Use the Negative Method attendance definition of a period.
If In Person Attended Minutes is greater than or equal to Total Scheduled Minutes, do not report resource at all.
- Stop processing here as resource should not report.

If In Person Attended Minutes is less than Total Scheduled Minutes.

Sum total distance learning attended minutes and tore this value.
- A distance learning attended period is a period that has an attendance code with a state code of 'DLP'.
Determine total attended minutes by summing Distance Learning Attended Minutes and In Person Attended Minutes. Store this value.
If Total Attended Minutes are greater than or equal to Total Scheduled Minutes
1. Calculate remaining minutes needed by subtracting In Person Attended Minutes from Total Scheduled Minutes. Store this value.
2. Divide Remaining Minutes Needed by Total Scheduled Minutes and round to two digits using normal rounding rules. Store this value as DL Percent Attended.
If Total Attended Minutes less than Total Scheduled Minutes
1. Divide Distance Learning Attended Minutes by Total Scheduled Minutes, round to two digits using normal rounding rules. Store this value as DL Percent Attended

Report 'In Attendance - DL' based on the tables below using DL Percent Attended, a student's FTE, grade, and attendance reporting type

If grade is KG or UE:
- If Kindergarten code is A: Half Day Every Day:
  DL Percent Attended
  'In Attendance - DL' Reported
  26% or more
  100% FTE: 100
  75% FTE: 75
  50% FTE: 50
  25% FTE: 25
  0-25%
  Nothing reported
- If Kindergarten code is one of the following:
  - B: Full Day Every Other Day
  - C: Full Day 3 Days a week
  - D: Full Day Every Day Spring-Only
  - E: Full Day Every Day
  - F: Full Day Every Day Title 1
    DL Percent Attended
    'In Attendance - DL' Reported
    51% or more
    100% FTE: 100
    75% FTE: 75
    50% FTE: 50
    25% FTE: 25
    0-50%
    Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
26% or more	100% FTE: 100 75% FTE: 75 50% FTE: 50 25% FTE: 25
0-25%	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
51% or more	100% FTE: 100 75% FTE: 75 50% FTE: 50 25% FTE: 25
0-50%	Nothing reported

If grade is 1-8:

If Attendance Calculation is QD: Quarter Day:

100% FTE

75% FTE

50% FTE

25% FTE

DL Percent Attended	'In Attendance - DL' Reported
1 or greater	100
.75-.99	75
.50-.74	50
.25-.49	25
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
1 or greater	75
.66-.99	50
.33-.65	25
0-.32	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
1 or greater	50
.5-.99	25
0-.49	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
1 or greater	25
0-.99	Nothing reported

If Attendance Calculation is HW: Half Day/Whole Day:

If In Person Attended Minutes is greater than 0:

100% FTE

75% FTE

50% FTE

25% FTE

DL Percent Attended	'In Attendance - DL' Reported
1 or greater	100
.75-.99	75
.50-.74	50
.25-.49	25
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
.75-1 or greater	75
.50-.74	50
.25-.49	25
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
.75-1 or greater	50
.25-.74	25
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
.25-1 or greater	25
0-.24	Nothing reported

If In Person Attended Minutes = 0

100% FTE

75% FTE

50% FTE

25% FTE

DL Percent Attended	'In Attendance - DL' Reported
.75-1 or greater	100
.25-.74	50
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
.75-1 or greater	75
.25-.74	25
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
.75-1 or greater	50
.25-.74	25
0-.24	Nothing reported

DL Percent Attended	'In Attendance - DL' Reported
.25-1 or greater	25
0-.24	Nothing reported

Calculate total percent attended buy dividing Total Attended Minutes by Total Scheduled Minutes and store this value.
Calculate the number of in person absent and distance learning absent minutes a student has and store each value.
1. In person absent minutes are when a student has an attendance code with an Absent Status of 'Absent' and the state code is not 'DLA'.
2. Distance learning absent minutes are when a student has an attendance code with a state code of 'DLA'.
If Distance Learning Absent Minutes = 0, then do nothing.
1. Stop processing here as no 'Absence - DL' should report.

If In Person Absent Minutes = 0,

Report 'Absence - DL' value based on the tables below using Total Percent Attended (rounded to two digits using normal rounding rules), student's FTE, and student's grade (Note, this value should match what was reported in Event Duration * 100)

If grade is KG or UE:
- If Kindergarten code is A: Half Day Every Day:
  Total Percent Attended
  'Absence - DL' Reported
  26% or more
  Nothing reported
  0-25%
  100/75/50% FTE: 50
  25% FTE: 25
- If Kindergarten code is one of the following:
  - B: Full Day Every Other Day
  - C: Full Day 3 Days a week
  - D: Full Day Every Day Spring-Only
  - E: Full Day Every Day
  - F: Full Day Every Day Title 1
    Total Percent Attended
    'Absence - DL' Reported
    51% or more
    Nothing reported
    0-50%
    100% FTE: 100
    75% FTE: 75
    50% FTE: 50
    25% FTE: 25

If grade is 1-8:

If Attendance Calculation is QD: Quarter Day:

100% FTE

75% FTE

50% FTE

25% FTE

Total Percent Attended	'Absence - DL' Reported
1 or greater	Nothing reported
.75-.99	25
.50-.74	50
.25-.49	75
0-.24	100

Total Percent Attended	'Absence - DL' Reported
1 or greater	Nothing reported
.66-.99	25
.33-.65	50
0-.32	75

Total Percent Attended	'Absence - DL' Reported
1 or greater	Nothing reported
.5-.99	25
0-.49	50

Total Percent Attended	'Absence - DL' Reported
1 or greater	Nothing reported
0-.99	25

If Attendance Calculation is HW: Half Day/Whole Day:

100% FTE

75% FTE

50% FTE

25% FTE

Total Percent Attended	'Absence - DL' Reported
.75-1 or greater	Nothing reported
.25-.74	50
0-.24	100

Total Percent Attended	'Absence - DL' Reported
.75-1 or greater	Nothing reported
.25-.74	25
0-.24	75

Total Percent Attended	Total 'Absence - DL' Reported
.75-1 or greater	Nothing reported
.25-.74	25
0-.24	50

Total Percent Attended	'Absence - DL' Reported
.25-1 or greater	Nothing reported
0-.24	25

Stop processing here as all values have reported.

If In Person Absent Minutes and Distance Learning Absent Minutes are both greater than 0.

Calculate in person percent absent by dividing in person absent minutes by total scheduled minutes.

If in person percent absent + total percent attended is greateer than or equal to 1, then do nothing.
- Stop processing here as no 'Absence - DL' record should report.

If in person percent absent + total percent attended is less than 1, then do the following

Calculate distance learning percent absent by subtracting both in person percent absent and total percent attended from 1 and round to two digits using normal rounding rules.

Report 'Absence - DL' value based on the tables below using distance learning percent absent, student's FTE, and student's grade.

If grade is 1-8:

If Attendance Calculation is QD: Quarter Day:
100% FTE
75% FTE
50% FTE

DL Percent Absent
'Absence - DL' Reported
.51-.75
75
.26-.50
50
.01-.25
25

DL Percent Absent
'Absence - DL' Reported
.34-.65
50
.01-.33
25

DL Percent Absent
'Absence - DL' Reported
.01-.5
25
If Attendance Calculation is HW: Half Day/Whole Day:

100% FTE

75% FTE

50% FTE

DL Percent Absent	'Absence - DL' Reported
.75-.87	75
.5-.74	50
.25-.49	25

DL Percent Absent	'Absence - DL' Reported
.75-.87	50
.25-.74	25

DL Percent Absent	'Absence - DL' Reported
.25-.74	25

Student is in person or is AOI

If the student is not in a BLG, there is no 'Virtual Code Override' day event on the calendar, the student/calendar has an attendance type of 017, or the student has a local service type of T:AOI:

Do not report.

Was this helpful?

Arizona Ed-Fi Data v3.5 - Student School Attendance Events

Object Triggering for Negative Attendance

Object Triggering Logic for AOI Positive Attendance

Object Triggering Logic for Non-AOI Positive Attendance

Object Triggering for Learning Modality

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Event Queue Detail

Object Data Elements

Types/Descriptors

Attendance Event Category Descriptors

AZ Attendance Calculation Appendix

Event Duration Calculations

For ALL grade levels:

Half Day KG: Kindergarten or UE: Ungraded Elementary (Excluding Homebound Students)

Full Day KG: Kindergarten or UE: Ungraded Elementary (Excluding Homebound Students)

Grades 1-8 (Excluding Homebound Students)

Grades 9-12

Excludes/Defaults

For all calculations:

For the calculations in Appendix A:

Learning Modality

Student is 100% virtual for a day:

Student is virtual for part of the day

Student is in person or is AOI

Related Articles