Student Attendance
This category captures student daily and section attendance information as published within the Student Attendance category. The Student Attendance 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, and Grade Level along with the Attendance Date, Attendance Code, UIC, Last Publish Date, and Publishing ID.
studentSchoolAttendanceEvents
This event resource represents the recording of whether a student is in attendance for a school day.
Primary PowerSchool Source Data
- [Attendance]
- [Attendance_Code]
- [Calendar_Day]
- [Attendance_Conversion_Items]
- [Bell_Schedule_Items]
- [Code_Entity]
- [Terms]
Selection Criteria
Records are published if the following criteria are met:
- The student was published in the Student Parent category.
- The student has an enrollment for the attendance school as published in the Student Enrollment category.
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- 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.
Entity 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.
- 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: Student and StudentSchoolAssociation.
- LEAs and Schools may upload (publish) data to the Ed-Fi 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 |
|---|---|---|---|---|
attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, Excused absence. | Descriptor | [Attendance_Code]presence_status_cd [Code_Entity]ce_code | R |
eventDate | Date for this attendance event. | Date | [Attendance_Code]event_date | R |
| schoolReference | ||||
| /schoolId | The student's school of enrollment on the date of the AttendanceEvent. | [Students]schoolId [Reenrollments]schoolId | ||
| sessionReference | ||||
/schoolID | The student's school of enrollment for the session. | Integer | R | |
/schoolYear | The identifier for the school year, for example, 2010-2011. | Derived from [Terms]yearid + 1991 | R | |
| /sessionName | 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. | Derived from [Terms]schoolid [Terms]abbreviation [Terms]dcid | R | |
| studentReference | ||||
/studentUniqueId | The student associated with the attendance event. | String | [Students]State_StudentNumber | R |
attendanceEventReason | The reason for the absence or tardy. | String | [Attendance]att_comment, 1, 40 | O |
| eventDuration | The amount of time for the event as recognized by the school: 1 day = 1.0, 1/2 day = 0.5, 1/3 day = 0.33 | calculated from [Attendance_Conversion_Items]attendance_value or 1.0 for ATT_Mode_Daily | ||
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, and Attendance Code.
studentSectionAttendanceEvents
This event resource represents the recording of whether a student is in attendance for a section.
Primary PowerSchool Source Data
- [Attendance]
- [Attendance_Code]
- [Calendar_Day]
- [Code_Entity]
- [CC]
- [Sections]
Selection Criteria
Records are published if the following criteria are met:
- The student was published in the Student Demographic category.
- The section was published in the Master Schedule category.
- The student has an enrollment for the attendance section as published in the Student Enrollment category.
- StudentUniqueId must be populated in PowerSchool.
- 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.
- 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.
Report 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: Student, Section, and StudentSectionAssociation.
- LEAs and Schools may upload (publish) data to the Ed-Fi 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 |
|---|---|---|---|---|
attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, Excused absence. | Descriptor | [Attendance_Code]presence_status_cd [Code_Entity]ce_code | R |
eventDate | Date for this attendance event. | Date | [Attendance]event_date | R |
| sectionReference | ||||
/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 the corresponding CourseOffering. | String | [crs]course_number | R |
/schoolId | The school for the section's classroom. | Integer | [Schools]school_number | R |
/schoolYear | The identifier for the school year, for example, 2010-2011; must match SchoolYear in corresponding CourseOffering. | Type | [Terms]yearid + 1991 | R |
| /sectionIdentifier | A unique identifier for the Section, that is defined by the classroom, the subjects taught, and the instructors that are assigned. | [Sections]schoolid [Sections]course_number [Sections] section_number [Sections]dcid | ||
| /sessionName | 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. | [Terms]schoolid [Terms]abbreviation [Terms]dcid | ||
studentUniqueId | The student associated with the attendance event. | String | [Students]State_StudentNumber | R |
attendanceEventReason | The reason for the absence or tardy. | String | [Attendance]Att_Comment | O |