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.

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 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.
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
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
schoolId	Relates the school associated with the attendance event.	Integer	Derived from: [Schools]School_Number [ReEnrollments]School_Number (Historical)	R
sessionReference/sessionIdentity Relates the session associated with the attendance event.				R
/schoolID	SchoolID – The student's school of enrollment on the date of the AttendanceEvent.	Integer	Derived from: [Schools] School_Number [ReEnrollments]School_Number (Historical)	R
/termDescriptor	The term for the session during the school year.	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation The smallest school term at the school that includes the date of the absence.	R
/schoolYearType	The identifier for the school year, for example, 2010-2011.	Type	Derived from: YearId for term selected in the PowerSchool UI	R
studentUniqueId	Relates the student associated with the attendance event.	String	[Students]State_StudentNumber Derived from: [Attendance]StudentID	R
eventDate	Date for this attendance event.	Date	[Attendance_Code]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_Code]Att_Comment	O

Back to top

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, Attendance Code, UIC, Last Publish Date, and Publishing ID.

studentSectionAttendanceEvent

This event resource represents the recording of whether a student is in attendance for a section.

Primary PowerSchool Source Data

[Attendance]
[Attendance_Code]
[CC]
[Sections]
[Terms]
[Period]

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.

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: 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/SectionIdentity The section in which the student is enrolled.				R
/schoolId	The school for the section's classroom.	Integer	Derived from: [Sections]SchoolID	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]Name If empty, then [Period]Period_Number	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 If empty, then 'OPEN'	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	[Sections]Course_Number Internal spaces in the course number are replaced with an underscore, and leading /trailing spaces are removed.	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	[Terms]Portion [Terms]Abbreviation	R
/schoolYearType	The identifier for the school year, for example, 2010-2011; must match SchoolYear in corresponding CourseOffering.	Type	[Terms]YearID	R
/uniqueSectionCode	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]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	Default = '1'	R
studentUniqueId	The student associated with the attendance event.	String	[Students]State_StudentNumber Derived from: [Attendance]StudentID	R
eventDate	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 As mapped to Descriptor on Ed-Fi Code Set Mappings page	R
attendanceEventReason	The reason for the absence or tardy.	String	[Attendance]Att_Comment	O

Back to top

Section Attendance Taken

This view captures information about the dates section attendance was taken by teachers as published in the SectionAttendanceTakenEvent resource within the Student Attenance category. The layout includes the School Name, Teacher Number, Staff Name, Course Number, Course Name, Section Number, Attendance Date, Last Publish Date, and Publishing ID.

sectionAttendanceTakenEvent

This event resource captures the attendance taken event for given section.

Primary PowerSchool Source Data

[Attendance]
[Attendance_Code]
[CC]
[Sections]
[Terms]
[Period]
[S_MI_SSF_TSDL_X]

Selection Criteria

Records are published if the following criteria are met:

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, at least one 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

The SectionAttendanceTakenEvent resource is dependent on the prior publishing of the following entities: Staffs and Sections.
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
calendarDateReference/CalendarDateIdentity				R
/educationOrganizationId	The school for which the calendar date is defined.	Integer	Derived from: [Section]SchoolId	R
/date	The month, day and year of the calendar date.	Date	[Attendance]Att_Date	R
SectionReference/SectionIdentity The section for which attendance was taken.				R
/schoolID	The school for the section's classroom.	Integer	Derived from: [Section]SchoolID	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]Name If empty, then [Period]Period_Number	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 If empty, then 'OPEN'	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	[Sections]Course_Number Internal spaces in the course number are replaced with an underscore, and leading /trailing spaces are removed.	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	[Terms]Portion [Terms]Abbreviation	R
/SchoolYearType	The identifier for the school year, for example, 2010-2011; must match SchoolYear in corresponding CourseOffering.	Descriptor	[Terms]YearID	R
/uniqueSectionCode	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]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	Default = '1'	R
staffUniqueId	The staff member recording the section attendance.	Integer	[S_MI_SSF_TSDL_X]repPIC	O
eventDate	Date for this attendance event.	Date	[Attendance]Att_Date	R

Back to top