• Home
  • Reporting
  • Ed-Fi
  • Ed-Fi State Information
  • Arizona Ed-Fi
  • Arizona Ed-Fi v3.3 Resources

Arizona Ed-Fi Data v3.3 - Student School Attendance Event

Classic ViewSystem 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

Object Triggering Logic for AOI Positive Attendance

Object Triggering Logic for Non-AOI Positive Attendance


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.


Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Attendance Status and ExcuseAttendance Event Category Descriptors


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

attendanceEvent
Category
Descriptor 
Key for AttendanceEventCategoryType.

Reports when a student has a verified attendance status/excuse combination that is mapped to an Ed-Fi code.

MAttendance> 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
schoolReference 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
  2. Only report the Term Type from the Terms tab that is associated with the date and term schedule the attendance is being reported for.
M

student
Reference 
A reference to the related Student resource.

Reports the fields that are part of the Natural Key for the Student resource.


M

attendanceEvent
Reason 
The reported reason for a student's absence.

This is optional, does not report.

OAttendance> Commentsattendance.
comments
educational
Environment
Descriptor 
The setting in which a child receives education and related services.

This is optional, does not report.

O

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

See AZ Calculation Appendix below.

O

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.
  • Any course rosters tied to inactive trial records are excluded from the instructionalMinutes.
C

System Administration > Calendar > Calendar > Attendance Type


Student Information > General > Enrollments > Attendance Type

attendance
Unit table
etag A unique system-generated value that identifies the version of the resource.
O

AZ Attendance Calculation Appendix


Type/Descriptor