Student School Attendance Events (New Mexico v3.5)
Last Modified on 10/21/2024 8:21 am CDT
Tool Search: 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 Student is in a blended learning group that has an event on the calendar on the reported day. - 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.
- Unknown attendance events will not send an event to Ed-Fi. The original post will not appear 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 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'.
|
Put | If 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 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 will occur.
|
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 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. Elements in bold are required.
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
id
| The unique identifier of the resource. | | M | | |
attendanceEvent CategoryDescriptor | Key for AttendanceEventCategory Type. | - If the student is in a blended learning group that has a day event on the calendar on the date in question and there are no attendance codes entered, report the Ed-Fi code 'RMTEATTD'.
- Sum total absent minutes (periods minutes - present minutes):
- If the total is greater than gradeLevel/Calendar/(240 for whole day):
- If mapped to Ed-Fi Code 'Excused Absence':
- If absence code has a state code of DCO, report the Ed-Fi code 'EFDCO'.
- Else, report the mapped Ed-Fi code.
- If mapped to Ed-Fi Code 'Unexcused Absence':
- If absence code has a state code of DCO, report the Ed-Fi code 'UNFDCO'.
- Else, report the mapped Ed-Fi code.
- Else, if the total is greater than gradeLevel/Calendar/(120 for half day) AND absence code has a state code of DCO:
- If mapped to Ed-Fi Code 'Excused Absence', report the Ed-Fi code 'EHDCO'.
- If mapped to Ed-Fi Code 'Unexcused Absence', report the Ed-Fi code 'UNHDCO'.
- Else, if student is in a blended learning group that has a day event on the calendar on the date in question, report the Ed-Fi code 'RMTEATTD'.
- Else, do not send record.
Notes: For period minutes to count, must meet the following criteria: - Section must be flagged as attendance-taking during an instructional period.
- Should a student have 2 attendance taking classes skinnied into one instructional period, absent minutes MUST NOT double.
| M |
|
|
eventDate | Date for this attendance event. | Enter the date for the attendance record being reported. | M | Attendance> Date | attendance. date |
schoolReference | A reference to the related School resource. | Report Ed-Fi School ID. | M | System Administration > Resources> School | |
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 | | |
attendanceEvent Reason | 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 |
educational Environment Descriptor | The setting in which a child receives education and related services.
| This is optional, does not report. | O | | |
eventDuration | The amount of time for the event as recognized by the school: 1 day = 1, 1/2 day = 0.5, 1/3 day = 0.33. | This is optional, does not report. | O | | |
etag | A unique system-generated value that identifies the version of the resource. | | 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 |