StudentSchoolAttendanceEvents
This event entity represents the recording of whether a student is in attendance for a school day.
Selection Criteria
-
This has dependency on Calendar, EducationOrganizationId, Student, StudentSchoolAssociation, and Session.
-
The student is 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 either a Daily Attendance or a Meeting Attendance record.
-
For remote enrollment, the student’s attendance conversion will follow the attendance conversion rules of their current (home) school, not the remote school. For example, if the school’s attendance conversion rule states that missing 3 periods equals an attendance value of 0.5, then the same applies to the remote course. If a student misses 3 classes in a remote course, their attendance will be recorded as 0.5, even if they were present in all classes at their current school that day.
Note:
-
The system will first attempt to publish Daily Attendance. If not available, it will then publish Meeting Attendance.
-
For full-day attendance, one record will be published.
-
For half-day attendance, two records will be published.
-
If multiple absence codes exist for the same day:
-
Choose the code with the maximum count.
-
If counts are equal, assign Excused.
-
Data Review
|
Field |
Selection |
|
Choose Dashboard |
Student School Attendance Events |
|
Choose Category
|
|
|
Choose Data view |
|
Resource Output
-
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.
-
See the Data Publishing > Published Resource > Resource Details to view the data elements that are not available in the Data View Column.
|
Ed-Fi Data Element |
Description |
Data View Column |
Submission |
[Table] Field Name
|
Business Rules |
|
AttendanceEventCategoryDescriptor |
The value representing the category of the attendance event. Valid values:
|
Attendance Event Category |
Y |
Derived from Attendance [PS_ADAADM_DEFAULTS_ALL]AttendanceValue |
The different codes in PowerSchool will be mapped by districts to either of the state valid codes through codeset mapping. |
|
eventDate |
The date for this attendance event. |
Event Date |
Y |
Derived from Calendar |
|
|
schoolReference |
The number that identifies the school in which the attendance event takes place. |
School Number |
Y |
[Schools]School_Number |
Derived From [Schools]School_Number Format: ttbbbdddd Org Id is defaulted to D=14. If the district wants another value to be published, then the district must prepend the above alphabet in their district number. |
|
sessionReference |
The name of the session during which the course or event takes place. |
Session Name |
Y |
Concatenated value of [TERMS]YearID and [Terms]Name |
Session Name format: School Year-Term Name If 2023-2024, then extract 2024 Session name is a string that represents any of the following time periods:
|
|
eventDuration |
The amount of time for the event as recognized by the school:
|
Event Duration |
Y |
Derived from attendance [PS_ADAADM_DEFAULTS_ALL]AttendanceValue |
Event duration is derived from below: Attendance (Present) Duration Rules
Absent Duration for the day is one minus Attendance (Present) Duration
|