Arizona Ed-Fi Data v3.3 - Student Program Attendance Events

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This event entity represents the recording of whether a student is in attendance for a class that takes place during a specific program. It will depend on a student being rostered into a course with Positive Attendance enabled, and and a value saved in the new "21st CCLC" droplist on the Course level.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new positive attendance event is verified for a student in a course section with the "21st CCLC" droplist is filled in on the Course editor.
Post	The student must have a Student Section Association record to report.
Post	The attendance event should post for each day the student is in the program, regardless of when the calendar starts or what days are marked as instructional.
Post	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.
Post	Do not send records if the student's enrollment is marked as a No Show.
Post	Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
Post	A record will send for each distinct Date, Section and Attendance Event Category Descriptor.
Post	When a previously blank "21st CCLC" droplist is updated to have a value.
Delete/Post	When a previously <> NULL "21st CCLC" droplist is updated to have a different value.
Post	When an attenanceUnit record that is tied to a CCLC-reportable course is updated to delete='0'.
Put	N/A - only deletes and posts are sent for this Resource. 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 now allow updates in Ed-Fi.
Delete	Delete attendance record if all attendance is removed for the day.
Delete	When an enrollment is deleted or the No Show or State Exclude check boxes are checked.
Delete	If the student is removed from the course section.
Delete	When a previously <> NULL "21st CCLC" droplist is updated to NULL.
Delete	When the attenanceUnit record that is tied to the Student Program Attendance Events record is updated to delete='1'.

Scope Year Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Business Rule
Attendance will send to the configured 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.

Business Rule

Attendance will send to the configured 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.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

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
educationOrganization Reference	educationOrganizationId: EducationOrganization Identity Column	Report the value.	M
programReference	The Natural Keys of the Program resource. educationOrganizationId: EducationOrganization Identity Column type: Key for Program name: The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.	Report the following values: Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. If a mapping does not exist, do not report. Type: 'Support Program'	M	Course > Section > Course > 21st CCLC	Course. programType
studentReference	The Natural Keys for Students resource. studentUniqueId: A unique alphanumeric code assigned to a student.	Report the value.	M
attendanceEvent CategoryDescriptor	A code describing the attendance event, for example: Present Unexcused absence Excused absence Tardy.	Always report code value of '3', tied to 'In Attendance', as positive attendance only captures this type of event	M
attendanceEventReason	The reason for the absence or tardy.	Do not Report.	O
educationalEnvironmentType	The setting in which a child receives education and related services. This attribute is only used if it differs from the EducationalEnvironment of the Section. This is only used in the AttendanceEvent if different from the associated Section.	Do not Report.	O
eventDate	Date for this attendance event.	Report the value.	M	Student Information > General > Attendance > attendance record > Date
timeLogs	An unordered collection of studentProgramAttendance EventTimeLogs. This event entity adds the time component to a student program attendance participating	Report based on Array chart below.	O	Student Information > General > Attendance > Positive Attendance > positive attendance record	See chart below
_etag	A unique system-generated value that identifies the version of the resource.		O

Arrays

studentProgramAttendanceEventTimeLog

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
attendanceBeginTime	The time the student began attending this program service.	Report the "Time In" value of each positive attendance record tied to the section.	M	Student Information > General > Attendance > Positive Attendance > positive attendance record
attendanceEndTime	The time the student stopped attending this program service.	Report the "Time Out" value of each positive attendance record tied to the section, corresponding to a reported "Time In" value, if it exists.	O	Student Information > General > Attendance > Positive Attendance > positive attendance record

Type/Descriptor

Attendance Event Category Descriptor

Code Value	Short Description	Description
1	Excused	Excused
2	Unexcused	Unexcused
3	In Attendance	In Attendance