Student School Attendance Events (Nebraska v3.6)

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

  • Reports 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 report when a student is rostered in a course that is not state reported.
  • Unknown attendance events do not send an event to Ed-Fi. The original post does not display until an excuseID is entered in the attendanceExcuse table.
  • Does not send records when the student's enrollment is marked as a No Show or State Exclude.
  • Does not send records when attendance records are associated with a Calendar when the Exclude checkbox is marked.
  • A record sends for each distinct Date and Attendance Event Category Descriptor.
  • Does not send records when attendance records are associated with a School when the Exclude checkbox is checked.
Put

When the Attendance Event Reason is changed.

DeleteDeletes attendance record when all attendance is removed for the day for that Attendance Event Category Descriptor.
DeleteWhen 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.

ActionTrigger
NoneWhen a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data will send.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen 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.

ActionTrigger
Post/Delete

When any part of the Natural Key Changes

  • When the School Number/Ed-Fi School Number changes, a delete/post occurs with the cascading deletes from the School ID Change triggers.

  • When 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 results in a delete/post of Student School Attendance Events.
  • When the Attendance Status, Excuse or Date changes a delete/post occurs.
Post/DeleteCascading 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.

  • Data only sends 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 RequirementM, 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.
MAttendance > 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.

OAttendance > Comments

attendance.comments
educationalEnvironmentDescriptor The setting in which a child receives education and related services.

This is optional, does not report.
O
eventDurationThe 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 a day event shortens the day, this event duration must be considered in the attendance calculation.


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.

Example: When a period is 90 minutes and there are 2 courses in this period, the total per course is 45 minutes.


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

Type/Descriptor

Click here to expand...

Attendance Event Category Descriptor

code Valuedescriptionshort Description
04TardyTardy
05Early DepartureEarly Departure
06Excused Absence: Disciplinary action, not receiving instructionExcused Absence: Disciplinary action, not receiving instruction
07Excused Absence: Illness/MedicalExcused Absence: Illness/Medical
08Excused Absence: Non-instructional activity recognized by state, district, or SchoolExcused Absence: Non-instructional activity recognized by state, district, or School
09Excused Absence: Transportation Not AvailableExcused Absence: Transportation Not Available
10Excused Absence: OtherExcused Absence: Other
11Unexcused Absence: Student Skipping SchoolUnexcused Absence: Student Skipping School
12Unexcused Absence: Other or UnknownUnexcused Absence: Other or Unknown