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 the Attendance State Code is mapped to an Ed-Fi code or when a student has a Positive Attendance record and Positive Attendance is mapped to an Ed-Fi code.
|
| Put | When the Attendance Event Reason is changed. |
| Delete | Deletes attendance record when 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 | When a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data will send. |
| Resync | When 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. |
| Resync | When 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. |
| Resync | When 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.
| Action | Trigger |
|---|---|
| Post/Delete | When any part of the Natural Key Changes
|
| Post/Delete | Cascading Updates: N/A, there are no dependent resources |
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.
|
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 | M, C or O | Data Source GUI Path Database Field |
|---|---|---|---|
id | The unique identifier of the resources. | M | |
| attendanceEventCategoryDescriptor | Key for Attendance Event CategoryType. Reports the Ed-Fi Code from the Attendance Event (Code should be mapped to Ed-Fi codes). | M | v_AttDailyDetail.unexcused v_AttDailyDetail.tardies |
| eventDate | Date for this attendance event. 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 | |
| sessionReference | A reference to the related Session resource. Reports the fields that are part of the Natural Key for the Sessions resource. Only reports the Term Type from the Terms tool 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. When more than 40 characters exist, an ellipses (...) is added to indicate additional text not shown. When there is more than 1 comment entered for that day and they have the same status/excuse code, reports the comment from the last period that contains a comment. When there is more than 1 comment entered for that day and the record have different status/excuse codes, reports the comment from each record. When blank, this does not report. | O | Attendance > Comments attendance.comments |
| educationalEnvironmentDescriptor | The setting in which a child receives education and related services. This is optional, does not report. | O | |
| eventDuration | The portion of the day to which the attendance event applies. Calculation: (Total absence minutes) \ (Total rostered Instructional minutes). Subtracts any Present Minutes from the Total Absence Minutes value, when they are entered for an absence period. When an event makes a day 50% of a normal instructional day, and the student is absent during the 50% of that instructional day, they must report as absent the whole day. Note: When 2 courses are entered into the same period (a skinnied course), the total attendance period minutes are counted per skinnied course. When both courses report no attendance, 0 (zero) attendance minutes sends. When one course reports attendance and the other course does not, 45 minutes (half of the total period) sends. When both courses report attendance, 90 minutes sends. | C | |
| etag | A unique system-generated value that identifies the version of the resource. | O |
