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.
Districts can publish Student Resources on the basis of the current selection by selecting PUBLISH SELECTION - Publish records for current student selection. This option does not work if it is scheduled to run at a later time.
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, STN Number, Grade Level, Attendance Date, Attendance Code, Last Publish Date, Publishing ID, and Resource ID.
studentSchoolAttendanceEvent
This event resource represents the recording of whether a student is in attendance for a school day.
Primary PowerSchool Source Data
- [Attendance]
- [Attendance_Code]
- [Students]
- [ReEnrollments]
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 (Indiana Student Number) 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.
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.
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 | '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, STN Number, 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. The StudentSectionAttendance publishes attendance for physical and virtual/remote school enrolments.
Primary PowerSchool Source Data
- [Attendance]
- [Attendance_Code]
- [CC]
- [Sections]
- [Terms]
- [Period]
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 (Indiana Student Number) 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.
Entity 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 | '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 |