Student School Attendance Events (Georgia v3.6.1)

Tool Search: Ed-Fi

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

NOTE: Georgia reports ONLY Negative Attendance. Positive attendance is NOT reported in Georgia.

NOTE: Georgia bases attendance off of the Attendance Aggregation Refresh Tool. This tool MUST BE RUN before performing a Student School Attendance Events resync.

NOTE: Any previously reported attendance records that were deleted from the ODS must have a manual resync of Student School Attendance Events to report those attendance records again. Triggers will NOT re-post these records unless attendance has changed on the date being reported.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When the Attendance Aggregation Refresh Tool updates the database. This can be done through a manual refresh or the automated process that occurs each night. 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 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 records if attendance records are associated with a School when the Exclude check box is checked Do not send records if associated with an Enrollment where State Exclude is checked.
Delete/Post/Put	A Delete/Post will occur if the natural key of the resource has changed. A Put will occur otherwise. When any of the following information on the AttDayAggregation table changes: scheduledMinutes absentMinutes unexcusedAbsentMinutes unexcusedOnlyAbsentMinutes When any of the following information on the Enrollment changes: Start Date End Date State Exclude
Delete	Delete attendance record if all attendance is removed for the day for that Attendance Event Category Descriptor
Delete	When an enrollment is deleted.

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.

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.

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 Event Category Descriptors	Attendance Status and Excuse Positive Attendance

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. Elements in bold are required.

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
attendanceEventCategory Descriptor	Key for AttendanceEventCategory Type.	Reports Unexcused Absence when there are more "Unexcused" minutes than "Excused" minutes. Unexcused minutes are minutes attributed to attendance codes with a Status of "Absent" and an Excuse of "Unexcused". Reports Excused Absence when there are more "Excused" minutes than "Unexcused" minutes. Excused minutes are minutes attributed to attendance codes with a Status of "Absent" and an Excuse of "Excused". In the event of a tie, report Excused Absence.	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
schoolReference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the School resource	M	System Administration > Resources> School
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
attendanceEventReason	The reported reason for a student's absence.	Report 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 record have different status/excuse codes, report the comment from each record. If blank, do not report.	O	Attendance> Comments	attendance.comments
educationalEnvironment Descriptor	The setting in which a child receives education and related services.	Do not report, this is optional.	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.	Reporting Logic: Reports 0.5 if the student was absent for at least half of the day, but less than the full day. Reports 1 if the student was absent for the full day. Notes: GA State Reported Attendance uses the Attendance Aggregation Refresh Tool to report attendance. To "refresh" the data in this table when you've made a change to attendance, you must run Attendance Aggregation Refresh. Once this process is completed the database will be updated with your changes. You can then run a manual Ed-Fi resync on Student School Attendance Events. Absence minutes are minutes where the Status is "Absent" and the Excuse is "Unexcused, Excused, or Unknown". Present Minutes are not included. Excuse of "Exempt" is not included.	M	System Administration > Attendance > Attendance Aggregation Refresh
etag	A unique system-generated value that identifies the version of the resource.		O

Type/Descriptor

Click here to expand...

attendanceEventCategoryDescriptor

Ed-Fi Code	Description	Namespace	Short Description
Excused Absence	Excused Absence	uri://gadoe.org/AttendanceEventCategoryDescriptor	Excused Absence
Unexcused Absence	Unexcused Absence	uri://gadoe.org/AttendanceEventCategoryDescriptor	Unexcused Absence