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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
schoolReference A reference to the associated schools resource. | R | |||
/schoolID | The school associated with the attendance event. | Integer | SchoolID downloaded from State Derived from: [Students]SchoolID (current) [ReEnrollments]SchoolID (historical) | R |
sessionReference Relates the session associated with the attendance event. | R | |||
/schoolID | The student's school of enrollment on the date of the AttendanceEvent. | Integer | SchoolID downloaded from State Derived from: [Students]SchoolID or [ReEnrollments]SchoolID | R |
/schoolYear | The identifier for the school year, for example, 2010-2011. | Number | [Terms]YearID | R |
/termDescriptor | The term for the session during the school year. | String | [Attendance]Att_Date [Terms]Portion [Terms]Abbreviation | R |
studentReference A reference to the associated student resource. | R | |||
/studentUniqueID | The student associated with the attendance event. | Integer | [Students]State_StudentNumber Derived from: [Attendance]StudentID | R |
eventDate | The date for this attendance event. | Date | [Attendance]Att_Date | R |
attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, or Excused absence. | Descriptor | [Attendance_Code]Att_Code Mapped to Ed-Fi Descriptor | R |
attendanceEventReason | The reason for the absence or tardy. | String | [Attendance]Att_Comment | O |
attendanceDuration | The portion of the day to which the attendance event applies. A value of 1.00 indicates that the event was for the entire school day. A value of 0.25 indicates that the event was for one quarter of the school day. | Number | Calculated from [Attendance_Conversion_Items]Attendance_Value
Examples:
| R |
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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
sectionReference The section in which the student is enrolled. | R | |||
/schoolID | The school associated with the section. | Integer | SchoolID downloaded from State Derived from: [Sections]SchoolID | R |
/classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | String | [Period]Abbreviation If blank: [Period]Period_Number | R |
/classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | String | [Sections]Room If blank, default = 'OPEN' | R |
/localCourseCode | The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. This must match LocalCourseCode in corresponding CourseOffering. | String | [Courses]Course_Number | R |
/schoolYear | The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Integer | [Terms]YearID | R |
/termDescriptor | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | String | [Sections]TermId [Terms]Portion [Terms]Abbreviation | R |
/uniqueSectionCode | A unique identifier for the Section, that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | [Sections]Course_Number + '-' + [Sections]DCID | R |
/sequenceOfCourse | When a Section is part of a sequence of parts for a course, the number if the sequence. If the course has only one part, the value of this Section attribute should be 1. | Integer | '1' | R |
studentReference A reference to the associated student resource. | R | |||
/studentUniqueId | The student associated with the attendance event. | Integer | [Students]State_StudentNumber Derived from: [Attendance]StudentID | R |
eventDate | The date for this attendance event. | Date | [Attendance]Att_Date | R |
attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, or Excused absence. | String | [Attendance_Code]Att_Code Mapped to Ed-Fi Descriptor | R |
attendanceEventReason | The reason for the absence or tardy. | String | [Attendance]Att_Comment | O |