WY Prepare Student Attendance Summary Report
Contents
Introduction
The WY Prepare Student Attendance Summary provides aggregate data on attendance and membership information for all students enrolled during the reporting period. One record is created for each school and enrollment for a student. This information is published using the Student Attendance Summary object by the SIF agent. This is required for WDE600 submission via SIF.
The SAS data can be prepared at the district level. There can be only one instance of SAS data for a school in the district.
Note: Whenever the Student Attendance Summary table in PowerSchool is updated, all the previous records for that school year are deleted and new records are created.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:
- The student must not be excluded from state reporting.
- The student must be enrolled in a school included in the report.
- The student’s school enrollment Exit Date must occur after the report start date.
- The student’s school enrollment Entry Date must occur on or before the report end date.
- The school enrollment Exit Date must occur after the Entry Date.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
The report start date | Enter a date using the format mm/dd/yyyy for the first day of the report date range. |
The report end date | Enter a date using the format mm/dd/yyyy for the last day of the report date range. |
View the Student Attendance Summary Data
View the Student Attendance Summary (SAS) data through Direct Database Export (DDE):
- Click System on the Start page. The System Administrator page appears.
- Click Direct Database Export. The Direct Database Export page appears.
- Choose the StudentAttendanceSummary (200) table from the Current Table pop-up menu.
- Select all records in this table.
- Click either List View or Table View to view the records.
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | SAS Table Data Element | Description | [Table]FieldName |
1 | DCID | The Record ID for SIF. | Calculated |
2 | ID | The Record ID. | Calculated |
3 | StudentDCID | The Student Identification Number for SIF. | [Students]DCID |
4 | SchoolDCID | The School Identification Number for SIF. | [Schools]DCID |
5 | SchoolYear | The school year for which the information is applicable. | [Terms] |
6 | StartDate | The starting date for this attendance reporting period. | [Students]EntryDate [ReEnrollments]EntryDate |
7 | StartDay | The number of the school days represented in StartDate. | N/A |
8 | EndDate | The ending date for this attendance reporting period. | [Students]ExitDate [ReEnrollments]ExitDate |
9 | EndDay | The number of the school days represented in EndDate. | N/A |
10 | Resident | Indicates if the student's legal residence was within the boundaries of the school during the time between the StartDate and EndDate, inclusive. | [Students]State_StudentNumber (WISER ID) |
11 | DaysAttended | The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive. | Calculated: Membership Value – (Excused Absences + Unexcused Absences) |
12 | Excused | The number of days the student was absent from school with a valid excuse when school was in session between the StartDate and EndDate, inclusive. | Calculated |
13 | Unexcused | The number of days the student was absent from school without a valid excuse when school was in session between the StartDate and EndDate, inclusive. | Calculated |
14 | Membership | The number of days the student was enrolled when school was in session during the period between the StartDate and EndDate, inclusive. | Calculated |
15 | DaysTransportedEligibleStateAid | The days transported and eligible for state aid to be paid. | [Students]Student_Number |