Student Attendance Data
This category captures student daily and section attendance information as published within the Student Attendance category.
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, Gender, and Grade Level along with the Attendance Date, Attendance Code, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentSchoolAttendanceEvent
This event entity represents the recording of whether a student is in attendance for a school day.
Primary PowerSchool Source Data
[Attendance]
[Attendance_Code]
[Att_Code_Code_Entity]
[Code_Entity]
[Transportation]
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, tardy, or left early code, or at least one meeting attendance record with an absence code.
Entity Output
A separate studentSchoolAttendanceEvent record is published for each student, each school of enrollment, and each date on which the student was reported with an absence, tardy, or left early code.
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.
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' and total minutes in attendance is less than 195, or less than 120 for grades less than or equal to grade 1.
No attempt is made to generate daily tardy records from meeting-to-daily conversion.
The studentSchoolAttendanceEvent entity 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 |
|---|---|---|---|---|
attendanceEvent | M | |||
/eventDate | Date for this attendance event. | Date | [Attendance]Att_Date | M |
/attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, or Excused absence. For the list of codes that are published, refer to Attendance Codes. | Descriptor | Derived from: [Attendance_Code]Att_Code [Attendance_Code]Presence_Status_Cd [Code_Entity]CE_Code [Transportation] | M |
/attendanceEventReason | The reason for the absence or tardy. | Varchar(40) | [Attendance]Att_Comment | O |
studentReference/studentIdentity | Relates the student associated with the attendance event. | Integer | StudentUniqueId downloaded from State Derived from: [Attendance]StudentID | M |
schoolReference/schoolIdentity | Relates the school associated with the attendance event. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
sessionReference/sessionIdentity Relates the session associated with the attendance event. | M | |||
/schoolReference/schoolIdentity | The student's school of enrollment on the date of the attendanceEvent. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/schoolYear | The identifier for the school year, for example, 2010-2011. | Enumerated List | [Terms]YearID | M |
/term | The term for the session during the school year. | Enumerated List | 'Year Round' | M |
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, Grade Level, Course Number, Course Name, and Section Number, along with the Attendance Date, Attendance Code, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
studentSectionAttendanceEvent
This event entity represents the recording of whether a student is in attendance for a section.
Primary PowerSchool Source Data
[Attendance]
[Attendance_Code]
[Sections]
[Att_Code_Code_Entity]
[Code_Entity]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student 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 an absence or tardy attendance record for the class section.
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 entity is dependent on the prior publishing of the following resources: student and studentSectionAssociation.
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 |
attendanceEvent | M | |||
/eventDate | Date for this attendance event. | Date | [Attendance]Att_Date | M |
/attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, or Excused absence. For the list of codes that are published, refer to Attendance Codes. | Descriptor | Derived from: [Attendance_Code]Att_Code [Attendance_Code]Presence_Status_Cd [Code_Entity]CE_Code | M |
/attendanceEventReason | The reason for the absence or tardy. | Varchar(40) | [Attendance]Att_Comment | O |
/educationalEnvironment | The setting in which a child receives education and related services. This attribute is only used if it differs from the Educational Environment of the section. | Enumerated List | [S_TN_SEC_X]ClassType T: 'Classroom' P: 'Pull-out class' C: 'Self Contained' | O |
studentReference/studentIdentity | The student associated with the attendance event. | Integer | StudentUniqueId downloaded from State Derived from: [Attendance]StudentID | M |
sectionReference/sectionIdentity The section in which the student is enrolled. | M | |||
/locationReference/locationIdentity The location, typically a classroom, where the section meets. | M | |||
//classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | Varchar(20) | [Sections]Room Default: ‘OPEN’ | M |
//schoolReference/schoolIdentity | The school for the section’s classroom. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/classPeriodReference/classPeriodIdentity The class period during which the section meets. | M | |||
//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. | Varchar(20) | [Period]Period_Number Derived from: [Section_Meeting]Period_Number | M |
//schoolReference/schoolIdentity | The school associated with this period. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/courseOfferingReference/courseOfferingIdentity The course offering taught in the section. | M | |||
//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. | Varchar(60) | If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number +’_’+ Section DCID Otherwise, [Sections]ID | M |
//term | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match term in corresponding courseOffering. | Enumerated List | [Sections]TermId [Terms]Portion [Terms]Abbreviation | M |
//schoolYear | The identifier for the school year, for example, 2010-2011. This must match schoolYear in corresponding courseOffering. | Enumerated List | [Terms]YearID | M |
//schoolReference/schoolIdentity | The school offering the course; must match schoolID in corresponding courseOffering. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
Section Attendance Taken
This view captures information about the dates section attendance was taken by teachers as published in the SectionAttendanceTakenEvent entity within the Student Attendance category. The layout includes the School Name, Teacher Number, Staff Name, Course Number, Course Name, Section Number, Attendance Date, Last Publish Date, and the Publishing ID.
sectionAttendanceTakenEvent
This event entity captures the attendance taken event for given section. There is no universal tracking of when or whether attendance was taken for a section on a particular date in PowerSchool. This entity is published from two sources of available data:
At least one [Attendance] record exists for a student for the date and section, absent or present (but not future).
An [Attendance_Taken] record exists for the date and section
Primary PowerSchool Source Data
[Attendance]
[Sections]
[Attendance_Taken]
Selection Criteria
Records are published if the following criteria are met:
The school offering the section must not be excluded from state reporting.
The section must not be excluded from state reporting ("State_ExcludeFromReporting").
There is a record in the [Attendance_Taken] table or in the [Attendance] table for the section on the attendance date.
At least one student must be enrolled in the section.
The Day must be in-session with a membership value greater than 0.
The Section and Bell Schedule period are not excluded from ADA.
There is a cycle day for the day in Calendar Setup.
The Day is within the section's term.
Entity Output
A sectionAttendanceTakenEvent record is published for days where the section is offered from the first in-session date to the most recent in-session date, up to the date published.
The sectionAttendanceTakenEvent entity is dependent on the prior publishing of the following resources: staff and section.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/sectionIdentity The section for which attendance was taken. | M | |||
/locationReference/locationIdentity The location, typically a classroom, where the section meets. | M | |||
//classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | Varchar(20) | [Sections]Room Default: ‘OPEN’ | M |
//schoolReference/schoolIdentity | The school for the section’s classroom. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/classPeriodReference/classPeriodIdentity The class period during which the section meets. | M | |||
//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. | Varchar(20) | [Period]Period_Number Derived from: [Section_Meeting]Period_Number | M |
//schoolReference/schoolIdentity | The school associated with this period. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/courseOfferingReference/courseOfferingIdentity The course offering taught in the section. | M | |||
//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. | Varchar(60) | If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number +’_’+ Section DCID Otherwise, [Sections]ID | M |
//term | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | Enumerated List | [Sections]TermID [Terms]Portion [Terms]Abbreviation | M |
//schoolYear | The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Enumerated List | [Terms]YearID | M |
//schoolReference/schoolIdentity | The school offering the course; must match schoolID in corresponding courseOffering. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
calendarDateReference/calendarDateIdentity | M | |||
/date | The month, day, and year of the calendar date. | Date | [Attendance_Taken]Att_Date or [Attendance]Att_Date | M |
/educationOrganizationReference/ | The school for which the calendar date is defined. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
eventDate | The month, day, and year for the section attendance taken event. | Date | [Attendance_Taken]Att_Taken_DT or [Attendance]Att_Date | O |
staffReference/staffIdentity | The staff member recording the section attendance. | Integer | [CST_PubUniqueIdStaff]UniqueId Derived from: [Sections]Teacher | O |