Student Attendance

This category captures student daily and section attendance information and includes the following data views and resources:

Note: The district must configure Ed-Fi Code Set Mapping to map local attendance codes to Ed-Fi attendanceEventCategory descriptors. All absence codes should be mapped; present codes other than "Tardy" or "Left Early" are normally not mapped.

Daily Attendance

This view captures daily attendance information, reporting negative attendance for students marked absent or tardy as published in the studentSchoolAttendanceEvent within the Student Attendance category. The layout includes the School Name, Student Number, Student Name, and Grade Level along with the Attendance Date, Attendance Code, State Student Number, Last Publish Date, and the Publishing ID.

studentSchoolAttendanceEvent

This resource represents the recording of whether a student is in attendance for a school day.

Primary PowerSchool Source Data

• [Attendance]
• [Attendance_Code]
• [Attendance_Conversion_Items]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the student resource.
• The studentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The student must have an active school enrollment.
• The school must not be excluded from state reporting.
• The student has an enrollment for the attendance school as published in the Student Enrollment category.
• For attendance based on sections, the student has an enrollment in at least one course and section that are not excluded from ADA calculations (("NE_StateExcludeFromReporting" and "Exclude_State_Rpt_YN").
• On the date of the attendance event, the student must have a daily attendance record with an absence or tardy code, or have meeting attendance records where the absence percent is greater than zero.

Resource Output

• A separate studentSchoolAttendanceEvent record is published for each student, each school of enrollment, and each date on which the student was reported as absent or tardy for all or most of the day.
• Only negative attendance events (absent or tardy) where the event date is less than the current date for the current school year are included.
• Depending on the school's attendance configuration, the methods used to report studentSchoolAttendanceEvent include:
  • Records where [Attendance]Att_Mode_Code = 'ATT_ModeDaily'
  • Records where [Attendance]Att_Mode_Code = 'ATT_ModeMeeting' in conjunction with one or more conversion methods using [Attendance_Conversion_Items] and related tables
  • Raw minute conversion from student's schedule based on [CC], [Bell_Schedule] and related tables
• Attendance conversion from Meeting to Daily provides an attendance amount. As a default, if the converted attendance amount is greater than or equal to 0.5, the student is counted present for the day, otherwise absent for the day.
• No attempt is made to generate daily tardy records from meeting-to-daily conversion.
• The studentSchoolAttendanceEvent resource is dependent on the prior publishing of the following resources: student and studentSchoolAssociation.
• LEAs and Schools may upload (publish) data to the ODS on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Section Attendance

This view captures section attendance information and reports negative attendance for students marked absent or tardy as published in the studentSectionAttendanceEvent within the Student Attendance category. The layout includes the School Name, Student Number, Student Name, and Grade Level along with the Course Number, Course Name, Section Number, Attendance Date, Attendance Code, State Student Number, Last Publish Date, and the Publishing ID.

studentSectionAttendanceEvent

This event resource represents the recording of whether a student is in attendance for a section.

Primary PowerSchool Source Data

• [Attendance]
• [Attendance_Code]
• [Sections]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the student resource.
• The studentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The student must have an active school enrollment.
• The school must not be excluded from state reporting.
• The course must not be excluded from state reporting ("NE_StateExcludeFromReporting").
• The course must have a valid state course code.
• The section must not be excluded from state reporting ("Exclude_State_Rpt_YN").
• The course must not be excluded from Ed-Fi ([S_NE_CRS_X]ExcludeFromEdFi).
• The section must not be excluded from Ed-Fi ([S_NE_SEC_X]ExcludeFromEdFi).
• The student has an enrollment for the attendance section as published in the Student Enrollment category.
• On the date of the attendance event, the student must have at least one class section attendance record with an absence or tardy code.

Resource Output

• A separate studentSectionAttendanceEvent is published for each student, each course section of enrollment, and each date on which the student was reported as absent or tardy for the class.
• Only negative attendance events (absent or tardy) where the event date is less than the current date for the current school year are included.
• The studentSectionAttendanceEvent resource is dependent on the prior publishing of the following resources: student and studentSectionAssociation.
• LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.