Michigan Ed-Fi Data v3.1 - Student School Attendance Event
Last Modified on 10/22/2022 10:24 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 Logic
This table describes logic for triggering syncing of this object.
Action
Trigger
Post
When a new attendance event is verified for a student and has a mapped Ed-Fi Code that is more than 50% of the student's day:
Report attendance for each school the student has a Student School Association record for.
Attendance date must fall on or between enrollment start and end dates.
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 attendance records are associated with a Calendar when the Exclude checkbox is checked.
A record will send for each distinct Date and Attendance Event Category Descriptor.
Do not send records if attendance records are associated with a School when the Exclude checkbox is checked.
Put
N/A - only deletes and posts are sent for this Resource.
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 not allow updates in Ed-Fi
Delete
Delete attendance record if attendance is removed for the day and determined present minutes or present periods is 50% or more. MSDS Attendance Model for the day will need to be referenced.
Delete
When an enrollment is deleted or the No Show or State Exclude check boxes are checked .
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 will remain in the ODS but no new data will send.
Resync
If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be 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 will be deleted from the ODS.
Resync
If a mapping is changed in Resource Preferences, a resync will need 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 will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
The natural key changes for Student and Sessions will result in a delete/post of Student School Attendance Events.
If the Attendance Status, Excuse or Date changes a delete/post will occur.
Scope Year Logic
This table describes scope year logic of this object.
Logic
Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.
Data will only send for the years that have valid configuration.
Resource Preferences
This table describes the Resource Preferences of this object.
Data Element Label
Mapping Needed
Attendance Status and Excuse
Attendance Event Category Descriptors
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
attendanceEvent CategoryDescriptor
Key for Attendance Event Category Type.
Report the mapped Ed-Fi Code from the Attendance Event Category Descriptor:
If a day contains a mix of attendance statuses, report code associated with the majority of time/periods.
Business Rule
UI Path
If student's enrolled grade has an MSDS Attendance Model that is Minute Based or NULL use the following calculation:
Student Information > General > Enrollments > Grade Sys Admin > Calendar > Grade Levels > MSDS Attendance Model
Whole Day Present
Student SUM of absence minutes is 50% or less than the scheduled Instructional minutes for the day.
Whole Day Absent
Student SUM of absence minutes is more than 50% of scheduled Instructional minutes for the day.
If student's enrolled grade has an MSDS Attendance Model = Period Based use the following calculation:
Student Information > General > Enrollments > Grade Sys Admin > Calendar > Grade Levels > MSDS Attendance Model
Whole Day Present
Student is flagged as absent for 50% or less than the number of scheduled instructional periods for the day.
Whole Day Absent
Student is flagged as absent for more than 50% of scheduled Instructional periods for the day.
Absent is defined by the following attendance code combinations:
Status
Excuse
Absent
Excused
Absent
Unexcused
Attendance is calculated from the student's schedule in both attendance models.
Scheduled period must be marked as Instructional.
Course must be marked for Attendance.
Day must be marked as Instructional
M
v_AttDailyDetail.
unexcused
v_AttDailyDetail.
tardies
eventDate
Date for this attendance event.
Enter the datefor 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
sessionReference
A reference to the related Session resource.
Reports the fields that are part of the Natural Key for the Sessions resource.
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
studentReference
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.
O
educationalEnvironment Descriptor
The setting in which a child receives education and related services.
This is optional, does not report.
O
eventDuration
The amount of time for the event as recognized by the school: 1 day = 1, 1/2 day = 0.5, 1/3 day = 0.33.
This is optional, does not report.
O
etag
A unique system-generated value that identifies the version of the resource.
