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

Click here to expand...

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

ActionTrigger
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:

  1. P: Primary Enrollment
  2. S: Partial/Ancillary
  3. 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.  
DeleteDelete attendance record if all attendance is removed for the day.

Object Triggering Logic for AOI Positive Attendance 

Click here to expand...

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.
ActionTrigger
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.

DeleteDelete 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

Click here to expand...

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.
ActionTrigger
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.

DeleteDelete 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

Click here to expand...

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.

ActionTrigger
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.

PutUpdate 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.

DeleteDelete 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.
DeleteDelete 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data remains in the ODS but no new data sends.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
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.

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
attendancePost/Put/DeleteThe 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 LabelBusiness RequirementBusiness RulesM, 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.
  1. Reports when a student has a verified attendance status/excuse combination.
  2. 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.
MAttendance >
Status + Excuse

attendance.

status


attendance.

excuse

eventDate Date for this attendance event.

Enter the date for the attendance record being reported.

MAttendance>
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.
  1. 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.

  2. 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

Click here to expand...

Attendance Event Category Descriptors

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


AZ Attendance Calculation Appendix

Click here to expand...

Event Duration Calculations

This is reported in Negative Attendance attendance reporting.

For ALL grade levels:

Click here to expand...

The following are not considered when calculating attendance:

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

The following are considered when calculating attendance:

  1. State Exclude flags on the enrollment, calendar, and grade levels
  2. Students who have absences during the year in which the 004 Absence Transaction is being generated.
  3. 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.
  4. Exclude Present Minutes from total minutes missed.
    • Student Information > General > Attendance
  5. 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'.
  6. Exclude Absence Types of: 'Tardy', 'Present', and 'Early Release'.
  7. Exclude Absence Status of: 'Exempt'.

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

Click here to expand...

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 AttendedAbsence Reported
      26% or moreDo not report student
      0 - 25%100/75/50% FTE: .50
      25% FTE: .25

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

Click here to expand...

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 AttendedAbsence Reported
51% or moreDo not report student
0 - 50%
  • 100% FTE: 1.00
  • 75% FTE: .75
  • 50% FTE: .5
  • 25% FTE: .25

Grades 1-8 (Excluding Homebound Students)

Click here to expand...

  1. 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% FTE75% FTE50% FTE25% FTE
    Percent AttendedAbsence 
    Reported    		Percent AttendedAbsence 
    Reported    		Percent AttendedAbsence 
    Reported    		Percent AttendedAbsence 
    Reported
    1 or greaterDo not report.1 or greaterDo not report.1 or greaterDo not report.1 or greaterDo not report.
    .75 -.99.25.66 -.99.25.5 -.99.250 -.99.25
    .50 -.74.5.33 -.65.50 -.49.5
    .25 -.49.750 -.32.75
    0 -.241


  • When 'Attendance Calculation' = HW: Half Day/Whole Day, report as follows:
100% FTE75% FTE50% FTE25% FTE
Percent AttendedAbsence ReportedPercent AttendedAbsence ReportedPercent AttendedAbsence ReportedPercent AttendedAbsence Reported
.75 - 1 or greaterDo not report.75 - 1 or greaterDo not report.75 - 1 or greaterDo not report.25 - 1 or greaterDo not report
.25 - .74.5.25 - .74.25.25 - .74.250 - .24.25
0 -.2410 -.24.750 -.24.5

Grades 9-12

