Nebraska Ed-Fi Data v3.1 - Student School Attendance Event

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.

ActionTrigger
Post

When a new attendance event is verified for a student based on data in the attendanceExcuse table.

  • 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.
  • Attendance must still be reported when a student is rostered in a course that is not state reported.
  • Unknown attendance events will not send an event to Ed-Fi. The original post will not appear until an excuseID is entered in the attendanceExcuse table.
  • Do not send records if the student's enrollment is marked as a No Show or State Exclude.
  • 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.
  • When the Secondary School field is populated, report the student's information from this new school as an override to the current school.
  • Do not send if the student in enrolled in a calendar marked as Summer School.
  • Do not send records if there is a day event on the calendar that makes the day non-instructional. A day event is considered non-instructional if the event code is NOT 01, 04, or 06 and the Duration field is equal to 100.
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 now allow updates in Ed-Fi.
DeleteDelete attendance record if all attendance is removed for the day.
DeleteWhen an enrollment is deleted or the No Show or State Exclude check boxes are checked.
DeleteWhen a day event is added to the Calendar that makes the day non instructional for the student. A day event is considered non-instructional if the event code is NOT 01, 04, or 06 and the Duration field is equal to 100.


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 will remain in the ODS but no new data will send.
ResyncIf 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.
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 will be deleted from the ODS.
ResyncIf 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.

ActionTrigger
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 occurs.


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 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 resources.


M

attendanceEventCategoryDescriptor Key for AttendanceEventCategoryType.
  1. Report 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 events.
  1. Enter the date  for the attendance record being reported.
M Attendance> Date attendance.date
schoolReference A reference to the related School resource.
  1. Reports the fields that are part of the Natural Key for the School resource.


M

sessionReference 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

studentReference A reference to the related Student resource.
  1. Reports the fields that are part of the Natural Key for the Student resource.


M

attendanceEventReason The reported reason for a student's absence.
  1. This is optional, does not report.
O

educationalEnvironmentDescriptor The setting in which a child receives education and related services.
  1. This is optional, does not report.
O

eventDurationThe portion of the day to which the attendance event applies. A value of 1.00 would indicate that the event was for the entire school day. A value of 0.25 would indicate that the event was for one quarter of the school day.
  1. Calculation: (Total absence minutes) \ (Total rostered Instructional minutes).
    • Subtract any Present Minutes from the Total Absence Minutes value, if they are entered for an absence period.
  2. If a day event shortens the day, this event duration must be considered in the attendance calculation.
    • If event makes 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.
C

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


Type/Descriptor

Click here to expand...

Attendance Event Category Descriptor

code Valuedescriptionshort Description
02Excused AbsenceExcused Absence
03Unexcused AbsenceUnexcused Absence
04TardyTardy
The following codes do not report:
01In AttendanceIn Attendance
05Early DepartureEarly Departure