Student Section Attendance Events (New Mexico v3.5)

Tool Search: Ed-Fi

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

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 on the course section and the Attendance Status + Attendance Excuse combination is mapped to an Ed-Fi code. OR Student is in a blended learning group that has an event on the calendar on the reported day. The student must have a Student Section Association record to report. Unknown attendance events will not send an event to ed-fi. The original post will not trigger until an excuseID is entered in the attendance table. 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, Section and Attendance Event Category Descriptor. Do not send records if attendance records are associated with a School when the Exclude checkbox is checked. Do not send records if attendance records are associated with an Enrollment marked 'State Exclude'.
Delete/Post	If any part of the natural key is changed: Section Reference, Student Reference, Event Date, Attendance Event Category Descriptor. 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 not allow updates in Ed-Fi.
Delete	Delete if all the attendance records with the same Date & Descriptor are deleted.
Delete	When an enrollment is deleted.
Delete	If the student is removed from the course section.
Put	If 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.

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 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/Delete	Cascading Updates: N/A, there are no dependent resources

Action

Trigger

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/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 Event Category Descriptors	Attendance Status and Excuse Positive Attendance

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	Database Field
id	The unique identifier of the resource.		M
attendanceEventCategory Descriptor	Key for Attendance Event Category Type.	If student is in a blended learning group that has a day event on the calendar on the date being reported and there are no attendance codes entered for the period, report Ed-Fi code 'RMTEATTD'. If attendance code on the period is mapped to Ed-Fi Code 'Excused Absence': Report mapped Ed-Fi code. If attendance code on the period is mapped to Ed-Fi Code 'Unexcused Absence': Report mapped Ed-Fi code. Note: Present minutes are ignored with this logic. If an absent code exists on the period, it is sent.	M
eventDate	Date for this attendance event.	Enter the date for the attendance record being reported .	M	attendance.date
sectionReference	A 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.	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 blank, do not report. For negative attendance with multiple comments: If there is more than 1 comment entered for that day and the records have different status/excuse codes, report the comment from each record. If there is more than 1 comment entered for that day and the records have the same status/excuse codes, report the comment from the highest periodID. For positive attendance withe multiple comments: If there is more than 1 comment entered for that day, report the comment from the attendance record with the latest start time.	O	attendance. comments
classPeriods	A reference to the related Class Periods resource.	Reports the fields that are part of the Natural Key for the Class Period resource.	M
educationalEnvironment Descriptor	Key for EducationalEnvironment.	Do not report, this is optional.	O
etag	A unique system-generated value that identifies the version of the resource.	Do not report, this is optional.	O

Type/Descriptor

Click here to expand...

Attendance Descriptors

Ed-Fi code	Namespace	Description
EFDCO	uri://nmped.org/AttendanceEventCategoryDescriptor	Excused Full Day Absence Religious or Cultural Observance
EHDCO	uri://nmped.org/AttendanceEventCategoryDescriptor	Excused Half Day Absence Religious or Cultural Observance
Excused Absence	uri://nmped.org/AttendanceEventCategoryDescriptor	Excused Absence
RMTEATTD	uri://nmped.org/AttendanceEventCategoryDescriptor	Attended Remote Learning
Unexcused Absence	uri://nmped.org/AttendanceEventCategoryDescriptor	Unexcused Absence
UNFDCO	uri://nmped.org/AttendanceEventCategoryDescriptor	Unexcused Full Day Absence Religious or Cultural Observance
UNHDCO	uri://nmped.org/AttendanceEventCategoryDescriptor	Unexcused Half Day Absence Religious or Cultural Observance