Click here to expand...

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).

  1. Period 1 – 55 minutes (Absent)

  2. Period 2 – 60 minutes (Absent)

  3. Period 3 – 45 minutes (Absent)

  4. 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).

  1. Period 1 – 55 minutes (Present)

  2. Period 2 – 60 minutes (Present)

  3. Period 3 – 45 minutes (Present)

  4. 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).

  1. Period 1 – 30 minutes (Absent)

  2. Period 2 – 25 minutes (Present)

  3. Period 3 – 35 minutes (Present)

  4. Period 4 – 30 minutes (Present)

  5. Period 5 - 25 minutes (Present)
  6. 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).

  1. Period 1 – 30 minutes (Absent)

  2. Period 2 – 25 minutes (Absent)

  3. Period 3 – 35 minutes (Absent)

  4. Period 4 – 30 minutes (Present)

  5. Period 5 - 25 minutes (Present)
  6. 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).

  1. Period 1 – 55 minutes (Absent)

  2. Period 2 – 60 minutes (Absent)

  3. Period 3 – 45 minutes (Absent)

  4. Period 4 – 80 minutes (Present)

  5. Period 5 - 55 minutes (Present)
  6. 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).

  1. Period 1 – 30 minutes (Absent)

  2. Period 2 – 25 minutes (Absent)

  3. Period 3 – 35 minutes (Absent)

  4. Period 4 – 30 minutes (Present)

  5. Period 5 - 25 minutes (Present)
  6. 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.

     

  1. 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.

  2. 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.

  3. 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 FTEAbsence to Report
      1001
      75.75
      50.50
      25.25
  4. 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.
  5. If total attended minutes divided by 60 is < expected FTE hours, complete the following:
    1. 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.
    2. Calculate total scheduled hours by dividing total scheduled minutes by 60.
      • Note: Do NOT round this value.
    3. 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.
    4. Calculate percent attended by dividing total attended minutes by total scheduled minutes. Round to the second decimal place using normal rounding.
    5. Report absence value based on the student's FTE table below:
      100% FTE75% FTE50% FTE25% FTE
      Percent AttendedAbsence ReportedPercent AttendedAbsence ReportedPercent AttendedAbsence ReportedPercent AttendedAbsence Reported
      1Nothing reported1Nothing reported1Nothing reported1Nothing reported
      .75 -.99.25.66 -.99.25.50 -.99.25.0 -.99.25
      .50 -.74.5.33 -.65.50 -.49.5
      .25 -.49.750 -.32.75
      0 -.241

Excludes/Defaults

For all calculations:

  1. 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:

  1. 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:

Click here to expand...

  1. 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% FTE25% FTE
Absent Calculation'In Attendance - DL' to reportAbsent Calculation'In Attendance - DL' to report
.5Do not report.25Do not report
050025
  • Otherwise:
100% FTE75% FTE50% FTE25% FTE
Absent Calculation'In Attendance - DL' to reportAbsent Calculation'In Attendance - DL' to reportAbsent Calculation'In Attendance - DL' to reportAbsent Calculation'In Attendance - DL' to report
1Do not report1Do not report1Do not report1Do not report
.7525.75Do not report.75Do not report.75Do not report
.550.525.5Do not report.50Do not report
.2575.2550.2525.25Do not report
0100075050025

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: 

Click here to expand...

  1. 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.
  2. 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:
            1. Student is 75% FTE
            2. Period 1 - 28 minutes (Distance Learning Present)
            3. Period 2 - 33 minutes (Distance Learning Present)
            4. Period 3 - 38 minutes (Distance Learning Present)
            5. Period 4 - 33 minutes (Distance Learning Absent)
            6. Period 5 - 33 (In Person Present)
            7. Period 6 - 33 (In Person Present)
            8. Period 7 - 32 (In Person Present)
            9. 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)
            10. Total remaining hours calculation:
              • 2 remaining hours
                • FTE hours expected (3) - In Person Hours attended (1) = 2
            11. 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)
            12. 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:
            1. A distance learning attended period is a period that has an attendance code with a state code of 'DLP'.
            2. 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:
            1. 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.
            1. 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:
            1. Divide total distance learning attended minutes by total scheduled minutes and round to the second decimal place using normal rounding.

            2. Report 'In Attendance- DL' value based on the table below using percent attended and student's FTE:

              • 100% FTE

                Percent AttendedAbsence Reported
                1100
                .75 -.9975
                .50 -.7450
                .25 -.4925
                0 -.24Nothing 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

            3. Continue processing to determine what, if anything for 'Absence DL' should report.
  • 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 AttendedAbsence Reported
          1Nothing reported
          .75 -.9925
          .50 -.7450
          .25 -.4975
          0 - .24100
        • 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:
          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 (In Person Absent)
          5. Period 4 – 60 minutes (DL Absent)
          6. Period 5 – 55 minutes (DL Present)
          7. Period 6 – 55 minutes (DL Present)
          8. 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)
          9. Total remaining hours calculation:
            • 3 remaining hours
              • FTE hours expected (4) - In Person Hours attended (1) = 3
          10. 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
            0Nothing reported
            .01 -.2525
            .26 -.550
            .51 -.7575
            .76 - 1100
          • 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.

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

Click here to expand...

  1. Sum total scheduled minutes and multiply by student's FTE and store this value.
  2. 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.
  3. 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.
  4. 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
      1. 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


      2. If grade is 1-8:
        1. 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



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

          1. 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-.7450

            .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



          2. 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,
      1. 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)
        1. 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


        2. 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



        3. Stop processing here as all values have reported.

    • If In Person Absent Minutes and Distance Learning Absent Minutes are both greater than 0.
      1. 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
          1. 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.
          2. 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-.8775

                .5-.74

                50

                .25-.4925


                 

                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:

Click here to expand...

  1. Do not report.

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com