Nebraska Ed-Fi Data v3.5 - Student School Attendance Events [.2319 and previous]

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 the Attendance Status + Attendance Excuse combination 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. Report attendance for each school the student has a Student School Association record. 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.
Put	If the Attendance Event Reason is changed.
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 Number/Ed-Fi School Number changes, a delete/post will occur 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.
Post/Delete	Cascading Updates: N/A, there are no dependent resources

Action

Trigger

Post/Delete

If any part of the Natural Key Changes

If the School Number/Ed-Fi School Number changes, a delete/post will occur 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.

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 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 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 resources.		M
attendanceEventCategory Descriptor	Key for Attendance Event CategoryType.	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.	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
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.	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). Subtract any Present Minutes from the Total Absence Minutes value, if they are entered for an absence period. If a day event shortens the day, this event duration must be considered in the attendance calculation. If 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 need to be counted per skinnied course. For example: If a period is 90 minutes and there are 2 courses in this period, the total per course is 45 minutes. If both courses report no attendance, send '0' attendance minutes. If one course reports attendance and the other course does not, send 45 minutes (half of the total period). If both courses report attendance, send 90 minutes.	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 Value	description	short Description
04	Tardy	Tardy
05	Early Departure	Early Departure
06	Excused Absence: Disciplinary action, not receiving instruction	Excused Absence: Disciplinary action, not receiving instruction
07	Excused Absence: Illness/Medical	Excused Absence: Illness/Medical
08	Excused Absence: Non-instructional activity recognized by state, district, or School	Excused Absence: Non-instructional activity recognized by state, district, or School
09	Excused Absence: Transportation Not Available	Excused Absence: Transportation Not Available
10	Excused Absence: Other	Excused Absence: Other
11	Unexcused Absence: Student Skipping School	Unexcused Absence: Student Skipping School
12	Unexcused Absence: Other or Unknown	Unexcused Absence: Other or Unknown