Student Attendance Data
This category captures student daily and section attendance information as published within the Student Attendance category. The Student Attendance Data category includes the following data views and resources:
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, State Identifier, Grade Level, Attendance Date, Attendance Code, Last Publish Date, Publishing ID, and Resource ID.
studentSchoolAttendanceEvent
This event resource represents the recording of attendance taken by a teacher for a section..
Primary PowerSchool Source Data
- Attendance
- Attendance_Code
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The studentUniqueID must be populated in PowerSchool (Students.State_StudentNumber).
- On the date of the attendance event, the student must have a daily attendance record with an absence or tardy code, or at least one meeting attendance record with an absence code.
- The reported attendance code must be mapped to an Ed-Fi attendanceEvent descriptor value.
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 part 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
- Records with code-to-day attendance conversion, either ATT_ModeMeeting or ATT_ModeDaily
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 the student is counted as 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 entities: students, studentSchoolAssociation, and sessions.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" 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 related schools resource | R | |||
/schoolID | Relates the school associated with the attendance event. | Integer | Derived from: Attendance.SchoolID | R |
sessionReference A reference to the related sessions resource. | R | |||
/schoolID | The student's school of enrollment on the date of the AttendanceEvent. | Integer | Derived from: Terms.SchoolID | R |
/schoolYear | The identifier for the school year. | Integer | Derived from: YearId for term selected in the PowerSchool UI | R |
/termDescriptor | The term for the session during the school year. | String | Published Value = 'Year Round' | R |
studentReference A reference to the related students resource. | R | |||
/studentUniqueID | Relates the student associated with the attendance event. | String | Students.State_StudentNumber | R |
eventDate | Date for this attendance event | Date | Attendance.Att_Date | R |
| attendanceEventCategory Descriptor | A code describing the attendance event, for example, Present, Unexcused absence, Excused absence. | Descriptor | Attendance_Code.Att_Code | O |
| attendanceEventReason | The reason for the absence or tardy. | String | Attendance.Att_Comment | O |
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, State Identifier, Grade Level, Course Number, Attendance Date, Course Name, Section Number, Attendance Code, Last Publish Date, Publishing ID, and Resource 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
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The section must not be excluded from state reporting.
- The studentUniqueID must be populated in PowerSchool (Students.State_StudentNumber).
- On the date of the attendance event, the student must have at least one class section attendance record with an absence or tardy code.
- The reported attendance code must be mapped to an Ed-Fi attendanceEvent descriptor value.
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 entities: students, sections, and studentSchoolAssociation.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" 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 A reference to the related sections resource. | R | |||
/schoolID | The school for the section’s classroom. | Integer | Derived from: | 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 | Derived from: Period.Abbreviation Period.Period_Name | 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 | 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; must match LocalCourseCode in corresponding CourseOffering. | String | Courses.Course_Number | R |
/uniqueSectionCode | A unique identifier for the Section, that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | Derived from: 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 | Published Value = '1' | R |
/schoolYear | The identifier for the school year. | Integer | Derived from: YearId for term selected in the PowerSchool UI | R |
/termDescriptor | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school; must match Term in corresponding CourseOffering. | Descriptor | Derived from Terms.Portion Terms.Abbreviation | R |
studentReference A reference to the related students resource | R | |||
/studentUniqueID | The student associated with the attendance event. | String | Students.State_StudentNumber | 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, Excused absence. | Descriptor | Attendance_Code.Att_Code | R |
| attendanceEventReason | The reason for the absence or tardy | String | Attendance.Att_Comment | O |
Section Attendance Taken
This view captures section attendance information taken by a teacher for a section. The layout includes the School Name, Course Number, Section Number, Attendance Date, Course Name, Teacher Number, Staff Name, Last Publish Date, Publishing ID, and Resource ID.
sectionAttendanceTakenEvent
This event resource represents the recording of attendance taken by a teacher for a section.
Primary PowerSchool Source Data
- Attendance
- Attendance_Code
Selection Criteria
Records are published if the following criteria are met:
- The school must not be excluded from state reporting.
- The section must not be excluded from state reporting.
- On the date of the attendance event, at least one student must have at least one class section attendance record with an absence or tardy code.
Resource Output
- A separate sectionAttendanceTakenEvent is published for each date where section attendance was recorded.
- The sectionAttendanceTakenEvent resource is dependent on the prior publishing of the following entities: students, sections, and studentSchoolAssociation.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" 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 A reference to the related sections resource. | R | |||
/schoolID | The school for the section’s classroom. | Integer | Derived from: | 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 | Derived from: Period.Abbreviation Period.Period_Name | 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 | 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; must match LocalCourseCode in corresponding CourseOffering. | String | Courses.Course_Number | R |
/uniqueSectionCode | A unique identifier for the Section, that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | Derived from: 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 | Published Value = '1' | R |
/schoolYear | The identifier for the school year. | Integer | Derived from: YearId for term selected in the PowerSchool UI | R |
/termDescriptor | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school; must match Term in corresponding CourseOffering. | Descriptor | Derived from Terms.Portion Terms.Abbreviation | R |
staffReference A reference to the related staff resource | O | |||
/staffUniqueId | A unique alphanumeric code assigned to a staff. | String | SchoolStaff.Users_DCID | R |