Attendance
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:
Daily Attendance
This data view represents a detailed list of Daily Attendance successfully published to the ODS. This represents the recording of negative attendance for students, those marked absent or tardy for a school day. A 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. Records are published if the student was published in the student demographic data, the student's Wyoming unique identification code (UIC) is populated in PowerSchool, the student and the school are not excluded from state reporting and the student has at least one daily attendance record with an absence or a tardy code. The published view layout provides the School name, Student Number, Student Name, WISER ID, Grade Level, Attendance Code, Last Publish Date, Publishing ID, and Resource ID.
studentSchoolAttendanceEvents
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 student’s school of enrollment must not be excluded from state reporting.
- [enter remaining selection criteria]
Resource Output
- [enter resource output]
- 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
---|---|---|---|---|
schoolReference A reference to the related School resource. | ||||
/schoolId | Relates the school associated with the attendance event. | Integer | R | |
sessionReference A reference to the related Session resource. | ||||
/schoolId | The student's school of enrollment on the date of the AttendanceEvent. | Integer | R | |
/schoolYear | The identifier for the school year (e.g., 2010/11). | Integer | 'P_Yearid + 1991' | R |
/termDescriptor | The term for the session during the school year. | String | CST_PUBWORKFLOW_LIB.getTermTypeFY(p_profileid, 1, 'YR') | R |
studentReference A reference to the related Student resource. | ||||
/studentUniqueId | Relates the student associated with the attendance event. | String | CST_PUBWORKFLOW_LIB.getStudentUniqueIdBase(P_Profileid, S.DCID, S.State_Studentnumber) | R |
eventDate | Date for this attendance event. | Date | R | |
attendanceEventCategoryDescriptor | A code describing the attendance event, for example, Present, Unexcused absence, Excused absence. | String | R | |
attendenceEventReason | The reason for the absence or tardy. | String | [CST_PUBATTEND_DAILY_TMP]Reason | R |
Section Attendance
This data view represents a detailed list of Section Attendance successfully published to the ODS. This represents the recording of negative attendance for students, those marked absent or tardy in a section. A separate Student Section record 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. Records are published if the student was published in the student demographic data, the student's Wyoming unique identification code (UIC) is populated in PowerSchool, the student, school and section are not excluded from state reporting and the student must have at least one class section attendance record with an absence or tardy code.The published view layout provides the School Name, Student Number, Student Name, WISER ID, Grade Level, Course Number, Attendance Date, Course Name, Section Number, Attendance Code, Last Publish Date, Publishing ID, and Resource ID.
studentSectionAttendanceEvents
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 must not be excluded from state reporting.
- The student’s school of enrollment must not be excluded from state reporting.
- [enter remaining selection criteria]
Resource Output
- [enter resource output]
- 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
---|---|---|---|---|
sectionReference A reference to the related Section resource. | ||||
/schoolId | The school for the section’s classroom. | Integer | [Sections]DCID,0 'verify' | R |
/classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, or AB schedules). NEDM: Class Period. | String | CST_PUBWORKFLOW_LIB.formaPeriodNameBase(P_Profileid, P.DCID, P.abbreviation, P.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 | CST_PUBWORKFLOW_LIB.formaClassroomCodeBase(P_Profileid, sec.DCID, sec.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. | String | CST_PUBWORKFLOW_LIB.formaLocalCourseCodeBase(P_Profileid, crs.DCID, Crs.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 | CST_PUBWORKFLOW_LIB.formaSectionCodeBase(p_profileid, sec.DCID, p_orgid) | R |
/sequenceOfCourse | When a Section is part of a sequence of parts for a course, the number of 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 | ' P_Yearid + 1991' | R |
/termDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. | String | CST_PUBWORKFLOW_LIB.getTermTypeFY(P_Profileid, t.portion, t.abbreviation) | R |
studentReference A reference to the related Student resource. | ||||
/studentUniqueId | A unique alpha-numeric code assigned to a student. | String | [Students]State_studentnumber | R |
eventDate | Date for this attendance event. | Date | Not Publishing | R |
attendanceEventCategoryDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. | String | Not Publishing | R |
attendanceEventReason | The reason for the absence or tardy. | String | [CST_PUBATTEND_SECTION_TMP]Reason | O |