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.
studentSchoolAttendanceEvent
This view captures information about whether a student is in attendance for a specified school day.
Primary PowerSchool Source Data
[Attendance_Code]
[S_NM_ATC_X]
[Attendance]
[Students]
[Terms]
[Reenrollments]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student 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 at least one meeting attendance record with an absence code.
Resource Output
A separate studentSchoolAttendanceEvent record is published for each student, school of enrollment, and date on which the student was reported with an absence.
Only negative attendance events (absence, tardy, or left early) where the event date is less than the current date for the current school year are included.
The studentSchoolAttendanceEvent is dependent on the prior publishing of the following resources: student 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 |
|---|---|---|---|---|
studentReference | M | |||
/studentUniqueId | A unique number assigned to the student by the state. | String | StudentUniqueId downloaded from State Derived from: [s]State_StudentNumber | |
sessionReference | ||||
SchoolYear | The identifier for the school year, for example, 2021-2022. | Number | Derived from school year: The value will be the trailing year. For example, if the school year is 2021 - 2022, then the value will be 2022. | M |
SchoolID | The identifier assigned to student's school of enrollment on the date of the attendance event. | String | [Students]schoolId [Reenrollments]schoolId | M |
SessionName | The identifier of the academic session within the school year. For example, 2020/21, 2021 Summer. | String | Derived from [Terms]schoolid [Terms]abbreviation [Terms]dcid | M |
schoolReference | ||||
/schoolId | The identifier assigned to student's school of enrollment on the date of the attendance event. | Integer | [Students]schoolId [Reenrollments]schoolId | M |
/eventDate | Date on which the attendance event is triggered. | Datetime | [Attendance]Att_Date | |
/attendanceEventCategoryDescriptorId | A code describing the attendance event. If the absence is a religious or cultural observance, the following codes are published:
For all other negative attendances, Excused or Unexcused absences are published. Note: Tardy and Early Departure are not published as part of the resource. | String | Derived from: Attendance Conversion (for Meeting attendance) [Attendance_Code]Att_Code [Attendance_Code]Presence_Status_Cd [S_NM_ATC_X] CULTOBSABSENCE | |
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 |
|---|---|---|---|---|
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. Note: The localCourseCode logic (in the courseOfferings resource) has been updated and the localCourseNumber will now publish correctly for districts that are tracking the StateCourseCode in the Course Number field. | String | [crs]course_number | R |
/schoolId | The school for the section's classroom. | String | [Schools]school_number | R |
/schoolYear | The identifier for the school year, for example, 2010-2011; must match SchoolYear in corresponding CourseOffering. | Number | [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. | String | [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. | String | [Terms]schoolid [Terms]abbreviation [Terms]dcid | |
studentReference | ||||
/studentUniqueId | The student associated with the attendance event. | String | [Students]State_StudentNumber | R |
/eventDate | Date for this attendance event. | Datetime | [Attendance]event_date | R |
attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, Excused absence. | String | [Attendance_Code]presence_status_cd [Code_Entity]ce_code | R |
classPeriodReference | ||||
classPeriodName | String | |||
schoolId | String | |||