Student School Attendance Events (Texas v4.0)

Tool Search: 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

Action	Trigger
Post	Compare the student schedule against the Snapshot Time entered on calendar. Students who are marked absent in the period that contains the snapshot time are considered absent for the day. Attendance mark must be mapped to an Ed-Fi Code. Report attendance for each school for which the student has a Student School Association record. Attendance date must fall on or between enrollment start and end dates. Unknown attendance events do not send an event to Ed-Fi. The original post does 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 marked. Do not send records if attendance records are associated with a School when the Exclude checkbox is marked.
Delete	Delete attendance record if attendance is removed for the marking period that occurs during the Snapshot Time.
Delete	When an enrollment is deleted.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

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

Action	Trigger
Post/Delete	Natural Key Changes If the School Number/Ed-Fi School Number changes, a delete/post occurs with the cascading deletes from the School ID Change triggers. 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 occurs. Cascading Updates: N/A, there are no dependent resources

Action

Trigger

Post/Delete

Natural Key Changes

If the School Number/Ed-Fi School Number changes, a delete/post occurs with the cascading deletes from the School ID Change triggers. 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 occurs.

Cascading Updates: N/A, there are no dependent resources

Scope Year Logic

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 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 valid configuration.

Resource Preferences

Data Element Label	Mapping Needed
Attendance Status and Excuse	Attendance Event Category Descriptors

Event Queue Detail

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 Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi

Data Element Label	Business Requirement	Business Rules	M, C or O	Location
id	The unique identifier of the resource.		M
attendanceEvent CategoryDescriptor	Key for the Attendance Event Category Type.	Reports the mapped Ed-Fi Code.	M
eventDate	Date for this attendance event.	The date for the attendance record being reported.	M	Student Information > General > 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 Term	Reports the fields that are part of the Natural Key for the Sessions resource. Only reports 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
attendanceEventReason	The reported reason for a student's absence.	Reports the first 40 characters from the Comments entered in the Attendance being reported for that day. If more than 40 characters exist, add .... to indicate additional text not shown. If there is more than 1 comment entered for that day and they have the same status / excuse code, report the comment from the last period that contains a comment. If there is more than 1 comment entered for that day and the records have different status/excuse codes, report the comment from each record. Does not report if blank.	O	Student Information > General > Attendance > Comments attendance.comments
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.		O

Type/Descriptor

Attendance Event Category Descriptor

Code Value	Description	Namespace	Short Description
Early departure	Early departure	uri://ed-fi.org/AttendanceEventCategoryDescriptor	Early departure
Excused Absence	Excused Absence	uri://ed-fi.org/AttendanceEventCategoryDescriptor	Excused Absence
In Attendance	In Attendance	uri://ed-fi.org/AttendanceEventCategoryDescriptor	In Attendance
Partial	Partial	uri://ed-fi.org/AttendanceEventCategoryDescriptor	Partial
Tardy	Tardy	uri://ed-fi.org/AttendanceEventCategoryDescriptor	Tardy
Unexcused Absence	Unexcused Absence	uri://ed-fi.org/AttendanceEventCategoryDescriptor	Unexcused Absence