Student Section Attendance Events (Nebraska v3.6)

This event entity represents the recording of whether a student is in attendance for a class.

Set the State Code field in Attendance Excuse Detail editor for each attendance code being used in System Administration > Attendance > Attendance Codes.  This field needs to be populated with a code in order to send to NDE.

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.

  • The student must have a Student Section Association record to report.
  • Unknown attendance events do not send an event to Ed-Fi The original post does not trigger until an excuseID is entered in the attendance table.
  • Does not send records when attendance records are associated with a Calendar when the Exclude checkbox is checked.
  • A record sends for each distinct Date, Section and Attendance Event Category Descriptor.
  • Does not send records when attendance records are associated with a School when the Exclude checkbox is checked.
  • When the Secondary School field is populated, reports the student's information from this new school as an override to the current school.
  • Does not send when the student in enrolled in a calendar marked as Summer School.
  • Does not send records when there is a day event on the calendar that makes the day non-instructional. A day event is considered non-instructional when the event code is NOT 01, 04, or 06 and the Duration field is equal to 100.
Delete/Post

When any part of the natural key is changed:  Section Reference, Student Reference, Event Date, Attendance Event Category Descriptor.

  • When 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 not allow updates in Ed-Fi. 
Delete

When all the attendance records with the same Date & Descriptor are deleted.

DeleteWhen an enrollment is deleted.
DeleteWhen the student is removed from the course section.
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.
PutWhen the comments are updated.

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 Section natural key changes, a delete/post will occur with the cascading deletes from the Section Change triggers.

  • If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.

  • If the Attendance Status, Excuse or Date changes a delete/post will occur.
Post/DeleteCascading 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.

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

M
attendanceEventCategoryDescriptor Key for AttendanceEventCategoryType.

Reports when a student has a verified attendance status/excuse combination that is mapped to an Ed-Fi code.  


Reports when a student is given a positive attendance record for the course section and it is mapped to an Ed-Fi Code.

M
eventDate Date for this attendance event.

Enter the date for the attendance record being reported.
M

attendance.date


sectionReferenceA reference to the related School resource.

Reports the fields that are part of the Natural Key for the Section resource.
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 ellipsis (...) is added to indicate additional text not shown.
  • When there is more than one 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 blank, does not report.
For negative attendance with multiple comments:
  • When there is more than one comment entered for that day and the records have different status/excuse codes, reports the comment from each record. 
  • When there is more than one comment entered for that day and the records have the same status/excuse codes, reports the comment from the highest periodID.
For positive attendance withe multiple comments:
  • When there is more than one comment entered for that day, report the comment from the attendance record with the latest start time.
O
educationalEnvironmentDescriptor Key for EducationalEnvironment.

Does not report, this is optional.
O
etag A unique system-generated value that identifies the version of the resource.

Does not report, this is optional.
O

Type/Descriptor

Click here to expand...

Attendance Event Category Descriptor

Code ValueDescription
04Tardy
05Early Departure
06Excused Absence: Disciplinary action, not receiving instruction
07 Excused Absence: Illness/Medical
08Excused Absence: Noninstructional activity recognized by state, district, or School
09Excused Absence: Transportation Not Available
10Excused Absence: Other
11Unexcused Absence: Student Skipping School
12Unexcused Absence: Other or Unknown